chrisjrice
Registered User.
- Local time
- Today, 02:43
- Joined
- Mar 26, 2002
- Messages
- 37
I would be for ever in debt to anyone who can help me resolve this.
I currently have an access database which uses link tables to our AS400 database. I have a form over the main link table which a user use to log request changes. The data will be stored on the AS400.
The database file has an item number which is used as a unique identifier. In my VBA program I want to look at the last number in the database and increment it by one and then write that out with the new record.
I have created a query which captures the last item number on the database and my hope was that I could extract this number to a seprate field in VBA and add 1 to it. I have tried all sorts but cannot seem to extract the value from the query.
Is there anyway I can do this, or is there a better way I could increment the last item number by 1?
I can't use an auto number, because the file can also be updated from our AS400 systems.
Please help!!
Chris
I currently have an access database which uses link tables to our AS400 database. I have a form over the main link table which a user use to log request changes. The data will be stored on the AS400.
The database file has an item number which is used as a unique identifier. In my VBA program I want to look at the last number in the database and increment it by one and then write that out with the new record.
I have created a query which captures the last item number on the database and my hope was that I could extract this number to a seprate field in VBA and add 1 to it. I have tried all sorts but cannot seem to extract the value from the query.
Is there anyway I can do this, or is there a better way I could increment the last item number by 1?
I can't use an auto number, because the file can also be updated from our AS400 systems.
Please help!!
Chris
