Customer Number - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Customer Number

Michelle Seidelin

5 years ago

Hello Richard

I am wondering which lesson to watch the situation is when I started this database I use the auto number as a way of of tracking how many customers I have now I would like to change this is as the auto number is only for access as you have said in future lessons I'm wondering how do I set up a column to put on the form to show customer five which is an auto number at the current time is customer five

Would appreciate any suggestions Michelle

	Alex Hedley @Reply 5 years ago
Michelle, you shouldnt use an autonumber as a Customer #, if you delete a record then add another your count wont match. autonumbers are internal for access to track relationships etc There are many options you can use: - Custom Sequential Counter Number - Create Customer Codes - AutoNumbers Good or Bad? - Automatic Record Numbering

	Michelle Seidelin OP @Reply 5 years ago
Hello Alex which one would you recommend for a single form tracking customers if you need VBA coding can you give me a suggestion on how to do that I'm not up to that yet Michelle

	Alex Hedley @Reply 5 years ago
Is just a sequential number ok? You could use this Tip: DMax: Increment Your Own Counter I'm sure its similar to one of the above.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View