I have a form linked to a table containing an auto number field primary field. Upon creating a new record via the form an auto number is generated. However, if the user decides to back out of the record and not save it the auto number remains incremented even though there will be no entry in the table. Is there any way to prevent this from happening or am I best off using code to generate my incremental number?
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers.
Hopes this gives you ideas on visualizing your data in new ways ~
Create a calculated field in a query: