Parameter query, prompt for tablename

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

Guest

Is there a way to create a stored make-table query in Access that will prompt
the user for the name of the table, without writing code in a module, just
within a stored Access query?

TIA
 
KarenH said:
Is there a way to create a stored make-table query in Access that will prompt
the user for the name of the table, without writing code in a module, just
within a stored Access query?
Click to expand...

It can't be done in a QueryDef. You have to use VBA to dynamically
create the SQL string.
 
Back
Top