I need to run a macro at a specific time every day. I'd rather not use Task
manager since this involves a secure database. I'd like to use a form that
will open as part of the AutoExec and remain open in the background all day.  
I've used the timer event before. Can you tell me ...

I have a very long macro consisting of several queries that all output to
print.  Some of those queries only return a couple of lines of text.  It is
wasteful of paper to print each query on separate page.  How can the macro
run the query (to get results I want) and print ...

This relates to access 2000. I have written some code in a module (it's
purpose is to clean up data in a .csv file prior to importing it into the
database) which I would like to be able to run from a access macro. Is this
possible? I see that there is a "OpenModule" option from ...

I want to export select table records from database1 to another database's
table (database2).  I have designed a select query in database1 to find the
desired records.  I have created a macro in database1 with the intent of
exporting the query results to a table in database2 but ...

When following the directions from the Access 2003 Help files on "Create a
form to enter report criteria", I cannot get the macro that the Access help
files documentation recommends to create for the "OK button" to run.
According to this help document, the macro utilizes the ...

Applies to Microsoft Access 2003
I have second hard drive installed on my PC which I have designated as a
backup drive for my CD collection, I've managed to copy my CDs using Media
Player and save the files as .wmv files, but now what I would like to do is

I have a simple form to print a special label and a table with a field that
contains the number of labels needed for each specific item. How do I get a
record for each label needed so that they can all be printed at once.
Paul

Without opening the database and running the macro manually, how would I set
a task to open the database and run the macro automatically?

I have a form to update records.  For each record that has been processed I
increase the value of a counter.  After the counter reaches 100 I want to run
a Macro that displays a Batch ID and resets the counter to start over.  Is
there some way I can run the Macro based on the ...

I want to run a query on a switchboard, but have been unable to run a new
macro as described by an earlier question.  What would the macro look like
that would enable me to open the query on the switchboard, and then display
the data corresponding to the users preference.  Thanks ...

I have read how unreliable they are, but I need to clear a table every time I
close a form.  The only way I can think of is by doing a send keys, I don't
want to delete the table just clear it.  Any suggestions or what are the send
keys for CtrlA and is there anywhere I can get a ...

I have a db w/two main tables that that need to be related "one to one."  The
1st table gets it's data imported entirely from another db.  The 2nd gets its
data manually input when this db is opened and updated.  This means that each
record in "Table 2" needs to have the SAME ...

I have an Access DB with a defined Startup Display Form.  I also want to
be able call a macro via Windows Scheduled Tasks using a command like like:
"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" "C:\MY
Documents\database.mdb" /x "macRunMe"

I have a macro that outputs an xls file to a folder on my hardrive.  The
macro fires off dalily at a specific time.  Everything works fine the first
time.  I would like to be able to delete the previous file just before the
the macro runs.  That way, it does not stop or prompt me ...

I am creating a macro to validate a user name and password for a login form.  
I created a unbound form which has a text box for username and a text box for
password.  The user will enter each text box and click on command button
"go".  For the command button, I want to create a ...