DAO Errors after converting from Access 97 to 2002

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I converted a database from access 97 to access 2002 and I
am now getting compile errors due to old DAO syntax. I
have changed some of the code to work correctly but the
following code I can't seem to change so that it works.

Forms![frm_OT].Dynaset.MoveFirst
Forms![frm_OT].Dynaset.Edit
Forms![frm_OT].Dynaset.Dynaset.fieldName = " "
....
....
....
Forms![frm_OT].Dynaset.UPDATE


I am trying to clear the data from the fields. Wondering
if someone knows how to properly convert this code.

Thanks Dave
 
If you still have your copy of Access 97 (or, more specifically, the help
file from it), look up "obsolete features in DAO", and you'll see Dynaset
listed there.

Use Recordset instead.
 
Forms![frm_OT].Dynaset.MoveFirst

That looks like
Forms![frm_OT].RecordsetClone

(david)
 
Back
Top