Running make table queries

[onikage1]

I was wondering if anyone knew of a way to force a make table query to run without showing any prompts. I have a few that I need to run for reporting reasons but I'm trying to automate it as much as possible, so I'd like to eliminate the need to click yes, ok, yes, ok, etc.

Thanks

[rjhodges]

I've been able to do this in one of my projects by using a macro. The steps in the macro are:

MsgBox (optional, display a message)
Hourglass ON (optional, show hourglass for long query)
SetWarnings OFF Turns off warning messages/confirms
OpenQuery This is the MakeTable, datasheet mode
SetWarnings ON Restore warnings
Hourglass OFF Clear Hourglass

You can save this all as a macro and then call it from a command button, switchboard or from within VBA code or another macro.

Give this a try and see if it works for you. I don't recall having to do anything else. I can't really attach the database since it's very complex. But if you have problems, post a follow-up and I'll try to help further.

Ron

[onikage1]

Outstanding! I was able to eliminate a few of the pop ups before but one still lingered. I have reports that run from about 30 tables made by queries, so I'm trying to automate them all so no one has to click 90 boxes, and this is it.

Much appreciated.