How do i auto commit to prompts?

[Guest]

I'm new to access and VB and have a quick question....

I'm using VB to copy tables, move entries, delete entries, clear tables, ect.
everytime one of these actions is done, I am warned that I am about to
delete 10 entires, append 50 entries, ect. Is there a way for yes to be
automaticly selected? And if so, how can I do this?

Thanks for whatever help you can give.

 

[microb0x]

Prior to making the necessary calls in VB to modify your tables call
the following:

DoCmd.SetWarnings False

Then after your code had run call:

DoCmd.SetWarnings True

to turn the warnings back on.

 

[Allen Browne]

You can suppress those messages if you turn SetWarnings off.
But then you don't know if the action succeeded for failed.

Instead, Execute your action queries.
There is no warning message if it succeeds.
You can be notified it fails.
And you can programmatically check the number of records affected.

For an explanation of the details, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html