SQL in VBA code ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SpookiePower - 06 May 2007 19:14 GMT

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.

--
My Photo Gallery
www.photo.box2600.dk

Reply to this Message

Maurice - 06 May 2007 20:21 GMT

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

> Is it possible to put SQL into the VBA code ?
>
[quoted text clipped - 8 lines]
> My Photo Gallery
> www.photo.box2600.dk

Reply to this Message