Contact is an example of a single record form. 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 Contact form opens, the cursor is on the Find box so you can use a barcode scanner to enter the ContactID of a record you want to find.

In the lower left, above your Start button, is status bar text that says:
Find in |ContactID|LastName, FirstName|HomePhone|CellPhone|WorkPhone|Street|City|Zip|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 Contact combo lets you pick a specific contact. 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 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 ContactID, the auto number primary key, so it is grayed out. HomePhone has an input mask to show the phone number correctly and consistently.

The blue Group label for the Group 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.

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. If there are related tables, Del would delete those related records as well. 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.

If there were related records beneath Contact, such as Invoices for example, you would see a blue link that says Invoice if there were no related records or 6 Invoices if there were related records. Click the Invoice link or Alt-I to see the invoices for this contact.

If if a form is related to a parent form and that form isn't open, the New button will be disabled.

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

Like Contact, 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 Contact form. An ! exclamation point in the Comment field turns the field yellow.

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

The blue Edit link to the right of Group opens the Combo form so you can add or edit the values in the Group combo. Your cursor will move to the value in the combo box.

The RecordSelector, the box with the black triangle to the left of EvalID 35, shows the user which record is current. This is the record that would be deleted if the user clicked Del and confimed the operation.

Current date fields like EvalDate 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/2013. 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.

Close