Wayne
Dim db As DAO.Database 'Current database.
Dim rs As DAO.Recordset 'Table to update
Dim rst As DAO.Recordset 'Query with last number
Depending on the Access version you are using, the ADO and DAO libraries might or might not be loaded.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <kwheil@cox.net> wrote :
I have a routine that adds sequential numbers to records before they are appended to a table. This is for a database that manages room characteristics for hospital projects. I create a new database for each project and make modifications that are project specific. Most of the objects are the same. When I copied the VBA code for the routine into a modified copy of the database I get the subject line error for each of the lines below. The references are identical for both files and they are running on the same computer.
Dim db As Database 'Current database.
Dim rs As Recordset 'Table to update
Dim rst As Recordset 'Query with last number
Any idea of what could cause one to work fine and the other not to work at all would be most welcome.
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar