Make Table Query

[Frank]

I have a successful make table query but need to disable
all pop up windows that ask for confirmations of
overwriting the current table. I want the query to always
overwrite the output table but without asking for permission.

 

[AlCamp]

Frank,
DoCmd.SetWarnings False
will turn off the warnings/prompts
DoCmd.SetWarnings True
will turn them back on.
hth
Al Camp

 

[Nikos Yannacopoulos]

Farnk,

How are you running the query?

If you are doing it through code, AlCamp's suggestion is what you need.

If you want to do it manually from the database window, then you need to
write a simple macro and run that instead of the query itself, so it
suppresses the confirmation dialogs. The macro would be something like:

Action: Argument:
SetWarnings False
OpenQuery Your query name
SetWarnings True

HTH,
Nikos

 

[Steve Schapel]

Frank,

Just so there is no confusion... The argument for the SetWarnings action
in a macro would be No rather than False. Another SetWarnings after the
OpenQuery to set it to Yes again is nice, but unnecessary.

 

[Nikos Yannacopoulos]

Steve,

Thanks for the correction, apparently I was thinking VB code.

Nikos