dlookup

  • Thread starter Thread starter doug
  • Start date Start date
D

doug

how do i put a dlookup statement into a string that i want
to execute as sql command. I have something like:
strSQL = "insert into table (item) values dlookup("value",
table)"

how would i go about fixing that
thanks
 
Doug,

See the reply to your previous question. You're right, you caught the
problem.
 
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

DLookup and Nz 0
DLookup debacle 4
DLookUp Quotation Problem 6
dlookup and dao.recordset 4
do... loop basics 2
Access DLOOKUP with IF Function in MS ACCESS DB 0
Is it possible to use DLOOKUP in a query to bring in a value directlyfrom a control box in a form? 3
dlookup with if 1

Back
Top