Good afternoon,
I have a situation where the content of a cell is based on what the active
cell is. This is to display a Help message. I know i could use the Data >
Validation > Message but this is not a good use for what we are trying to

Thanks for all the help I have received from this board. Anyway here is
another obstacle I have. I have form that when click a button on it a
report will be generated. Now is there a why to create another button
that will run the report more than 1 time. What I mean is before I have

I am using A97 and W2kpro.
I have a new PC that I am trying to set up exactly the same as an existing
PC.  On the existing PC outlook express is the default (and only) email
program, and I have no problem using the SendObject access macro command. On

The objective is to load the field “ExtPrice1” after Qty1 is entered (in one
table) using the UnitPrice from the Parts table. I thought a very simple
process, but...
If AfterUpdate(Qty1) is, “=[ExtPrice1]=Forms!Parts!UnitPrice*[Qty1]”, then I

I have about 50 append query's created that are based on both linked and
imported tables.  I have set up each append query to once refreshed to
repopulate my master table, however, I don't want to have to refresh the
query's daily.  How do I set something up to automate the ...

Can a macro create the following report:
Using this logic, ExternalSymbol(NewId"N") and ExternalSymbol(NewID "N+1")
are not equal AND
Duration1(NewID "N+1") is less than 0:00:05.

how can i open an excel worksheet by using a macro?

Is it possible to automatically change the spreadsheet name each time i
export data from an Access query using the OutputTo action? The output file
name needs to consist of (1) some literal values, (2) a variable entered into
the form the user uses to start the process, and (3) a ...

I wonder if anyone can shed light on my problem.
I have a report which I have been happily exporting to excel for a client.  
Quite suddenly with no logical explanation the export has stopped working and
I was using a send report macro.   I get a message "Action Failed" with the

I'm searching for the correct VBA expression to save something in the
same root like the current Access DB.
In Excel I think the expression for Access is "Activeworksheet.root".
Thanks

How do I create a macro that automatically provides a warning message when
the user opens the form.
cheers!

I've created a batch file to run some software which runs fine through
Windows (with some internet security changes). I desparately need to
incorporate this batch file into a macro to prevent a 30 min job becoming 4
hours through doing it manually and for other users to run.

I need to repeat a query many times to isolate data, my query prompts for the
appropriate criteria.  I want to create a macro that will re-run the make
table query and then rename the table and continue.  I will need to change
the name of the table after it is created, but I want ...

I have a subform (ACTIVITIES) within a form (END USER), which has
‘Distributor ID’ in the field list but not on the form.  I have ‘Distributor
ID’ in the field list of the parent form (END USER), which is selected using
the row source of a combo box.  The combo box takes the ...

I know I've done this in older versions of Access.
I use ImportDelimited, specify an ImportSpec, specify the target table, and
then type some clever text in the file name text box so that when the macro
runs, a file open dialog will be shown with which the user can hunt the