turning off prompts??? is this possible???

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

I have set up a macro that deletes old data and pastes new data into a
couple of tables. the problem is the following prompts forces the user
to interact. Is there a way to turn these off or disable them during
the running of the macro???


You are about to delete 1 record
You are about to run an update query that will modify your data table
You are about to update 1 row
You are about to delete 2 records
You are about to paste 1 record
You are about to run an update query that will modify your data table
You are about to update 1 row
You copied a large amount of data onto the clipboard

I have set up a macro to do all of the above and i don't want the user
to have to answer these questions.

suggestions are greatly appreciated
 
add a couple actions to your macro, as

SetWarnings No
<the delete and update query actions>
SetWarnings Yes

if i recall correctly, SetWarnings doesn't have to be turned back on
explicitly in a macro, but you might as well get in the habit anyway. at
some point you'll move to VBA (you will, believe me), and in VBA you have to
explicitly turn back on the system warnings, and you'll want to do it, too.

also, i noticed that two of the warnings you get is a "paste" message, and a
"copied large amount to clipboard" message. but i don't notice an "append
data" message. instead of copying records from one table and pasting into
another, have you considered using an Append query?

hth
 
Back
Top