Hi. My name is Mohsen from Iran. I started learning VBA Access recently. I interested to learn more and use your Knowledge.
I have a Question.
I have a Table in Access includes 4 fields. (Year - ProjectName - Phase - ContractNo)
I want make unique ID for each project in my form when I register a new project. How can I do this?
Like ;
[2019-01-OG]
[2019-02-BU]
[2020-01-HE]
[2020-02-OG]
[2020-03-IN]
[2021-01-OG]
As you see, I want ["Year" - "Number of Projects the same Year"- "Phase"].
Thank you for guiding me to get the answer.
I have a Question.
I have a Table in Access includes 4 fields. (Year - ProjectName - Phase - ContractNo)
I want make unique ID for each project in my form when I register a new project. How can I do this?
Like ;
[2019-01-OG]
[2019-02-BU]
[2020-01-HE]
[2020-02-OG]
[2020-03-IN]
[2021-01-OG]
As you see, I want ["Year" - "Number of Projects the same Year"- "Phase"].
Thank you for guiding me to get the answer.