Solved: Turning Off Warning Msgs in Make Tbl qry's

[lostin_space]

Hi all - i've got a couple of 'make table' queries in my DB, and i'd like to turn off the warning messages such as "the existing table tbl_AppAct will be deleted before you run the query, do you want to continue anyway", in addition to negating the need to click 'yes' also.

This is a 'known' action, is fully expected etc.

Can anyone help?

Regards

Russ

[OBP]

Russ, there are 2 ways, assuming that you are running the make table queries from within VB, then just add

DoCmd.SetWarnings False

before you run them, but remember to put

DoCmd.SetWarnings True

after you have run them, otherwise the messages stay switched off.
You can also "Set Warnings" in a Macro and call the macro from your VB.

[OBP]

Russ, I forgot, you might be able to save yourself some time, I don't know whether you know but there is a completely different "Help" when you are in the VB Editor, it is not the usual Access one it is all about VBA instead.
It still has the same problem of the usual help in as much as you often need to know how to ask the questions but a search for "warnings" would ahve got you the answer.

[lostin_space]

thanks OBP, you're a star once more!! Just found the VBa help (i love being thrown in at the deep end... ya just gotta love 'management')

[OBP]

Let me know if I can do any more to help.

[CFDM]

you also might want to incorporate the hourglass so users are not confused
docmd.hourglass true
'after the query has run, add...
docmd.hourglass false

[Tom]

Select TOOLS on the tool bar
Select edit/find on the options menu
Unselect "record changes, document deletions and action queries" in the Confirm block
Then click OK