Peter's Software
Helping you create better Microsoft Access applications


Home

General info

Where to buy

Mailing List

Contact


Links


Navigation Pane Relief F.A.Q. (Frequently Asked Questions)

Table of Contents

    Usage

  1. Can I change the names of the categories?


  2. 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]
     

Register this software.

Ask a Question about Navigation Pane Relief

Back to Navigation Pane Relief Page