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.
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.