SQL in VBA code ?

S

SpookiePower

Is it possible to put SQL into the VBA code ?

I have tryed to put it into a lable and textbox like this -

label.caption = "Select......."
textbox.text = "Select....."

But it will not work.
 
G

Guest

That way won't work because what would be the value you need? If you want one
value you have to specify it by retrieving it from a recordset. This could be
q query but than again you also could use a DLookup if it was only one
record(field) value

Maurice
 

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

SQL into a labels caption ? 2
Example Of VBA SQL Statement 0
VBA Quotes using IIF 4
On Timer Help 2
=> Control Label 2
running SQL in the VBA code 1
expression in SQL works in control property but not in VBA 4
SQL code in VB with "Access" 4

Top