Truck HR ExEmployee form

The ExEmployee form that lets store and update info about ExEmployees. The form name is 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 ExEmployee form opens, the cursor is on the Find box so you can use a barcode scanner to enter the ExEmployeeID of a record you want to find.

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 employees who quit, find for Quit. Find for 1 would return ID or EmployeeID 1, 11, 12, 21, 31. 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 ExEmployee combo lets you pick a specific ExEmployee. 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.

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.

Click the blue Rehire label to copy the record back to the Employee table.

Once you enter the DLNo, that field is hidden for that record. To view the DLNo, click the blue If there are related records for the ExEmployee, 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 ExEmployee. 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 ExEmployee, 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 ExEmployee form.

You can sort the columns ascending by clicking a blue link, ExEmployee, 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 ExEmployee 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 ExEmployee 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.