[b]Updating the Recordset [/b]

[trystanhuwwilliams1]

Hi, This should be fairly easy to answer. This is my code:

rs.MoveLast
tot = rs.RecordCount

For x = 1 To tot
With rs
.Edit
!Credit_Date = Null
.Update
rs.MoveNext
End With
Next x

Is it possible to replace the field Credit_Date with a variable?

Thanks,

Trystan

 

[Hap007]

Dear Trystan,

Try one of these.

Dim MyFieldName as String
Dim My FieldNumber as Integer

MyFieldName = "Credit_Date"
!(MyFieldName) = Null
or
MyFieldNumber = 1
!(MyFieldNumber) = Null

I think that will work,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[trystanhuwwilliams1]

Thanks for you help Hap, but Access doesn't like the parenthesis around the variable name. I've also tried removing them without success.

I may have to try a different approach.


Trystan

 

[trystanhuwwilliams1]

Aha,

As long as you don't use an operator identifier, such as ! or . then Access will accept a variable as a substitute for the field name.

 

[PHV]

Have you tried this ?
MyFieldName = "Credit_Date"
rs.Fields(MyFieldName) = Null


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244