Macro to execute query, and export to another MDB

[dgmorr]

Hey guys, I'm trying to create a macro and I'm not finding success.

I have a Macro that contains

OpenQuery - qryExportNames
CopyObject - tblNames

How do I handle all the pop-ups that occur? Is there any way I can automatically select the YES? There are two or three of these.

 

[DrSnuggles]

Go to Tools\Options on the Edit/Find Options Tab un-click:
Record Changes
Delete Documents
Action Queries.

You will need to do this for all your users.

 

[dgmorr]

I still get the message boxe saying


“The name you entered already exists for another object of the same type in this database”