Create Custom Microsoft Access Customer Codes to Hide AutoNumber IDs from your Clients

[@SoumyaChowdhuri]

After watching so many videos got what I needed, thanks for the upload.

[@599CD]

Glad to hear it!

[@moodkn]

Greetings to you: wonderful I found his practice very useful and included it in my database program

[@599CD]

Glad it was helpful!

[@moodkn]

Lot of Thanks! Sir Great way

[@599CD]

Most welcome

[@colinraynor833]

Once again thanks for all you do for us.. Just a note, I had this as my default value table level: ="XYZ-" & Format(Int(Rnd()*10000),"00000") Do you believe I actually had dups ! A few times.... Than how you explain the people react when confronted by an error like " HUH? what ?" ya well, that was me! I figured that big of a number, should certainly be ok.. ya, Nope! So once again I had to implement what you suggest, add time to change it up.... Its getting a lil old YOU being right all the time.... :) Thanks again.. You Rock!

[@lakhveersingh4136]

I want to add customer code field in the table. The format that I want to use to create a customer code is [YYYYMMDD]+[sequence number of customer]. For example, [20210930]+[C101] = 20210930C101. I watched your video and liked the way it assigns random number for customer code. I want to use sequential number instead to make it simple for accounting. By doing this I will also be able to check company performance as well. Thanks for your help in advance.

[@599CD]

599cd.com/Counter

[@srivishnu369]

Hello Richard! Thank you for this great video and the other Tech help videos are much appreciated as well. I am able to get this random number system working, whenever I enter data from a Form I keep getting an error saying that I am creating duplicate records. After a couple of Form refreshes the number becomes unique and then it allows me to add the data. Every time I restart the application, I can't get this to work without a couple of refreshes so the ID number becomes a random unique value. I tried playing around with the "Fetch Defaults" as well but to no luck. What am I missing here? Many thanks in advance.

[@599CD]

That's a weird one, and I'm not exactly sure what you mean. I only check KZbin every week or so. Why don't you post this question in the Access Forum on my web site: 599cd.com/ACF

[@martenlenstra8696]

Dear Richard, when I put in the Format(Now) in de Default Value of the CustumerCode field I have to put in a semicolon ; instead of a comma, Can you explain that? I recently changed the language in Office 365 from Dutch to English (UK). Could that be the reason?

[@599CD]

Yeppp

[@sanghauzel]

What a great Tip!!

[@599CD]

Thanks

[@tommymartin2089]

Hello, I am trying to generate a automatic proposal number, I used your video to set this up, but can't seem to set it up in a form to never create a duplicate. When I use your sequential numbering teaching I get run time error '13' type mismatch. Not sure how to fix this

[@599CD]

I get a ton of questions every day, and I don't have time to answer them all here on KZbin. Feel free to submit your question on my website at: 599cd.com/AskYT

[@paulnyamtowo]

Hi Richard Rost, l have seen that in this video you have randomized the last part of your customer codes between 1-100, l was wondering how l can increment them with +1, probably starting with 00000

[@599CD]

Sure. 599cd.com/Counter

[@shahramahmadzadeh5285]

Hello , I wrote this code just like you, but it gives me a Invalid Syntax error. Why?

[@599CD]

Can't tell without seeing it.

[@a.a.4403]

Hello. How can i update the codes for the existed data in tables? Thanks.

[@599CD]

599cd.com/UpdateQ

[@a.a.4403]

@@599CD Thank you.

[@AbhishekKumar-cq1wy]

sir how to add other value like @ ,# ,a,b,c,d..

[@599CD]

I wouldn't

[@amirhosseinrezaei4723]

='c' & "dat" & 'Format(Int(Rnd()))' Hi again I from Iran & I can't register in your site please help me this one formula is ok please take advise aging

[@599CD]

I don't understand what you're trying to do