NOTE: You will need to copy these steps on all client machines, or if possible, complete these steps once in a client copy of Metrix, then copy this metrix.adp file to the other client computers. If you use the latter method, please always back up the local metrix.adp files you are overwriting to be safe, and take care to not overwrite any local reports the users might have saved while using Metrix.

Steps to load the "version 3" contacts splash screen (see attachment: contacts_splash_v3.zip)

Loading the client objects

1. Download the Contact Splash zip file named "contacts_splash_v3.zip" from the attachments area
2. Unzip these text files to your C:\ drive (or similar location)
3. Use the "LoadFromText" function to create each form object from text in your database.  To do this, open the immediate window in the metrix.adp database where you want the forms to exist (note: you will have to do this in each client, for each text file)
   • Call LoadFromText(acForm, "frmCustomContactsSplash", "C:\frmCustomContactsSplash.txt")
   • Call LoadFromText(acForm, "frmCustomContactsSplash_Results", "C:\frmCustomContactsSplash_Results.txt")
   • Call LoadFromText(acForm, "frmCustomContactsSplashAddContact", "C:\frmCustomContactsSplashAddContact.txt")

Loading the server objects

There are three SQL Server objects you must create also, one view and two stored procedures. The .sql files you unzipped will allow you to do this. Please follow these steps to load the server-side objects:

1. Open a command window (Start --> Run --> type "cmd")
2. Navigate to the "C:\" drive
   • osql -U sa -P admin -S (local)\METRIX -d databasename -i spCustomContactIsDup.sql
   • osql -U sa -P admin -S (local)\METRIX -d databasename -i vwCustomContactsSplashResults.sql
   • osql -U sa -P admin -S (local)\METRIX -d databasename -i spCustomInsertIntoTblContactLocations.sql

     Handy Hint You can use the F3 function key to bring up the previously executed statement in the command window. You can then use the left arrow, delete and/or backspace to edit the line. This way, you can just edit the names of the objects listed above after you've typed the full OSQL line once

Configuring Metrix to use the contacts splash screen you just loaded

1. Now you must add one line of code to ensure the Contacts Splash screen is opened when Metrix is opened
   • In the Form_Open event of frmStartup
   • After the line of code that reads: blBackup = CheckBackup
   • Change the line: DoCmd.OpenForm "frmContacts", acNormal, , , , acWindowNormal
   • To read: DoCmd.OpenForm "frmCustomContactsSplash", acNormal, , , , acWindowNormal
2. If you want the Contacts Splash screen to open when the user clicks on the left main menu option of "Contacts", then:
   • Open tblMainMenu to view its data
   • Find the "+ Contacts" main menu option
   • For the value "Script", change it to OpenAnyForm("frmCustomContactsSplash")
3. If you also want the Contacts Splash screen to open when the user clicks on "Contacts" from the "Open" menu option in the upper-most MS Access menu bar, then:
   • Ensure you have entered MS Access with the <shift> key bypass
   • In the MS Access (i.e. not Metrix) menu bar, choose the "Tools --> Customize" option
   • In the Metrix menu bar, choose the "Open" option, then right-click on the "Contacts" option
   • You will receive a dialog box.  In the "OnAction" property, change the value to OpenAnyForm("frmCustomContactsSplash")