Original author: Jeremy Wallace
Date created: September 22, 2005
Using A Contacts Splash Screen
[NOTE: This form is integrated into the forthcoming Metrix 1.4]
[NOTE: Previous versions of this form would fail to load filters that had SQL strings over 255 characters in length. We've published a fix for this]
- Add the two forms (frmCustomContactsSplash as the main form, and frmCustomContactsSplashSubFilters as the subform) to each metrix.adp client. Note the naming convention where "Custom" is used in both objects, as this allows these two forms to be part of the Metrix upgrade path - any object with "custom" in its name will be moved to the next version. To bring these forms into Metrix:
- Open metrix.adp with the shift key bypass method
- Go to the code window by pressing <CTRL>+G
- In the immediate window, type:
Call LoadFromText(acForm, "frmCustomContactsSplash", "frmCustomContactsSplash.txt")
- In the immediate window, type:
Call LoadFromText(acForm, "frmCustomContactsSplashSubFilters", "frmCustomContactsSplashSubFilters.txt")
- When users open Metrix, you probably want to take them to this Contacts splash screen. If so, in the code for frmStartup, find the line that opens frmContacts. Right below this line, open "frmCustomContactsSplash" form immediately afterward and leave the original line of code that opens frmContacts intact.
- When users click on the main menu item "Contacts", you may want to take them to your splash screen also. If so, open tblMainMenu to view its data. You will see a row listed for "+ Contacts". In the "Script" column for the "+ Contacts" row, change the value to "OpenAnyForm("frmCustomContactsSplash")"
- Lastly, if you performed step 3 for the left menu option, you will want to replicate this same process for the menu item: "Open... Contacts". To do this, ensure you have Metrix.adp open with the <shift> key bypass. Click on the Access menu option (top menu displayed): "Tools... Customize..." A dialog appears, please leave it open throughout the rest of this process. Click on the Metrix menu item option (lower menu displayed): "Open" and then right-click on the menu option "Contacts" and select "Properties". In the "OnAction" property, change it to: "=OpenAnyForm("frmCustomContactsSplash")".
- Use the Filter menu to create one or more Saved Filters. Your saved filters will be listed in the subform of your splash form, allowing you to jump directly to a filtered list of the contacts who meet the criteria you've specified.