How do i auto commit to prompts?

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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13003-how-do-i-auto-commit-prompts.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13003

Thanks for whatever help you can give.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Prior to making the necessary calls in VB to modify your tables call
the following:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13003

DoCmd.SetWarnings False

Then after your code had run call:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13003

DoCmd.SetWarnings True

to turn the warnings back on.




Dave wrote:
> 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.

You can suppress those messages if you turn SetWarnings off.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13003
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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13003
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave" wrote in message
news:884409DA-0977-4BCA-A1B0-81736E2092B4@microsoft.com...
> 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.