ACCESS MACRO TO PROMPT USER TO RENAME A TABLE?

J

jeschmuck

I need to repeat a query many times to isolate data, my query prompts for the
appropriate criteria. I want to create a macro that will re-run the make
table query and then rename the table and continue. I will need to change
the name of the table after it is created, but I want the macro to do it and
prompt me for the new name each time? Any help would be great.
 
S

Steve Schapel

Jeschmuck,

Use a Rename action in the macro, after the OpenQuery action, and in the
New Name argument, you can put something like this...
=InputBox("New Name")
 
Top