Need help with user-defined types

P

Pat Beau

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
 
M

Marshall Barton

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combine code for one button 7
Function not working 3
Use a string to define a field 1
Trying to tableize emails from user folders in outlook 1
qty in table1 minus qty in table2 equal to result column in table2 2
Run-Time Error '3421': How do I fix it? 5
Attachment 4
Sorting A recordset - searching for duplicates 3

Top