Hi,
I am trying to do the following with my database. I have a database with a table named Employees. I also have a form named Employees that I use to enter information on the form. What I want to do is, only allow the user to see one record at a time. In other words, if they need to look up an employee than they run a report for many employees or use the Lookup form if it is only one employee. If they need to update the information for an employee, I want them to enter the Employee ID of the employee they are looking for and then the record and only that record will come up for them to edit.
In addition sometimes people will be lazy and not want to look up the Employee ID number so I want another form that will allow the user to enter the last name and first initial of the employee (because their first name may not be consistant in the database) and the form return the single record corresponding to that person. If there are multiple people found than, it gives the user a list of names for them to choose one of the employees and then it opens that corresponding record.
I am also trying for it to have the corresponding error messages if the information entered does not yield any results.
My Employee table has the following fields:
Employee Number Primary key
First Name
Last Name
Classification ID
Seniority Date
Supervisor ID
Can anyone help me on this.?
The basic idea is that they are coming in from a switchboard and they will click one of the buttons to update an employee. Then a dialog box should pop up requesting either the last name first initial or the Employee ID and from there the single record to be updated or the list of the matching employees should open.
France
Just trying to get by.
I am trying to do the following with my database. I have a database with a table named Employees. I also have a form named Employees that I use to enter information on the form. What I want to do is, only allow the user to see one record at a time. In other words, if they need to look up an employee than they run a report for many employees or use the Lookup form if it is only one employee. If they need to update the information for an employee, I want them to enter the Employee ID of the employee they are looking for and then the record and only that record will come up for them to edit.
In addition sometimes people will be lazy and not want to look up the Employee ID number so I want another form that will allow the user to enter the last name and first initial of the employee (because their first name may not be consistant in the database) and the form return the single record corresponding to that person. If there are multiple people found than, it gives the user a list of names for them to choose one of the employees and then it opens that corresponding record.
I am also trying for it to have the corresponding error messages if the information entered does not yield any results.
My Employee table has the following fields:
Employee Number Primary key
First Name
Last Name
Classification ID
Seniority Date
Supervisor ID
Can anyone help me on this.?
The basic idea is that they are coming in from a switchboard and they will click one of the buttons to update an employee. Then a dialog box should pop up requesting either the last name first initial or the Employee ID and from there the single record to be updated or the list of the matching employees should open.
France
Just trying to get by.