ACCESS MACRO TO PROMPT USER TO RENAME A TABLE?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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")
 
Back
Top