Viewing single record.

[Guest]

Hello all,

I have a table just for Keys. It will be one record it reads only. How can
I get this record into my code? I could do a dLookup for each feild, but I
have more then I'm showing here.

Here's what I am trying but "LLenght, LHeight, LWidth" come up empty.

dim vLLen, vLHgt, vLWth

vKeys = "Select * from tbSettings Where recordid = 1"
Set db = CurrentDb()
Set rs = db.OpenRecordset(vKeys)

vLLen = LLength
vLHgt = LHeigth
VLWth = LWidth

rs.Close
db.Close

 

[Guest]

I just figured it out by using :

vLLen = rs![LLentgh]

Is there a better way to do this though?

 

[Alex Dybenko]

Right, this is a correct way

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

I just figured it out by using :

vLLen = rs![LLentgh]

Is there a better way to do this though?

Hello all,

I have a table just for Keys. It will be one record it reads only. How
can
I get this record into my code? I could do a dLookup for each feild, but
I
have more then I'm showing here.

Here's what I am trying but "LLenght, LHeight, LWidth" come up empty.

dim vLLen, vLHgt, vLWth

vKeys = "Select * from tbSettings Where recordid = 1"
Set db = CurrentDb()
Set rs = db.OpenRecordset(vKeys)

vLLen = LLength
vLHgt = LHeigth
VLWth = LWidth

rs.Close
db.Close