Generating Sequential Numbers for Invoices, etcetera

[BudMan]

Okay, I am fairly new to Access. I am trying to create a database for my company. Watching tutorials, etcetera, I have gotten most of what I wanted to accomplish done. However, I do have one problem; creating sequential numbers for invoices.



I have read that it is a bad idea to use the “auto number” function since it can lead to having erroneous numbers being used. I have found one site that sort of explained how to use VBA code to force a new sequential number based on the last used number, but I never could get it to work correctly. Frankly, I do not know VBA coding.

Does anyone have an “easy to understand” method to accomplish this task? It would be great if Microsoft had, a function like this built in; however, it does not.

If it would help, I can be contacted off-list.

[June7]

Generating custom unique identifier is a common topic. Search forum. Here is a start:
https://www.accessforums.net/forms/c...ble-41863.html
https://www.accessforums.net/queries...ery-49599.html

How complicated the code is depends on how complex the identifier.