Sir, how to re-start sl no automatically when year change?
@EdcelleJohnGulfan2 жыл бұрын
Try this. kzbin.info/www/bejne/jl6rlp98nLxolc0
@mikeb5332 жыл бұрын
Thank you for your video. Very informative!
@EdcelleJohnGulfan2 жыл бұрын
Thanks for watching Mike.
@DonRamonLoco Жыл бұрын
Excellent! !! Keep going!
@EdcelleJohnGulfan Жыл бұрын
Thanks for watching Don.
@kamleshjain68722 жыл бұрын
Very useful...Thanks..
@EdcelleJohnGulfan2 жыл бұрын
Thanks
@mathews-q3k2 жыл бұрын
Thank you sir
@EdcelleJohnGulfan2 жыл бұрын
Welcome
@abdulhamidalhaddadi225510 ай бұрын
Thank you
@EdcelleJohnGulfan10 ай бұрын
Welcome
@yawarabbas2052 жыл бұрын
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.
@EdcelleJohnGulfan2 жыл бұрын
Thanks
@EdcelleJohnGulfan2 жыл бұрын
try this kzbin.info/www/bejne/jl6rlp98nLxolc0
@kinganthonyx7 ай бұрын
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
@EdcelleJohnGulfan7 ай бұрын
Apply the IF FUNCTION and CONCATENATE to the code.
@TheAlgothic10 ай бұрын
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"?
@abuhammad865210 ай бұрын
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
@murealnoauy4 ай бұрын
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
@dbdata98362 жыл бұрын
thanks
@EdcelleJohnGulfan2 жыл бұрын
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"
@abukrm26372 жыл бұрын
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.
@niktsol2 жыл бұрын
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?
@EdcelleJohnGulfan2 жыл бұрын
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.
@niktsol2 жыл бұрын
@@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?
@dyonis42672 жыл бұрын
Hi John, is this VBA code works with Access 2019 ? Because i receive an error message from Access on load.
@EdcelleJohnGulfan2 жыл бұрын
Actually i used 2019.
@EdcelleJohnGulfan2 жыл бұрын
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.
@coralchiang98082 жыл бұрын
Hi John, I use 2007, I did not receive any error message but this VBA code didn't work.
@EdcelleJohnGulfan2 жыл бұрын
Check your vba tools reference.
@coralchiang98082 жыл бұрын
Hi John, Sorry I am not sure what you mean.
@EdcelleJohnGulfan2 жыл бұрын
@@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
@albertlavezares84412 жыл бұрын
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?
@EdcelleJohnGulfan2 жыл бұрын
e-try mo nalang to. same process but it will automatically reset every year or every month. kzbin.info/www/bejne/jl6rlp98nLxolc0
@EdcelleJohnGulfan2 жыл бұрын
Thanks for watching
@Kadako2 жыл бұрын
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
@EdcelleJohnGulfan2 жыл бұрын
Nice question. I will make tutorial for that next time. The number will revert to 1 every month.
@Kadako2 жыл бұрын
@@EdcelleJohnGulfan i will wait for that sir . Thank you..
@EdcelleJohnGulfan2 жыл бұрын
@@Kadako here is your request kzbin.info/www/bejne/jl6rlp98nLxolc0