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 Cert form opens, the cursor is on the Find box. In the lower left, above your Start button, is status bar text that says:
Find in: |CertID|LName, FName|CertNo|Phone|GradDLNo|InsFName|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.

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 Cert combo lets you pick a specific cert. You can use the PageDown and PageUp keys to navigate through the recordset.

SelAll 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.

You can't change CertID, the auto number primary key, so it is grayed out. Phone has an input mask to show the phone number correctly and consistently.

The blue ClassNo label for the ClassNo 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. SchoolNo and InsDLNo combos work the same way.

If you enter an exclamation point ! in the Comment field, it is highlighted yellow. This helps the user remember to ask a question while the customer is available.

The Del button can be reserved for users with Super user access or not. It is easy to add a bulk delete feature to delete all Sel records or to add a password to restrict deletes from all but a few users.

Date fields like CompDate can be changed in several ways. You can enter the month/day, such as 4/24, 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: 10/11/2019. 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.

When you click New, the form will copy the last record's SchoolNo, ClassNo, CompDate, CourseNo, Delivery, Reason, IssueDte, InsDLNo, InsFName, InsLName and Void. It will increment the CertNo by one. If you set the Reason to I, it will fill the Court with Insurance and set the CertNo an Insurance CertNo. This number begins with I, has 0 fill and is one more than the last used Insurance CertNo.

The StartCert and EndCert range let you select the certs to print or export to TDLR's comma separated values (CSV) format with the Exp button, print to the default printer with the Print button or view with the View button. The default for StartCert and EndCert is the current certificate. When you double click the EndCert field, it changes to the last TDLR cert issued. The Exp button uses the LastExport field on the Setup form. Use the blue ImportFolder link to view the CSV file exported. It will be in the format CP000yyyymmdd.csv where yyyymmdd is the date. The Exp format is the same as the file format used for import on the Setup form.

The PDF button exports a PDF named [GradLName].pdf into the ImportFolder. After you send it to the student, delete it or move it to an Old folder to make finding files easier. PDF always exports the current cert.

Close