Warning Messages - Need to be turned of

[mattpfc]

Hi all,

I am trying to turn off a warning message that Access throws up every time users click a button on a form I have. The button is linked to a make table query which returns certain data, then puts it in a table, which I then pass to Excel etc.

The warning message users get every time is one which says that there is a table with the same name and it will be deleted before you run the query.

I have turned off the confirm options including document deletions but this does not work.

Is there a way I can turn this warning message off?

 

[bat17]

DoCmd.SetWarnings False

and after code is run put them on again with

DoCmd.SetWarnings True


HTH

Peter

 

[mattpfc]

EXcellent!

Thanks Peter