@Normal@<:#336,4200><+!><:f280,2MS Serif,0,0,0><-!><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 1
@Normal@<:#288,4200><+!><:f200,2MS Serif,0,0,0><:f200,2MS Serif,0,0,0>Copying a Value List<-!><:f240,2MS Serif,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>Suppose you entered a value list for Field1 and want the same value list to appear for Field2, but do not want to retype the list.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>1. Switch to Design Mode and select Field1.
@step@<:#240,4200>2. Press Control-C to copy Field1 to the clipboard.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>3. Click the cusor at the location for Field2.
@step@<:#480,4200>4. Press Control-V and Field1 will be pasted from the clipboard to the new location.
@step@<:#480,4200>5. Double click Field1 to bring up the Field Style Dialog Box.
@step@<:#960,4200>6. From the Field List in the Field Style Dialog Box, select Field2 and click the OK button. This will copy Field2 over Field1 and attach the value list entries from Field1 to Field2.
@Normal@<:#120,4200><:f100,FArial,0,0,0>
@Normal@<:#1200,4200><:f200,6Times New Roman,0,0,0>Use the above for copying the same, manually entered value list to multiple fields in the same view file. You can also use a similar technique to copy a manually entered value list from a field in one view file to a field in a
separate view file:
@step@<:#960,4200>1. While in the view file with the value list to be copied, copy the field holding the value list to the clipboard by selecting the field and pressing Control-C.
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>2. Open the second view file.
@step@<:#720,4200>3. Enter the Design mode and press Control-V to paste the field from the first view file into the second.
@step@<:#720,4200>4. The field will display "BAD_FIELD_REFERENCE", since there is no matching field in view file 2.
@step@<:#480,4200>5. Double click Field1 to bring up the Field Style Dialog Box.
@step@<:#1200,4200>6. From the Field List in the Field Style Dialog Box, select the target field from view file2 and click OK. This will attach the value list from the field in view file1 to the new field in view file2.
@Normal@<:#480,4200><:f200,6Times New Roman,0,0,0>This technique will NOT work for value lists based on fields from joined databases.
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> <:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 2<:f200,2MS Serif,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2MS Serif,0,0,0>Copying a Formula<-!><:f200,6Times New Roman,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>To save time and effort when creating several calculated fields with similar formulas, copy a formula from one calculated field to another by:
@step@<:#720,4200>1. From the formula box, select the formula to be copied by dragging the mouse cursor over the formula text.
@step@<:#480,4200>2. Press Control-C to copy the selected formula to the clipboard.
@step@<:#480,4200>3. Exit from the formula box and either create or select the target calculated field.
@step@<:#720,4200>4. At the formula box for the target calculated field, press Control-V to paste the copied formula to the new calculated field.
@step@<:#480,4200>5. Make minor edits as necessary to apply to the new calculated field.
@Normal@<:#120,4200><+!><:f100,6Times New Roman,0,0,0>
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> <:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 3<:f200,6Times New Roman,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2MS Serif,0,0,0><:f200,2MS Serif,0,0,0>Adding Fields with Identical Dimensions<-!><:f200,6Times New Roman,0,0,0>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>Suppose you want to add exisiting fields to a form or report that identically match the dimensions of a field already on that form or report.
@step@<:#720,4200>1. From the Design Mode of the target form, report or mailing label, select the field to serve as the pattern for the others.
@step@<:#480,4200>2. Press Control-C to copy that field to the clipboard.
@step@<:#480,4200>3. Press Control-V to place a copy of that field directly on top of the original field.
@step@<:#720,4200>4. Use the mouse pointer to pull the copy field off of the original field. You now of two copies of the pattern field.
@step@<:#480,4200>5. Double click the second field to bring up the Field Style Dialog Box.
@step@<:#720,4200>6. From the Field List in the Field Style Dialog Box, select a field to add to the form and click the OK button.
@step@<:#960,4200>7. The new field will now be added to the form or report. It will replace the copy of the pattern field, but will retain the exact dimensions of the pattern field.
@step@<:#480,4200>8. Repeat steps 1 through 7 for the number of identically dimensioned fields you wish to add.
@Normal@<:#120,4200><:f100,FArial,0,0,0>
@Normal@<:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 4<-!><:f>
@Normal@<:#240,4200><+!><:f200,2MS Serif,0,0,0><:f200,2MS Serif,0,0,0>Report Dates in Header<-!><:f>
@Normal@<:#720,4200><:f200,6Times New Roman,0,0,0>If your report includes a date field, you can have Approach print the earliest and latest dates for records included in that report in the report header.
@step@<:#480,4200>1. Create two calculated fields, for example, Mindate and Maxdate:
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>2. Mindate = smin(datefield)
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>3. Maxdate = smax(datefield)
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0> where datefield is your date field.
@step@<:#1680,4200>4. For both Mindate and Maxdate, select the Summarize On choice: Summary of all records in Database Name (where Database Name is the name of your database that contains the date field.) 5. Create a report and place the calculated Mindate and Maxdate in t
he header or footer of the report.
@step@<:#960,4200>6. Now when you switch to Preview or print the report, Mindate will display the earliest date and Maxdate will display the latest date for all of the records in the database.
@Normal@<:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 5<:f200,2MS Serif,0,0,0>
@Normal@<:#480,4200><+!><:f200,2MS Serif,0,0,0>Save Time and Effort Finding Duplicates with a Macro<-!><:f>
@Normal@<:#1440,4200><:f200,6Times New Roman,0,0,0>An Approach macro can automate the process of finding duplicate records based on pre-chosen fields. The macro defined below eliminates the need to select the fields to search for duplicates on each time you wish to perform the
Find Duplicates operation.
@step@<:#240,4200>1. Select Find Duplicates from the Records menu.
@step@<:#480,4200>2. Select the fields to search for duplicates on (you will do this only once) and click OK
@step@<:#960,4200>3. After Approach finds the duplicate records (make sure you have at least one set of duplicate records for the first duplicate search), select Define Macro from the Edit menu.
@step@<:#240,4200>4. Type a name for the macro e.g., Find Dups
@step@<:#480,4200>5. Make sure the Find Box is checked and that Restore is chosen.
@step@<:#480,4200>6. Click the Add button at the top of the Macro Sheet and then click OK.
@Normal@<:#115,4200><:f100,6Times New Roman,0,0,0>
@Normal@<:#1440,4200><:f200,6Times New Roman,0,0,0>Now each time the Find Dups macro is run, Approach will find all of the duplicate fields based on the original fields specified in step 2 above. Because it remembers the original find criteria, the macro saves you the time and
effort of selecting the same fields to search for duplicates on each time.
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> <:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 6<:f200,2MS Serif,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2MS Serif,0,0,0>List the Find Criteria from a Macro<-!><:f200,2MS Serif,0,0,0>
<:f200,6Times New Roman,0,0,0>
@Normal@<:#1920,4200><:f200,6Times New Roman,0,0,0>One of the most powerful features of Approach macros is the capability to restore a find. Just enter the criteria for the find once, create a macro and check the Find option to Restore, and the macro will execute that find aut
omatically when you run the macro. Once you attach a find to a macro, you may want to list the exact find criteria the macro Restores:
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>1. Run the macro that Restores the Find
@step@<:#480,4200>2. Select Find Again from the Records menu and the original find criteria are displayed.
@Normal@<:#120,4200><:f100,FArial,0,0,0>
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> <:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 7<:f200,2MS Serif,0,0,0>
@Normal@<:R><:#240,4200><+!><:f200,2MS Serif,0,0,0>Excluding a Range in a Find Request<-!><:f>
@Normal@<:#960,4200><:f200,6Times New Roman,0,0,0>Suppose your database contains record ID numbers from 1 to 10,000 and you want to find all records except those with record ID numbers between 400 and 600 inclusive:
@Normal@<:#240,4200><:f200,6Times New Roman,0,0,0>1. Press control-F or click the Find button
@step@<:#480,4200>2. Enter <<400 in the Record ID field, but do not press enter.
@step@<:#480,4200>3. Select Find More from the Records menu. Approach will display another Record ID field.
@step@<:#480,4200>4. Enter <;>600 in the Record ID field and press enter.
@step@<:#480,4200>5. Approach will perform the find and exclude the records with ID's 400 through 600.
@Normal@<:R1,8,1,3240,1,3600,1,4320,1,5040,1,5760,1,6480,1,7200,1,7920,><:#336,4200><+!><:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> <:f280,2MS Serif,0,0,0><:f280,2MS Serif,0,0,0> Tip 8<:f200,2MS Serif,0,0,0>
@Normal@<:R><:#284,4200><+!><:f200,2MS Serif,0,0,0>Finding Names with Apostrophes<-!><:f>
<:f200,2MS Serif,0,0,0>(e.g. O'Brien)
@Normal@<:#960,4200><:f200,6Times New Roman,0,0,0>To find names or other words that contain apostrophes, type the apostrophe twice. For example to find O'Brien, type O''Brien into the appropriate field during the find request.