I would like to stop a macro running if a form isn't
open, any suggestions?
Regards
Rob

is there a way i can create a command in an access form
that opens a word document?

How can i insert animated gifs on Access forms?
Thank's
Paulo Jorge

A coworker and I have had a similar issue and are curious
if there is any kind of fix.  We both have all updates
installed on our machines, so we know its not a missing
service pack.  While running a macro, we use a SendObject

Good morning,
  I have done my security wizard and everything and have
differant users and such.  I would like to set up a macro
message box to pop up only when 1 user logs in, and a

Hello, can I use a Macro to automatically import data from
an Excel spreadsheet into a temporary table.  I am
assuming I would need to run VBA to do the import and then
have the macro run a query to append the data to from the

Please help in solving this problem in programmatically
exporting the file that has date fields.   Even though I
specified short date on the format from the Table Design
and when I clicked on the Advanced button thru the Export

I have the need to create a macro that runs a particular report.
The condition is that I need it to run ONLY if a particular range of
customer numbers is present.
For example the batch number DC12345 will have customer numbers beginning

I'm trying in a form to have some fields updated
automaticaly using a DLookup:
DLookUp("[TA000 - Customer]![Account
Name]","[TA000]","[Account]=Forms![F015 - Deals]!

Need help.
I have a form called Runtime bookings bound to a runtime
bookings table, on it is a check box called Complete
who's control source is chkComplete.

Access 2000
I've figured out how to create a macro that will export a
table to a .txt file using a static file name.  However, I
need for the resulting .txt file to be different every

I have two tables
Product Table contains: ProdID, QuantityInStock
Orders Table: OrderID, ProdID, Date, QuantityOrdered.
I need to run a macro that will calculate the

Hi - Access 2002, WinME
Two years ago Stve Schapel helped me create the function below to
automatically update a table in my SDG&E electrical meter database for data
downloaded from a website to my hard drive.

I have created a macro that runs 2 macros.
The first executes a batch files that takes 14 ASCII files
(with non-Access compatible extension), combines into one
file and renames the extension to .txt.

I am using the SendObject function send a report to
specific people. The e-mail addresses are stored in a a
field in the same table the report is based on.The table
is called Reversals Details.