EmployeeID
Jan 17, 2008
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!
View Replies
Jan 14, 2008
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!
View 2 Replies
View Related
Apr 12, 2006
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
View 12 Replies
View Related