How to Create Auto numbering in MS Access

[@bck4589]

Sir, how to re-start sl no automatically when year change?

[@EdcelleJohnGulfan]

Try this. kzbin.info/www/bejne/jl6rlp98nLxolc0

[@mikeb533]

Thank you for your video. Very informative!

[@EdcelleJohnGulfan]

Thanks for watching Mike.

[@DonRamonLoco]

Excellent! !! Keep going!

[@EdcelleJohnGulfan]

Thanks for watching Don.

[@kamleshjain6872]

Very useful...Thanks..

[@EdcelleJohnGulfan]

Thanks

[@mathews-q3k]

Thank you sir

[@EdcelleJohnGulfan]

Welcome

[@abdulhamidalhaddadi2255]

Thank you

[@EdcelleJohnGulfan]

Welcome

[@yawarabbas205]

Thank u sir for these valuable videos. I request you plz make a video on increasing numbing by coding which we can use instead of the autonumber. when we open the open it shows the number and will save in the field and saved the data.

[@EdcelleJohnGulfan]

Thanks

[@EdcelleJohnGulfan]

try this kzbin.info/www/bejne/jl6rlp98nLxolc0

[@kinganthonyx]

In auto number I have alphabet codes for month and years. How to automatically add those code in front of auto numbers based on date

[@EdcelleJohnGulfan]

Apply the IF FUNCTION and CONCATENATE to the code.

[@TheAlgothic]

sorry for ding this, i follow the code on video, - when i try to delete the new record, at 1st, the information disappear but i open the form again the record shows again... the information inst delete from the table... only deleting manually on the table the record is deleted... - there's a way to delete the records from the form using a "delete btn"?

[@abuhammad8652]

In a table there are data of students of some class i want if class one student then his id start from 1000 and if class two his id start from 2000 so how to customize auto number as class

[@murealnoauy]

From the example you did, it was very good. But I would like to add the ID number to 0000, 0001, 0002. What should I do? 2023-04-1 to 2023-04-0001 2023-04-2 to 2023-04-0002

[@dbdata9836]

thanks

[@EdcelleJohnGulfan]

You're welcome. Thanks for watching.

[@anikethire8964]

How to provide specific I'd or Name to the Ms form which is automatically Generated when you open the form.

[@EdcelleJohnGulfan]

You mean sir the caption or name of the form when it's open? If so... In load event, Form.caption = "Name or title of the form"

[@abukrm2637]

Sir, how i make multiple serial number based on content of particular cell in the same record?

[@gaudensiabitakara857]

Pinned by Edcelle John Gulfan B C K 5 months ago Sir, how to re-start sl no automatically when year change

[@EdcelleJohnGulfan]

Try this Gaudensia. kzbin.info/www/bejne/jl6rlp98nLxolc0

[@EdcelleJohnGulfan]

Thanks for asking.

[@niktsol]

Hello. Very nice video. One question. I am creating an application which keeps track all the incoming documents information and each document gets a unique number per year. Every new year, this number is reset to 1. I am using Dmax as well. This application is set in a multi user environment. For the moment it is in test procedure. Is there any slight possibility if two users enter the same record simultaneously to have duplicate values?

[@EdcelleJohnGulfan]

In this method, there's no possibility because we use the auto numbering data type +1. And also we can set it to primary key to make it unique.

[@niktsol]

@@EdcelleJohnGulfan If for example i don't use the auto number key and i create myself a custom autonumbering field which resets to 1 every first day of new year, does Dmax method in the BeforeInsert or BeforeUpdate event of the data entry form prevents duplications or there is a possibility if many users enter simultaneously data to have duplicate values?

[@dyonis4267]

Hi John, is this VBA code works with Access 2019 ? Because i receive an error message from Access on load.

[@EdcelleJohnGulfan]

Actually i used 2019.

[@EdcelleJohnGulfan]

What's the error?

[@ronaldb1816]

Idol. Mayron akong 5 data sa table, Gusto ko i-duplicate yung number 1 na data, pero gusto ko masasave sya katabi parin ng number 1, hindi sa last record

[@EdcelleJohnGulfan]

E.sort mo lang boss. Or create a query then sort to ascending.

[@ronaldb1816]

Possible po ba yung auto numbering na editable, ibig kong sabihin pwede ko baguhin ang id number doon mismo sa form. Pwede ba ganon?

[@EdcelleJohnGulfan]

Yes possible talaga sya pero may mga negative impact lalo na kung latest id number ang e-edit mo.

[@coralchiang9808]

Hi John, I use 2007, I did not receive any error message but this VBA code didn't work.

[@EdcelleJohnGulfan]

Check your vba tools reference.

[@coralchiang9808]

Hi John, Sorry I am not sure what you mean.

[@EdcelleJohnGulfan]

@@coralchiang9808 open your visual basic application, click TOOLS and select REFERENCES. Try to check the MICROSOFT ACCESS OBJECT LIBRARY and also MICROSOFT OFFICE OBJECT LIBRARY

[@SanjayKumar-yh6il]

Sir how to create Sequential Auto Number) for Month and Cumulative AutoNumber in Year i.e. multiple AutoNumbers in MS Access pleas guilde me., if possible

[@EdcelleJohnGulfan]

Same concept with this. kzbin.info/www/bejne/jl6rlp98nLxolc0

[@albertlavezares8441]

Bakit pag pag first record hinde lumalabas ang dmax value yung date format lang ang lumalabas, at pag second record na ok na ang output niya, ano kaya ang problema?

[@EdcelleJohnGulfan]

e-try mo nalang to. same process but it will automatically reset every year or every month. kzbin.info/www/bejne/jl6rlp98nLxolc0

[@EdcelleJohnGulfan]

Thanks for watching

[@Kadako]

Sir how make by year Example Entry 1. 2021-001 2. 2021-002 3. 2022-001 4. 2021-003 5. 2022-002 Every year will have own sequence

[@EdcelleJohnGulfan]

Nice question. I will make tutorial for that next time. The number will revert to 1 every month.

[@Kadako]

@@EdcelleJohnGulfan i will wait for that sir . Thank you..

[@EdcelleJohnGulfan]

@@Kadako here is your request kzbin.info/www/bejne/jl6rlp98nLxolc0

[@bdhis24]

bdhis24

[@EdcelleJohnGulfan]

Hello Sir?