turning off action queries

[Maggie]

Hi.
I've looked at all the threads and tried the suggestions, but I"m still
having issues turning off some warnings.
I've used this code:
Application.SetOption "Confirm Action Queries", False
Application.SetOption "Confirm Document Deletions", False
Application.SetOption "Confirm Record Changes", False
DoCmd.SetWarnings (False)

And I've also tried going into the start button and turning off the warnings
under Access Options - Advanced - Editing.
I can get my append queries to shut up, but the make table warnings - "The
existing table 'tbl_name' will be deleted before you run the query". Access
provides help - but it just says go to Access options and uncheck the box.
I've done that several times - warning keeps coming up.
Anyone have any ideas?

Thanks!
Maggie

 

[Alex Dybenko]

Hi,
normally DoCmd.SetWarnings False helps

but you can also delete table before running this query:
DoCmd.DeleteObject acTable, "tbl_name"


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Maggie]

Great! Thank you. That did the trick.

Hi,
normally DoCmd.SetWarnings False helps

but you can also delete table before running this query:
DoCmd.DeleteObject acTable, "tbl_name"


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Maggie]

Thanks! That did the trick!

Hi,
normally DoCmd.SetWarnings False helps

but you can also delete table before running this query:
DoCmd.DeleteObject acTable, "tbl_name"


--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com