How does one type the "CTRL" key and Function key using the Sendkeys??...
I'm trying to requery a form, and have tried the Requery command until I'm
blue in the face... I can occasionally get it to work if I run the requery
macro multiple times...

I would like to know how to create a macro with the following condition.  If
tick box is true (ticked) then a lookup column appears.  If tick box is not
ticked my lookup column does not appear on screen.
Can anyone help?

I have two distinct problems I want to execute a select query with the
following
   CurrentDb().QueryDefs("Query1").Execute
appears I cannot execute a select query with the above.

I have tableA and tableB I want to update tableB by reading each
record from TableA and before updating a record from TableA into
TableB I want to lookup three other tables and perform lot of if then
else kind of analysis.

I am using access97, windows 2k.
I have a macro that currently prints out a series of reports.
Is it possible for the same series of reports instead to be output as
attachments to a single email?

I have a button which runs a macro that prints a 9x12
envelope.  However, the envelope cannot be printed
through the envelope feeder on the default printer.  Does
anyone know how to code so you select which printer and

Is it possible to name a macro using more than three letters and to also give
it more than 3 keystrokes?  I have numerous macros to create that are
currently using 2-3 letter descriptions.  When I try to give it keystrokes
using ALT, it only lets me put in 2 letters.  Also, when ...

The specific question:
Is there any way i can suppress an error message that is generated by a step
in a macro so the macro can finish.
The Details:

I'm developing a database that allows end-users "A" to schedule appointments
for end-users "B".  Each end users in category "B" has it's own unique
employee code.  What I would like is for end-users "A" to schedule appts and
then click on a macro button to send an appointment ...

I have an Access 2002 db that has thousands of queries that get generated
with a script.  After time these queries are nolonger needed.  I would like
to delete them but I can only delete on at a time.  I am trying to write a
macro using the deleteobject command but it only allows ...

XP Home, Office 2000, Normal.dot feature has become corrupted, plus I have
several files of them (all different dates and sizes) when I click on My
Computer and should have only one.  I need to be able to copy and print
Normal.dot to see my AutoCorrect and AutoText entries to put ...

I want to daisy chain a few queries the situation I have is the
following:
Query1
Query2

I use Macros a lot on all by DB's.  When I open a report I have the macro
close the previous form, but when I close a report, how can I have it open
the form that I have the macro's on.??.
ie:  Open Report/Maximize/Close Form (the one w/ the macros on it.)

Hi Steve,
Thanks for your answer but when I try to do it, I receive the message:
"You can't compact the open database while running a macro or Visual Basic
code.

I have a macro that runs overnight that prints a large list of reports.  I
have several reports that need to have various copies printed on different
printers.  Is there a way to assign the printer on the macro level or do I
just need to make several copies of the same report ...