Auto Commit

[Guest]

I'm new to VB and still learning, but I have a quick question. I have
written code to append entries, delete entries, copy tables, ect. However,
every time it goes to delete, append, ect, it asks ie "you are about to
delete 60 entries". Is there a way I can have it auto. say yes? And if so,
how?

Thanks for the help

 

[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

 

['69 Camaro]

Please don't multipost. Your question has already been answered in the
other newsgroup.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

You can also go to tools-->options-->Edit\Find tab and deselect confirm
action queries