IO have created an output macro that runs a query and exports the
query to Excel. I use a form with a drop down list to set the
parameters for the query. I have tried to make it so that the filename
automatically becomes the field that is selected from the drop down

Simple question...
Is there a Macro name that access looks for before closing a DB, that acts
similar to AutoExec?

Does anyone have some code to open the startup options menu?
I have restricted access to this and I used to have a working code for
this button but I have lost it (somehow),
I just need a macro to launch the startup properties so I can edit my

I upgraded from Access 2000 to 2007.  I used SetValue a fair amount in 2000
in macros.  Now I see that action is missing in 2007.  Can anyone tell me
how I accomplish the SetValue action from 2000 Access 2007?

I've created a report in access. Now, I will like to know if is
possible to create an (action buttom or a link) on my desktop that
opens directly a report in access?
Any help on this will be very appreciated.

I need somebodies help :)
I have a recordset, that I fill with data:
#--
Set check_64000 = CurrentDb.OpenRecordset(clipstr2)

I have a macro that runs quite a few queries. Some of the queries take much
longer to run and don't actually need to run all the time.
How can I add a prompt or similar to a macro that does something like "Run
MAKE table query? Yes/No?"

I have prepared a form for my users to provide links to certain documents in
hyperlink fields.  I would also like to provide them with a button that will
open all of their hyperlinks at once, in one document, in a print preview
format.  I have some ideas, however, I can't even ...

I have recorded a Macro to format data and create and format a chart from
that data. I generally have 10 to 15 workbooks with data that need to be
handled with the same macro. I record the macro in the first workbook and
save it to a personnel macro workbook. But for each ...

I keep getting this error message:
The expression On Click you entered...a problem occurred while [database
name] was communicating with the OLE server of ActiveX Control. I did a shift
alt f11 and it displayes a 502473 in the bottom right-hand corner of the

I have a database which runs a ten second query to update certain tables
upon opening.  I wanted to warn people, so I created a form with a label
that says "please wait."
I have my opening macro open that form, run the query, close the form,

When I tried to run a macro to append data, it gave me this error.
Numeric field overflow.
What is this error and what to do to resolve it? Thanks.

I have a form which has various fields
Sample Number     Autonumber text box
BatchNumber        Combo Box
Other fields           Straight text boxes

I am building a macro in Access 2007 and the SetValue action is not available
in the Action value list to select.  I am working with a database that is in
a tusted location and I have even turned off all macro security in the Trust
Center, (MS Help mentioned to do this).

I have a run email macro button (sendobject) on a form.  Once all data is
entered into the form, it spills into a new record report. I want to email
the one record (data from the last form input)  only.  Right now it sending
all records in the report.  Does anyone have any ideas?