Need help with user-defined types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add new records to three tables using the following, but I
keep getting "User defined type not defined" error. I get it on the first
statement...HELP!! I have used this code in past and it always worked, but
now I am using Access 2000.

Dim dbs As Database
Dim rst As Recordset
Set dbs = CurrentDb

Set rst = dbs.OpenRecordset("Volume")
rst.AddNew
rst![Landill] = Me![Landfill]
rst.Update
rst.Close
 
Pat Beau said:
I am trying to add new records to three tables using the following, but I
keep getting "User defined type not defined" error. I get it on the first
statement...HELP!! I have used this code in past and it always worked, but
now I am using Access 2000.

Dim dbs As Database
Dim rst As Recordset
Set dbs = CurrentDb

Set rst = dbs.OpenRecordset("Volume")
rst.AddNew
rst![Landill] = Me![Landfill]
rst.Update
rst.Close
Click to expand...


Looks like you do not have a reference to the DAO library.
 
Back
Top