Qry parameter

  • Thread starter Thread starter Bill H.
  • Start date Start date
B

Bill H.

How can I make this work in a query:

PARAMETERS [tblname] TEXT;
INSERT into [tblname] . . .

I know I could build SQL in the VBA and go from there, but this seems more
elegant.

Thx.
 
You cannot do this in a stored query using a parameter. You'll need to use
VBA code to generate an SQL statement string on the fly.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO Error - ODBC Microsft Access Driver Toofew parameters. Expecte 7
Wild Card In SQL String 2
Newbie: What am I doing wrong? 4
Substituting a variable as table name in a Saved query 1
Link to an Oracle Database 1
how to query tables together from different databases 6
Access 2010 Loop through a recordset 2
Using select as button controlsource 2

Back
Top