Search results

Me.ID = Format(ID, "000")... there's a problem when I am using this Syntax

Thank you very much! I've tried some of them but I use this sample as not to complicate things, and will not consider a reset every year, but I still have a problem...I want to format ID (Autonumber) as "001, 002, 003 and so on, and I already did that, I use concatenation, but the problem is it...

Thank you, I only have few knowledge about MS Access, Since I am a newbie user....I tried some VBA but I can't figure out how to do it, may you please help, Thank you...

How can I create a sequential numbering that includes month and year, and it should reset every year. Sample: 0001, 0002, 0003, and so on.... then Month, 01, 02, and so on... then Year, 2023, 2024, and so on... Shows like this: mm-sequence number-yyyy...