S
Sherwood
Hi
I have a client with a table that has an autonumber field.
They went to add a new record (It was already poulated with records) and
got a dup error.
Somehow the autonumber generated by access is less than the existing
largest autonumber field
(i.e. records 1 thru 100 has sutonumber matching record number, but adding
a new record access puts 50 in the autonumber field. Duh.)
Is there a VB snipit to set the autonumber > than the # of records in the
table
(i.e. set autonumber to 101)
Thanks,
Sherwood
I have a client with a table that has an autonumber field.
They went to add a new record (It was already poulated with records) and
got a dup error.
Somehow the autonumber generated by access is less than the existing
largest autonumber field
(i.e. records 1 thru 100 has sutonumber matching record number, but adding
a new record access puts 50 in the autonumber field. Duh.)
Is there a VB snipit to set the autonumber > than the # of records in the
table
(i.e. set autonumber to 101)
Thanks,
Sherwood