By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

Supressing diaglog boxes

P: n/a
hi all,
I am a newcomer to using modules in microsoft access. I have written
code to create a table and append other tables onto it. However, with
each step a dialog box appears to ask if I'm sure I want to append the
records. Unfortunately the MS access book is out of the library. Does
any one know how to supress these dialog boxes (i.e., say yes to every
box that appears)?

Thanks in advance
Donagh
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You can fly without any warnings if you use:
DoCmd.SetWarnings False
Don't forget to turn it back on again.
Unfortunately, you don't hear if there was an error with appending records.

If you are executing append queries, a better idea might be to use the
Execute method:
dbEngine(0)(0).Execute "MyActionQuery", dbFailOnError
You get a message only if there was an error.

You also have the option to use transactions so you get an all-or-nothing
result. More info:
http://members.iinet.net.au/~allenbrowne/ser-37.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Donagh Berry" <db****@moorepark.teagasc.ie> wrote in message
news:c5**************************@posting.google.c om...
hi all,
I am a newcomer to using modules in microsoft access. I have written
code to create a table and append other tables onto it. However, with
each step a dialog box appears to ask if I'm sure I want to append the
records. Unfortunately the MS access book is out of the library. Does
any one know how to supress these dialog boxes (i.e., say yes to every
box that appears)?

Thanks in advance
Donagh

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.