I am trying to prevent my append query from executing if the number of
records returned by a query (which is the first macro step) returns more than
one record.
DCount("[Tno]","TrucknoQuery")>1

I have a form where I require a prompt to appear if the chosen foeld is
empty upon lost focus. I have created a macro to run a simple message box but
I do not want it to run if the field is not empty.
I would appreciate your comments.

I am doing a Printer inventory and have two columns, type of cartridge and
the quantity. What I would like to do is when the quantity of each cartridge
goes below 3 when exiting, every time, a pop up warning “Inc is low for
cartridge X. Order more “shows up. So far I have it ...

Does anyone know if and how I can change my printer using an Access Macro
statement?  Not using a Macro, I presently have to manually do this each time
I generate a report and then select the printer I want when I Print the
report.  I'm actually outputting to a PDF file and I ...

I have a table that contains the address data of my clients. I
have  another table that contains project data. It is related to
my clients table. 1 client can have multiple projects.
Now I made a form that shows 1 client at the time and I can

I am trying to create a macro for a command button on my form. I think a
macro is the best way to go. I want to be able to find any record in my form
and delete it. But at the same time, I want to save it to a "deleted records"
table. Please help me put this together.

I am trying to combine two SendObjects in a Macro to email out only one
output rather than two outputs (One file is an excel file the other is a
report file).

how do you append info from one table to another upon recognition of a
certain word

Hi - hope someone can help me.
I have a form with 4 combo boxes.  Each combo box stores a piece of info
into the table.  But I need to be able to restrict what the users are
selecting.  For example if the field Service is selected, then I need the

how can disable the bypass key by writing a macro ?

Help only seems to describe how to name and save macros, but not
specifically how and where to describe the act of boldfacing.

I've used the TransferText method many times before, and have at times run
into a length limitation for the "FileName" parameter.  What I'm finding is
that the length is limited to 153 (Magical isn't it?), including the server
name, path, file name, and file extention.  For ...

I have a macro that contains the Output To command.  The command is supposed
to start the Excel application after the Output To action runs.  The
parameters for this command include:
1.  Object Type - Query

Using Acess 2003.  I have a database to create tranmittals.  Very often we
send the same things, or similar to the same person.  I want to create a new
record based on an exsiting record number (using an entry "form") and then be
able to edit the new record.  Any help would be ...

I have a query with a field that has 118 different values. I need to
filter by each of the 118 different values and export the results into
separate excel workbooks.
I would love a macro that does this...but I only have written macros