Incrementing number field manually
I am not a programmer and a newbie with MS Access.
I hope you guys can help me with my problem.
I'm creating an IT hardware inventory database for my company.
We have a few branches and each branches will have their own branch code.
For example :- PKGL07
PKGL14
KLIA
HQ
and so on....
When a user adds a new hardware, the system will assigned a hardware code
PKGL14-001 for the PKGL14 branch hardware no 1 or
KLIA-001 for KLIA branch hardware no. 1 and so on...
I managed to create the hardware code by following some example on the net using DMAX and string concatenation and by creating a counter table with branch code and number field.
TABLE tbl_TempCounter
FIELD BranchCode
Counter
My problem now is how do I increment the counter number in the tbl_TempCounter according to the branch so that I can get the next number for my hardware code.
I hope my explanation is clear enough.
I hope you guys can help me with my problem.
I'm creating an IT hardware inventory database for my company.
We have a few branches and each branches will have their own branch code.
For example :- PKGL07
PKGL14
KLIA
HQ
and so on....
When a user adds a new hardware, the system will assigned a hardware code
PKGL14-001 for the PKGL14 branch hardware no 1 or
KLIA-001 for KLIA branch hardware no. 1 and so on...
I managed to create the hardware code by following some example on the net using DMAX and string concatenation and by creating a counter table with branch code and number field.
TABLE tbl_TempCounter
FIELD BranchCode
Counter
My problem now is how do I increment the counter number in the tbl_TempCounter according to the branch so that I can get the next number for my hardware code.
I hope my explanation is clear enough.