I need to have a column in a query that represent the relationship/position
of the row/record to the query.  The value for the 1st record would be 1, 2nd
record would be 2, and so on (simular to how Auto Number works for a table).
Anyone have any suggestion how I would accomplish ...

On attempting to run event driven code on a form in Access 2000, I get an
error message: "Module not found"
A  Microsoft Access class object wth the name "Form_Form2" appears in the
Visual Basic Editor. When clicking on "Form_Form2" in the VBE or when

I have a parameter query set up.  I would like to call the parameter query
from VBA code and pass the parameters to it.  The parametes are StartDate and
EndDate.
Can you share with me how I can accomplish this?  Thanks in advance.

My environment is access 2000 + dao 3.6. The following code, invoked in a
forms eventprocedure prints True ? ? . This is the case whichever record in
tabell I move to. Tabell is a Table without a primary key. How should I
access the correct bookmarks?

Can I save a Report - (Without opening it) in HTML format?
What is the code to do so?
I have 200 reports which I wish to perform this on.
Figured with the code I could Loop through the reports collection

I need to test to see if the user already has an existing WordPerfect
document open.  WordPerfect gives the user a read-only warning message but
still allows the user to open a 2nd instance of the file.  I need to prevent
this if only by forcing the application to set the focus ...

just to see if this can be done w/ a2k ---- i have a form which user uses to
enter startdate and stopdate which will limit the breadth of the report
generated by the 'Print' and 'Preview' report cmdbuttons on it. there is a
cmd button on the same form to 'Close' the report (when ...

I have a database scheduled which generates a report.  I need to e-mail it
from the schedule.  I have the
DoCmd.SendObject acSendReport, "Report",acFormatRTF,
"GEORGE.Grote@mittalsteel.com", , , "Report", , False  in a module, but

I am passing a script to ftp.exe (using Shell) to do these actions:
1. Dir the FTP folder, redirecting the Dir output to a text file
I then import the text file into a table and examine the contents to
determine if the correct files are available)

I have recently adopted a database that tracks users and I need to prevent
duplicates from being entered into a form.  I have tried using previous
threads, but I can't get them to work.  I am aware of the ability to prevent
duplicates through the table, but the error message it ...

I have a database that keeps records of accounts on our systems.  It is
located on a server and all users of the database hit that database through a
secured network connection.  The table is called "Names" and the form
"callqry", which calls up a specific account record.  I need to ...

I am trying to create a module so when I type in my product ID number the
serial number and description automatically fills in, but I am getting a
compile error: variable not defined. My code I wrote is:
Private Sub IDNo_AfterUpdate()

I have the following code and for some reason the counter variable
increments by 2 each time rather than 1.  Myself and a friend have
looked at it but cannot figure out the problem, any help would be
appreciated with this.  Text94 is a Yes/No Field if that makes any

in meiner Anwendung, Access 2003, möchte ich gerne Informationen die sich
während der Verarbeitung ergeben in die Zwischenablage kopieren. Ich habe
dazu versucht mit Do.Cmd.RunCommand acCmdCopy zurecht zu kommen. Habe aber
festgestellt, dass diese Methode nur funktioniert, wenn ...

We have an Access 2003 app that needs to interface to Outlook Everything is
working fine using the code snippet below, but one of the requirements is to
actually open an Outlook Send message window with the info from the
database. We can't see to find a method function to open ...