I want to use a Macro or Access code to change the
criteria filter of a query so the query displays
different record when the Macro is executed.

Does anyone know how to run a macro, when it is the first monday of each
month???
TIA,
_Bigred

I'm having trouble with creating this type of macro.  
Currently, the macro is set up as follows:
Condition: [Sponsor]="XXX"
Action: SetValue

Please can anyone help, I am trying to fetch a table from an excel sheet
and make it an array in a macro, Q1 Can I, if the answer is yes Q2 How
and  a little sample please

i've got several hundreds pages generated by 1 report. I
wish to export towards Word 2002 each page report into a
different  word file, with its own filename=sepecific
database record field.

I have a macro which drops a series of tables and relinks those same tables
from another database.  I want to condition the drop on the existence of the
table.
How do I do this in the macro condition column?

I have the following code that runs when this Database
starts. It is called from the OnOpen event of a form that
opens when the Database starts.  This Sub's function is to
open another database and then close.  I am doing this

I have a macro that runs several codes...and the last step
is to quit the application...so my macro looks like:
RunCode (function name: function1)
RunCode (function name: function2)

Ok, I thought this would be sooooo easy, maybe I just
don't understand.  I want to set up an "autoexec" macro
in an otherwise empty database.  I want that macro to go
out and run a macro in another database.  I need to

am creating a macro to export ups tracking number from a query. but the file
has to be .csv format. is there a way to set access to export a file as .csv
in a macro. can't seem to find it.
thanks,

I have a database where the last name is in all upper
case.  I need to pass through the database one time and
convert the last name field to proper case.
Any suggestions on how to do this?

Related to my prior post.
Here is my situation.  I have flat text files which appear
to be excel files, but which only contain the .xls
extension and no properties inherent to true excel files.  

Hi, I want to set the repeat count of a macro to be the number of records
in a table - what is the variable for this?
Cheers

Is there a way to edit macro's using the VB editor instead of the stupid
command list thing that Access 2000 uses?
Cheers,

I need to set up an input mask for a Date/Time data type
such that it will accept a year only if the month and day
are not available (e.g., __/__/1990).  I've tried using
the 99/99/0000 input mask, but it will not accept spaces