Getting rid of MSGBOX in the SELECT INTO statement

[cwarner]

Hi,

I'm doing a bunch of SELECT INTO statements
and I keep getting those annoying MSGBOX
pop-ups that say "deleting X # records",
etc. Any way to get rid of these and make
them NOT show up?

Thanks!
Christy.

 

[pazgb]

you can go to tools menu,
then options,
then the edit/find tab,
under confirm:uncheck record changes

that should work

 

[cwarner]

Thanks for the quick reply!!

-Christy.

 

[cwarner]

Hi again,

This worked for all of the messages
except the delete table action. I clicked
on all of the "confirm" options under the
TOOLS/OPTIONS/EDIT/FIND, but the system is
still prompting me if I want to delete
a table (I delete and re-create it about
50 times in this pgm).

Any idears?

Thanks again,
Christy.

 

[JoeCool71]

Prior to running your select into statements...I assume that you are running this in VBA then use the following prior to running.

Docmd.Setwarnings False
Your Statements
Docmd.Setwarnings True