Is there a way to start your for each field in recordset with a specific field?
i.e....
field1, field2, field3, field4
I would like to START with field2 so....
for each field in recordset starting with field2
do this...
Thanks in advance.
Is there a way to start your for each field in recordset with a specific field?
i.e....
field1, field2, field3, field4
I would like to START with field2 so....
for each field in recordset starting with field2
do this...
Thanks in advance.
Not with For...Each loops but you can with a For...Next loop.
Ok, looked into a for...next loop a bit...
Can you use a for...next loop with recordsets? I'm using...
Code:For Each varField In rs.Fields
Try:
The Fields index starts with 0 so 1 is the 2nd field.Code:With rs For x = 1 to .Fields.Count - 1 .Fields(x) = whatever you want Next End With
Perfect. Thank you.
Great! Glad we could help.