|
||||||
|
Customer Codes By Richard Rost ![]() ![]() Create Customer Codes that Don't Reveal Your Database Size You don't always want your customers seeing their CustomerID. If someone gets assigned a low number, they'll know you don't have much business. In this Microsoft Access tutorial, I'll teach you how to create custom Customer Codes that are based on DateTime stamps and random numbers. Bethany asks, "I’m using an AutoNumber for CustomerID, however I don’t want my clients knowing how many customers I have. If XYZ Corp sees that they have CustomerID 15 then they know I don’t have that many clients! How do I give them a Customer Code that isn’t dependent on an ID field?" MembersThere is no Extended Cut for this video.
|
Learn MoreFREE Access Beginner Level 1 Free TemplatesTechHelp Free Templates |
ResourcesDiamond Sponsors - Information on our Sponsors Questions?Please feel free to post your questions or comments below or post them in the Forums. |
Age | Subject | From | |
2 years | customer codes | James Christodoulou | |
3 years | Can Use This Method for a PK | Thomas Gonder | |
| |||
Keywords: TechHelp Access customer code format required indexed no duplicates rnd random customer number obscured PermaLink Customer Codes in Microsoft Access |