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


ADVERTISEMENT

EmployeeID

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

Automatically Incrementing EmployeeID

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







Copyrights 2005-15 www.BigResource.com, All rights reserved