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: "Wayne Heil" <kwheil@cox.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Tidak ada komentar:
Posting Komentar