I am looking for the syntax for the condition for a macro
which would conditional on the day of the week.
I am using [Forms]![PerformanceStatus]![DAY]="Monday" but
this doesn't work.

I've got a form with 2 objects, one is a list of months, the other is
multi-select list box.
eg.X (Month)
1,2,3

I want to set up a shortcut that will pass a command to
access to run a function.
I can get the function to run whenever the access program
starts but I dont want that. I want the shortcut to

I've created a macro to print a report based on the
current record in the form the user is currently on.I've
attached this macro to a print/command button on the form.
[PRIOR APPROVAL CONTACT INFO]![PA reference code]=[Forms]!

I tried setting up a function to run when the database
opened via a shortcut that threw a /cmd switch.
But I couldn't get the short cut to accept the /cmd "Gino"
Switch so DUMBLY I removed the switch requirement from my

I would like to have a condition for a macro which is
determinate on a field whose format is the day of the
week (dddd).
ie

I generally get this error message "you attempted to open
a database that is already opened exclusively by user
Admin on machine ''. try again when the database is
available" even though I do not have it open on my

I would like to know how to
make a mailto hyperlink by clicking on the email address
on the ACCESS table.
Thanks

I have a request submission form for my users that calls up a macro when SUBMIT is clicked.  One of the macro actions is SendObject - this sends a short data table to me and my supervisor.  However, since the logic in one of the tables adds an AutoNumber as a unique identifier, ...

Ok so what i have is a button on a form that opens
another form. What i want to do is leave the original
form open, but in the background.
My problem is that when i try to get this done using the

I have a DeleteObject argument in my Macro but i only want it to run if the object is actually available to delete, otherwise i want to skip the delete object argument and move on to the next agument
Thanks in advance for any help.

For each occurance of a record in a particular table, I
want to execute a macro.  
The macro executes a SQL query and using the OutputTo
method, outputs the results to an Excel file.  

I made a macro in Excel that refreshes imported data from
an Access table.
Then I coded a macro in Access that executed the excel
macro. But often run up to 2 kinds of errors:

After creating the switchboard in the Switchboard Manager,
the form does not show up.  I have already created the
Switchboard Macros...any advice?
Leslie

I have a macro set to email reports to people.  The first line in my macro is SetWarnings, set to Yes (to turn warnings off).  When I run the macro, I get a box that says "A program is trying to automatically send e-mail on your behalf.  Do you want to allow this?"  Then I have ...