Home Page Contact Dave Thompson Consulting Site Map
Dave Thompson Consulting
408 Rose Drive
Allen, Texas 75002
A Resource List Database Program for Microsoft® Access
II. List Navigation
III. Drill Down
IV. Contact Notes
V. Keyboard-Only (Mouseless) Operation
VI. Database Schema
IV. Contact Notes
Contact notes can be logged to any entry in the database. This can be useful in an E/R environment, for example, to note the result of a resource contact or telephone conversation.
Log entries (contact notes) can be added from either the list screen or the detail screen as shown in Figures 1 and 2 below.
Figure IV-1. Log File Column on Primary List Screen
Figure 1 shows five log entries exist for Adams and none for Brown. Also, Adams has at least log entry note made, or modified, within the last eight hours.
The Log field is a hot zone. Clicking on the field will open the log notes form. You may also use the shortcut key, Alt+L, to open the log notes form.
Note that the Log field is blank for the row below Adams. This indicates that no log entry notes exist for Brown. The Log field is still a hot zone, and clicking on a blank entry will allow you to create a log (comment) entry.
Log comments are also available from the detail view (drill down from Main List) as shown in Figure IV-2 below.
Hot Zone for Adams Log Entries
Click to enlarge (Opens in new window)
Figure IV-2. Log Entries for "Adams"
Entries are displayed with the most recent record first. The most recent record is determined by the Last Edit date/time.
Note that for Adams, the most recent entry has a Last Edit Date/Time within eight hours of the local time (6:07 PM). The row for Adams in the primary list highlights the recent comment by providing color coded background surrounding the log file count.
Figure IV-3. Log Entries From Detail Record Form
Log entries can also be edited/added from the detail record form as shown in Fig. IV-3 above.
The Primary List form also enables the user to narrow the records displayed to only those having a log entry comment that has been edited (either new comment, or changing the content of an earlier comment) recently (with the past 24 hours).
Figure IV-4. Primary List with All Records Displayed
Figure IV-5. Command to limit list to only those with recent log entries
Figure IV-6. Primary List Restricted to Recent Log Event Records Only