I saw a request dated back to feb/March of 2006 that could possibly
solve my issue but kind of left me a little lost on how to do it.  let me
back up and explain.  (Don't worry, I'll keep it simple.)
I'm trying to get my macro to read thru a query to the end (last record)

I am setting up a macro to run a number of tasks and one of which is to copy
data into a new worksheet based on a given criteria,  then creating a formula
in another column in the new worksheet based on the list copied. The problem
I have is that the no of records listed can vary ...

While in Access XP, can you program a command button to open another
database, and leave the current database open as well?

I have created tables, queries, macros in a database and when another user
tries to work in the database, the objects are read-only and cannot be
updated. Also, the macros will not run for other users. The read-only message
pops up. I put no restrictions on any of the work I have ...

I would like to create a macro which checks the postal code field and
returns a message if the entered information is not in Canadian postal code
format (e.g A2L 3G4).
In designing the macro I can get it to work and display the message "Please

I’m just getting started in Access and I love it.  I’m an Engineer Coast
Guard and we currently use MS Word to create an engineering status log.  I
have created the same log in Access all is well but my crew has one gripe,
macro's.  On the Word version of the log Macro's have been ...

A mystery: I have a macro that runs a 3 to 4 minute process. Near the end,
the macros runs code that copies / archives a query to two destinations. When
the module for this is run by itself, all works fine. But it doesn't run from
within the macro. I have double checked how the ...

I have a macro that runs a module to export a query as a .csv. Before the
export can complete, an error is posted which says in effect, "You have hit
the cancel button". I obviously did not. Is is possible that the "close"
action in the macro is truncating the export and not ...

My switchboard page is listed as an open object by page label.  I would like
to use the information as a condition in a macro.
My process will be to open a form from the switchboard, select dates and
other choices for query parameters, run a macro that has condition determined

I had a database that was created in Access 97 and I have imported it into
Access 2003.  My macro that used to work in Access 97 no longer works in
2003.  This is what is in the module:
DoCmd.OutputTo acOutputReport, "rptGrp224", acFormatRTF,

I want to use a marco to call/run a Sub statement from a form.  The marco
opens the form and then I want it call/run following Sub statement from a cmd
button.
cmdImportData_Click

Hello all,
I have created a button called 'Notify person' on a form. The purpose of
this button is to notify a member of staff when an entry into a table has
been made against his / her name.

Is there a command which will cause a Macro to repeat based on the number of
records in a table?

I am trying to make a button on a form that will open up another form
filtered by the data in the first form. when i create the button the wizard
pops up, but there are no fields listed on one side of the page where you
link the two forms.

Can anyone tell me the Macro code for linking a splash screen and switchboard
on startup of mdb database?