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.

The Accident form is an example of a Continuous form that shows multiple records.

Like Employee, its name is shown in the upper left corner. There is a Find box that filters the records. Status bar help above the Start button reminds you how to use the Find feature. SelAll, Clear x Sel recs, Del, New and Exit work like they do on the Employee form.

You can sort the columns ascending by clicking a blue link, Employee, Date, Type or Sel, at the top of the form. Click the link a second time to sort descending. Hover over the link to see the yellow tool tip showing the exact sort order.

As you tab through the fields, what is expected in that field is shown in the status bar text above the Start button.

The RecordSelector, the box with the pencil or black triangle to the left of the record, shows the user which record is current. This is the record that would be deleted if the user clicked Del and confimed the operation. The fields, Claimant through Preventable, at the bottom of the form are related to this record too.

Like on the Employee form, fields like Date can be changed in several ways. You can enter the month/day, such as 6/10, if the date is in the current year. You can enter the month/day/year if the date is in a year other than the current year. Ex: 6/10/2005. You can double click an empty date field to put today's date into the field. The numeric keypad + or - adds or subtracts a day from the value each time it is pressed. If you are using Access 2007 or newer, the calendar tool appears to the right of the date field.

For a large recordset, you may need to use the vertical bar on the right of the form to scroll to the record you seek.

The Attendance form features are similar to the Accident form to show when the employee was absent or tardy.

The CALog form lets you track coulseling for absences, seatbelt, DOT and safety violations, mobile phone usage and other unauthorized behavior. It also lets you track corrective action taken.

The Ticket form lets you track the court, offense, status and points assigned.

Close