refering to field names in a recordset 1

[lanelouna]

hello everybody
i have a small problem but it is important to me i hope u can help me
in fact i have to access fieldsi n a recordset, however the name of the fields vary
can i say something like this?or something similar?
For i = 0 To nbr
p = noms(i)
If RS!["Name_" & p ] = 1 Or RS!["Name_" & p] = 0 Then
bla bla bla
knowing that what i wrote is not working, i hope u can help
thanks in advance
Lanelouna

 

[Nikita6003]

Hiya,

Try using the Fields() property of the recordset:
you can specifiy any (valid!) fieldname as string.

example:

Dim l_sFieldname as string

'Your own bit of code assigning to your recordset RS

'Assign the dynamic fieldname to the string variable
l_sFieldname = "Name " & p

'Refer to this name in your IF statement:
If RS.Fields(l_sFieldname) = 1 Or RS.Fields(l_sFieldname) = 0 Then 
   bla bla bla
End If

HTH

Cheers
Nikki ;-)

 

[lanelouna]

hello Nikki!
thanks alot for ur helpful reply, it worked like charm!
thanks again
happy new year!

Lanelouna

 

[Nikita6003]

yw
any time ;-)
Happy New Year