Disable table update warning? 1

[bravo6]

Is there a way to disable the warnings when running a make-table query? I'm referring to:
"You are about to run a make-table query which will modiy date in your table"
AND
"The existing table (table name) will be deleted....."

Thanks!!

 

[dhookom]

You can run code before and after your action query like:

DoCmd.SetWarnings False
DoCmd.RunSQL "Delete * from tblTemp"
DoCmd.SetWarnings True

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[GrahamHills]

In Access 2003, from the menu

Tools/ Options/

"Edit/Find" Tab

Locate "Confirm" Panel (Top Right)

Unclick Action Queries to run action queries without confirmation.

 

[bravo6]

The code thing is beyond my abilities. Thanks though.
Changing the settings in tools...options.... got rid of the
"You are about to run a make-table query which will modiy date in your table"

warning but the other warning...

"The existing table (table name) will be deleted....."

is still there.
It's a start though, thank you

 

[GrahamHills]

Click Document Deletions off will allow table (or other object) deltions without confirmation.