Employee is a single record form that lets you update info about current employees.
All forms show the form name in the upper left corner.
The colored area at the top of the form matches the Main menu. Use the colored area to find records and
the gray area to change information in the record.
When the Employee form opens, the cursor is on the Find box so you can use a barcode scanner to enter the
EmployeeID of a record you want to find.
In the lower left, above your Start button, is status bar text that says: |
Find in |EmployeeID|LastName, FirstName|CellPhone|City|Region|WH|DepartmentNo|JobTitle|Comment|SEL|. Use the pipe symbol (vertical | bar) to separate multiple fields or mark the start or end of a field and reduce false hits. Find for |SEL| to see records where the Sel checkbox is checked. To find all drivers, find for Driver. Find for 1 would return EmployeeID 1, 11, 12, 21, 31, and any phone numbers that contained the number 1. To limit the records returned, Find for |1|, which would find only fields that were exactly 1. You can stack Finds together using the * wildcard that matches any number of characters or the ? that matches any single character. To Find all job title drivers from Dallas, Find for |Dallas|*|Driver|. The order of fields is important, but case is not. The record counter in the lower left of the form shows how many records you have found. Click the Find box to clear it and find all records again. The F on Find is underlined to show it is a hotkey, so Alt-F from the keyboard works the same as clicking the Find box. The Employee combo lets you pick a specific Employee. You can use the < Prev and > Next buttons in the upper right corner of the form, or use the PageDown and PageUp keys to navigate through the recordset. SelAll in the lower left corner of the form sets the Sel checkbox in all records in the found recordset to true. Clear x SelRecs sets them to false.
These features are additive so you could find for Dallas, SelAll, find for Fort Worth, SelAll and repeat the process Arlington, Garland, Irving, Plano, Carrollton, Denton, Frisco, Grand Prairie, McKinney, Mesquite and Richardson to find the larger cities in the DFW metroplex. Similarly, you could find |Smith|, Clear x Sel Recs, find |Jones|, Clear x Sel Recs and exclude all whose last name was either Smith or Jones. If you don't mind also clearing 2013 BlackSmith Way, you could omit the pipe symbol delimiters. By entering keywords in the Comment field, you can quickly select marketing groups for your business. You can use the complex selections to create reports, export data, delete or edit records. As you tab through the fields, the status bar text above the Start button changes to show what is expected in that field. Fields like Region and WH may be grayed out if you don't have the right to change them. To enter dates in the current year, type month/day, like 7/27 for July 27. You can enter the year like 5/2/1980 for May 2, 1980. Click the calendar to the right of the date field to choose the date from a calendar. The numeric + adds a day and the numeric - subtracts a day from the date shown. DoubleClick to set the date to today or clear the date that is entered. The blue label for Region, WH, Department, JobTitle combo opens the Combo form so you can add or edit new values. When you pull down the combo box, the changes to the Combo table appear. By typing in the field, you can move to the first value in the combo that begins with the string you typed. The blue Renumber label renumbers the DriverNo by hire date for qualified drivers at that warehouse. The driver who has been there longest is assigned 1, etc. Click the blue Term label to terminate the employee and move the record to the ExEmployee table. Once you enter the DLNo, that field is hidden for that record. To view the DLNo, click the blue DLNo/State label. If there are related records for the Employee, such as Accidents, Attendances, CALogs or Tickets, you will see a blue link that says Accident if there were no related accidents or 3 Accidents if there were three accident records. The Del button is reserved for users with Super user access. You must enter a password to delete the Employee. It then asks if you want to delete the related Accident, Attendance, CALog and Ticket records. Finally, it asks if you want to delete the Applicant record.