Peter's Software
Helping you create better Microsoft Access applications

Table of Contents

Usage

Can I change the names of the categories?





Is there a way to open the Navigation Pane Relief form "frmNPR" when the database opens?

Answers

1. Can I change the names of the categories?
   
   You can rename the categories by editing the form frmNPRSubform in design mode, then simply change the checkbox caption(s).
   [Back to the top]
    
2. Is there a way to open the Navigation Pane Relief form "frmNPR" when the database opens?
   
   Yes. You can use the following example:
   
   Peter has the following code in a function that runs from his autoexec macro:
   
   

   If InStr(1, CurrentDb.name, "Peter\Documents\Consulting") Then
       Docmd.OpenForm "frmNPR"
   End If

   This checks for a string "Peter\Documents\Consulting" in the full path of the current database that indicates the .mdb file he's opening is in his development folder, then opens the form "frmNPR".
   
   When implemented at the user’s site, the folder will be different and the NPR form will not be opened when the database starts.
   [Back to the top]