Added note on another matter

M

Marvin Ettlin

On another matter -- apart from my previous post... is
there a way to disable the confirm boxes. If I run a
macro to delete records, it confirms that I want to
delete and since it is on a large number of tables I have
to sit at the computer and repeatedly press the yes
box... is there a way to enter this as a yes or disable
the confirm boxes from the macro?

Marv
 
S

Steve Schapel

Marv,

Just put a SetWarnings,No action in your macro, before the first of your
(presumably) OpenQuery actions.
 
M

Marv

Steve,
Thanks again!!!

Marv
-----Original Message-----
Marv,

Just put a SetWarnings,No action in your macro, before the first of your
(presumably) OpenQuery actions.

--
Steve Schapel, Microsoft Access MVP



.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Confirm action query runtime option 1
looping through controls - for each ... next 11
Set Allow Edits property to "no" causes problem 4
Documents from shared model are created with design mode on 1
Delete Record Button with Confirmation Message 6
About ON Mobile functionality 5
strange behavior after adding value to lookup list 1
can notes be inserted into background region? 3

Top