Override warning message box default button (1 Viewer)

telco25

Registered User.
Local time
Today, 05:43
Joined
Feb 1, 2001
Messages
11
I have a macro run a make-table query with the data mode as add, but I want it to automatically select the "yes" button when the warning comes up that it will destroy the existing table. Does anyone know how to do this, please? Thanks.
 

Talismanic

Registered User.
Local time
Today, 05:43
Joined
May 25, 2000
Messages
377
Just insert a line in your macro and choose set warnings to No/False before the command is run and then set them back to Yes/True after the command is run.
 

Users who are viewing this thread

Top Bottom