Supressing diaglog boxes

[Donagh Berry]

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

[Allen Browne]

You can fly without any warnings if you use:
DoCmd.SetWarnin gs 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****@moorepa rk.teagasc.ie> wrote in message
news:c5******** *************** ***@posting.goo gle.com...

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