Supressing diaglog boxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donagh Berry - 27 Sep 2004 02:52 GMT

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

Reply to this Message

Allen Browne - 27 Sep 2004 02:59 GMT

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

Signature

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.

> hi all,
> I am a newcomer to using modules in microsoft access. I have written
[quoted text clipped - 6 lines]
> Thanks in advance
> Donagh

Reply to this Message