Forum Discussion
Auto Numbering Using VBA in Microsoft Access
I'm trying to do a custom Auto Numbering to create work order numbers based in Date, Time and Tech initials. I've figured out how to do this using a VBA script, but if I use DoCmd.Close at the end o...
I had to create a new table with a primary key, run the script and then delete the row that had the primary key and now it works.
Very confusing.
Very confusing.
so you don't have a PK?
you always add one and an autonumber.
the later is very useful on identifying for each record's uniqueness.
you always add one and an autonumber.
the later is very useful on identifying for each record's uniqueness.