Re:Access 2003 - WinXP-SP2
I have a simple RunSQL statement that bombs.
Line 6:  The SQL on this line runs fine over in the SQLView of the
query designer and returns the 8 rows of data that it is supposed to

How can I get all of my MS Access form names into an Excel file?
         thanks,

I am working on a new database (A2k) and for the first time I am in need here of using an RTFControl.
I am testing the Lebans RTFControl (A2K RTF2 Sample Release 5-5)
This seems allright for my RTF-format-purposes.
But I also need to 'transport' the contents of some rtf-fields back ...

Hello,  I am in need of some help concerning hyperlinks.
I have this small database where the "front end" is part of a bigger database
and the actual data is in it's own "back end" file... only one table.  There
is one field with a hyperlink so the users can click on it and open a  ...

Hi All, hope someone can lead me in the right direction.  I am in new
territory and am unsure what to do after importing an Excel
Spreadsheet into my database.
1.  The same spreadsheet with new information will periodically be

Hey folks,
 I should be ashamed for not knowing the answer to this question -
but I don't get the opportunity to program all that much anymore...
I have a data tracking program used by over 150 users (not all at

I am attempting to fill in 2 memo fields in the same form, which is
fine, however the information on the second memo field is based on the
information on the first one, so I need to hold the cursor location in
the first memo field when I click to add details to the second memo

I have installed the front end for my database on several machines
(the front end is an mde), which links to a back end on a network
drive all my users have access to. To prevent mapping errors, the
links are done with the full network path (no shortcut letters).

Anyone ever try importing a DOS flatfile into MSAccess 2002 (SP3)?  The
flatfile works ok right now, but it's getting a bit too large (500+ records)
and needs to be updated.  I've made an extra copy and converted it to an
ASCII/TXT file, ran the Import wizard, adjusting the Import ...

Every time I open my application (written in MS 2003 after being
converted from a previous edition), I get the message "This file may
not be safe if it contains code that was intended to harm your
computer". I suppose not! My question is, how can I disable this

Is it possible to create Word-documents from Access 2003? I want to merge
data from Access with Word-templates and export them as Word-documents.
Can anyone give me a helpfull link?
Thanks,

How could I create a parameter query that will return values that partially
or whole match to a user input. For instance; if a user inputs "stu", it
should return values that have "stu" in it. Like "Student, Studio, stupid"
etc.Plase help.

I am running an import of some date/time values that have come from a
Cognos query.  These values are in a CSV file and I want to import
them into access.  The CSV file would show the value thus:
01/12/2007 3:15PM

How do I parse a file path in Access for return the file name?
Example
c:\somefolder\somefolder\somefolder\somefolder\somefolder\somefolder\somefolder\someFile.xls
I want to query a table with this value and just return 'someFile.xls" no

can anyone explain this ?
originally using access97 with a linked table to an mdb backend, to
create a worksheet using
        SELECT * FROM qryIPS WHERE location = 999