Dear all,
In my table, I have a field called employeeAutoNo that has Auto Number data type. E.g: 5.
I have another field called EmployeeID. E.g.: ABC/5/2008, where 2008 is the year & ABC is a contant.
How do I get the get the value from employeeAutoNo and concat with the constant and year (year is taken from System Date) and then store into the EmployeeID field?
Thanks!
Will someone pls reply? This's really urgent! Thx.
I have a table called EmployeeDetail. It has a auto number field name called EmployeeAutoNo. For instance, the last EmployeeAutoNo is 3.
On my form, I have a textbox field called EmployeeID.
When user click on the NEW button, it will take the last EmployeeAutoNo: 3, and display it as ABC/4/2008. (FYI: ABC and 2008 is fixed and 4=3+1).
1) How do I code this NEW button? Do I use a variable and how do I write the value to a control or to default in the control property?
Your help will be very much appreciated. Thanks!
I have a field called EmployeeID, and it has text as data type. The format that I wanted to use for entering an EmployeeID was D01, then the next would be D02, etc.
Is it possible so that when a user enters all details of one employee and wants to create a record for a new employee that the EmployeeID will be automatically incremented. Does anyone know any VBA code which I can use to to do this? Or should I just use an input mask?
Thanks