I have a number of Access 97 Databases that were poorly designed and contain
alot of extraneous garbage that needs to be cleaned up. The form UI consists
of MANY command buttons, all linked to another form, query or report or
event proc that calls any of those 3 through code. ...

I have created a form that uses a ComboBox that allows someone to select a
location.  This form also has 2 buttons - OK and Cancel.  Once a Location is
selected and OK is pressed, I will be using that value as criteria in a
query.  Unfortunately, I can't get past the OK button.

I am trying to run a macro to open a form, but the subform is used in several
places.  I want to create a condition that looks for which form the macro was
initiated so I can determine how to respond.  How do I determin which form
initiated the macro?  Is there a [active forms] ...

I'm trying to automatically close a query if it's result returns zero
records. I have many queries running in one macro - not all will return
results all the time so i want to automatically close those with no results -
but i do want to run them.

I would like to double click on a specific record on a list (form), open a
new form, and go to that record either with a filter or query.  I am more
familiar with macros than modules, but I don't know how to store the selected
record and move that into a query or filter.

What I'm trying to do is have a macro:
iemap is the name of it:
openApp
c:\program files\internet explorer\iexplore.exe

I have a report that when there is no data, I want to print a report with a
msg.
=IIf([HasData]=0,"No data for Customer ") ####  I have the customer # in a
table.

I have three queries, qryInvDate, qryPaid and qryAmt.  I am trying to create
a macro to run them together, with no success.  Any suggestions?
Thanks in advance
Paul

Sort data appears to be done back to front .I dont fully understand the
sorting process and have found it imppossible to sort more than 3 columns in
required order then resort again. This has made programming very diffucult in
Visual Basic and created a situation that was not a ...

Is there a way to change names & addresses on letters without doing it
manually?

I am trying to set up a macro with the "transferspreadsheet" command.  Under
the "Action Arguments" section at the bottom, the user is asked to provide
the file from which the data is to be imported.  Instead of always pulling
the data from one file, I would like it to prompt the ...

I have a macro that automatically send emails from my database, for security
reasons i want to stop that email from going into the senders sent items, is
this possible?
Or as a worst case scenario does anyone know how to get it to delete via

is it possible to associate a macro with import specifications and have it
also insert fields (design view) at the time of import (.txt file)? Thank you.

I have a form containing the following field names:
[KitReturned]
[PostedDate]
I would like to set up a Macro that fills the current date

I have used the below code that was suggested and the reports still
prints all the records.
What would prevent this from working that maybe I am not doing
correctly?