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"?
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
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.
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 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?
@@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
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
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
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
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?
Sir, how to re-start sl no automatically when year change?
Try this.
th-cam.com/video/X-HelFgW5_k/w-d-xo.html
Thank you for your video. Very informative!
Thanks for watching Mike.
Excellent! !!
Keep going!
Thanks for watching Don.
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"?
Very useful...Thanks..
Thanks
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
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
Apply the IF FUNCTION and CONCATENATE to the code.
Thank you sir
Welcome
Sir, how i make multiple serial number based on content of particular cell in the same record?
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.
Thanks
try this th-cam.com/video/X-HelFgW5_k/w-d-xo.html
Hi John, is this VBA code works with Access 2019 ? Because i receive an error message from Access on load.
Actually i used 2019.
What's the error?
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?
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.
@@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?
How to provide specific I'd or Name to the Ms form which is automatically Generated when you open the form.
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"
Thank you
Welcome
Hi John,
I use 2007, I did not receive any error message but this VBA code didn't work.
Check your vba tools reference.
Hi John, Sorry I am not sure what you mean.
@@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
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
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
Same concept with this.
th-cam.com/video/X-HelFgW5_k/w-d-xo.html
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
E.sort mo lang boss. Or create a query then sort to ascending.
Possible po ba yung auto numbering na editable, ibig kong sabihin pwede ko baguhin ang id number doon mismo sa form. Pwede ba ganon?
Yes possible talaga sya pero may mga negative impact lalo na kung latest id number ang e-edit mo.
thanks
You're welcome. Thanks for watching.
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?
e-try mo nalang to. same process but it will automatically reset every year or every month. th-cam.com/video/X-HelFgW5_k/w-d-xo.html
Thanks for watching
Pinned by Edcelle John Gulfan
B C K
5 months ago
Sir, how to re-start sl no automatically when year change
Try this Gaudensia.
th-cam.com/video/X-HelFgW5_k/w-d-xo.html
Thanks for asking.
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
Nice question. I will make tutorial for that next time. The number will revert to 1 every month.
@@EdcelleJohnGulfan i will wait for that sir . Thank you..
@@Kadako here is your request th-cam.com/video/X-HelFgW5_k/w-d-xo.html
bdhis24
Hello Sir?