I have a form that has 2 combo boxes that are cascading lists Category &
ClassName.  If the ClassName doesn't exist in the list, the user enters the
class name (category remains blank).
I have designed a marco that searchs for any newly entered ClassNames by

I have several reports set up with parameter queries.  I need to print all of
these at once but have to continue inputting the dates for the query.  Can I
set up a macro to remember this value after I input it once.

I created a group option to present 3 choices for users and a macro to
setvalue to a text box for each choice to pass the parameters for my query.
My question is: how to clear the previous text boxes (or set them to Null)
if the user makes another choice after the previous ones?

I have a table (linked) that stores information that is only used in half of
the year.   I want to make a "spring cleaning" macro that copies the table,
for backup, and then clears the table.
I used the CopyObject table command and it made a copy of the table in the

How do I get a macro (in both Excel and Quattro Pro) to restart itself? That
is, what command do I need to make it loop?
Sorry for this - I'm sure - elementary question.
Thanks in advance to anyone who responds.

Good day,
I'm trying to figure out how I can create a macro condition for a delete
command within an Access Macro.  I want to delete a table if it exists, but
not attempt to delete the table if it doesn't exist...and therefore escape

I am a novice when it comes to Access 97.  I just need to know how I can keep
my macros from version 97 and moved them to access 2003 without losing them.

Is there any way to overrride the truncation on the text in the e-mail
messages which Access can generate (through a macro)?

Still can't get this.
I have a main menu form (MainMenu) on which there are two controls, a
dropdown (SelectedID) and a button.
The dropdown (SelectedID) does not have a control source because it is just

A step in my macro is to open a form where the record in the new form will
match the value selected on the first form's dropdown box.  The IDs,
unfortunately, are text and not numeric, so I'm having trouble finding the
right record in the set.

I am unable to import a .dbf file into access. I am using Transfer Database
action but it keeps giving errors. Seems that I am unable to interpret the
command properly. Can anybody please give me the syntax/command to import
the .dbf file???

I have made a macro which consists of a couple of make table and delete
queries. When I run the macro, every time the macro hits one of these
queries, it asks me to validate whether its OK to make or delete the table
just as it would have if the query had been running on its own. ...

I have a form with a dropdown box and button.  User should select a company
to view from the dropdown, then click the button to open a form with details
for that company.  Some companies won't have details yet, so if a record for
them isn't found, I want to create a new record for ...

I use a macro to send email files to another teacher who runs our In School
Suspension.  It works great, but the teacher changed this year.  I want to
know if there is a way I could, with the use of a form or something, be able
to change the email address on the macEmailIss macro ...

I would like to know how to create a macro which will print a selected report
to my .pdf converter. I would appreciate any help you can give. cheers.