There is some documentation which seems to say that
if a macro is named autoexec it will run on startup in access97
i'm looking at a scheduler which lists the name of a macro in an
access project with a different name. It is called "agent"

My Database is for daily allocation of glaziers to execute
repair tasks. A Main Form frmGlazingOrderDetails contains
details of the tasks, with a start date and a finish date,
and it has a subform where the user selects glaziers on a

I am trying to use a sample on the MS assistance site to create a form to enter report criteria. I have followed all the steps very closely except for the actuall form, report and oblect names. When I enter thae data an press the button to run the macros, I get an error message ...

When the user enters an invalid entry into a combobox, I would like th
invalid entry highlighted.
me.value = highlighed (obviously not the solution)
How would one do this

This has to be a bug.
Create a new form called form1 and save.
Create a new macro.  Add setvalue, forms!form1.visible
false.  

I am trying to create a search form that will retrieve records displayed on another form.  What I want is a form that has several fields and one button.  The user should be able to enter as much information into the fields as he/she knows (leaving some fields blank) and click ...

Good morning from Detroit,
I have a macro set up to run an append query which is
making a duplicate of the selected record on a form.  It
runs using the "OpenQuery" action in a macro.  This is

Is there a function for accurate calculation of Age from DOB (Date Of Birth)
Thanks in Advance, Ilya.

I have a text box called Joining Status in which the letters J, F, or I can
be entered.
There is another text box which is called Initiated which is at present
always enabled.

In my macro, I have a Send Object command that sends
Access reports to several individuals.  However, when it
is about to send the report (during the macro run) I have
to click Yes EACH TIME to the following message prompt:

When I run my macro which makes a few tables and apends to
a table, I get the standard warnings like you are about to
delete a table or you are about to append records.  These
require input to proceed.  Can this be eliminated?  Maybe

Help!  Newby using Access 2000 is trying to write a macro
which will open another database.  I use the wizard,
select run command and then specify open database.  Where
do I indicate which database I am trying to open????

I have created a macro to dump data from 12 different
queries into 12 different Excel files.  That part works
great.
I have another Excel file (in the same folder) that is

I see that SetWarnings will accept the default i.e.
Yes 'prompt' - but say on one particular query in the
macro that I wish to select the No prompt.

Hi, I need help with Access. Could you please help me with creatio
Search Form. I?m trying to create search Form, I want when the I ente
the number in the field then click on search, other form open with th
result which read from query. I think there should be link between th