I have a macro that runs about 15 queries. The problem I have is they all
prompt in the beginning of the macro and all run at the same time.
Is there a way I can have the macro pause after each query?

I want to create a link, using a macro, to a specific worksheet and range.
What is the syntax?
e.g., I want to link create to worksheet "Sheet1" and range A1:B300 in the
Excel file "C:\Transactions.xls". What values should I type in the macro

I am trying to use this sql. Does someone have vba code for calculating a
median ?
Switch([PriceC] = 0, [PriceD],
   [PriceC] < 0.15, [PriceC],

How do I make a macro email a report made in Access that is in the body of
the email and not as an attachment?  Thanks.

Hello,
I hope you can help!
I am creating a database with details on Retro gaming systems.
I have a main form, called Systems, where everything to do with old Retro

I am trying to get Microsoft Access to send a report using SendObject in a
macro. I have the macro working and it sends the e-mail with the report to
Outlook, but Outlook does not send the e-mail. I have to manually open
Outlook, go the Outbox, double click the message and then ...

I would like to be able to open a report in another access database.
Can somebody tell me the best way to open a connection to a database and
call a certain report.

I have a macro that runs a make table query to pick up 'unmatched' data and
put this in a seperate table. After running the query the macro renames the
table to include the current date using the expression
="SUN_InRDB_NotArcade_tbl_" & Format(Date(),"ddmmyyyy"). I would then ...

Is it possible to set up the Macro to prompt for the new name in the RENAME
action?

How do I make conditions in a macro work like an if, then, else type statement?
What I would like to do is have the macro run a query, if the results are
null; follow one set of commands, else if the results are not null follow
another set of commands.

Hi folks, hope you can help me out.
I am working in a small private school and we have a DB for studentsdata,
classes, etc.
I wonder if there is some way to create an automatic "dublicate" for a

I have to delete all tables in my database and then import new ones from a
source. If I try to delete the tables manually then I get a confirm delete
message for each one. This is tedious. If I simply import the tables without
deleting the original ones then the new ones get a ...

I desire to import a table from another database, and repeat the process but
maintain relationships with other tables in the receiving database.

I have just created a database.  Within the form i have a Last Name field.  
Basically what i need, is to be notified (by a msg box in a Macro) everytime
that data entry is made with identical last names.  I dont want to prevent it
same last name data entry and there is no 1 last ...

I need to change all the values in a field on a form (that is linked to a
query and tables) back to zero, in order to enter new data for the new year.  
Is there a way to program this rather than having to scroll thru each record
and manually type the 0 into the field for each ...