Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Navigation Bar Reappears

Status
Not open for further replies.

zevw

MIS
Jul 3, 2001
697
US
The "Displane Navigation Pane" is unchecked in Access 2007.

However Every time I change Function (Dinner, Fund Raiser, Tea Party) it raeppears and I don't undestand why?

Code:
Private Sub Form_AfterUpdate()

Dim dbs As Database, tdf As TableDef
On Error GoTo Err_Form_AfterUpdate

    If Nz(DLookup("NewLtrFunc", "Company"), False) = True Then
        Set dbs = OpenDatabase("P:\Donors\DbDonor.mdb")
        Set tdf = dbs.TableDefs("Letter" & Me.FunctionId)
        DoCmd.DeleteObject acTable, "Letter"
        DoCmd.TransferDatabase acLink, "Microsoft Access", "P:\Donors\DbDonor.mdb", acTable, "Letter" & Me.FunctionId, "Letter", True
        Me.Requery
    End If
    Me.CampCnt = Me.RecordsetClone.RecordCount
    Forms!Main.FunctionName.Caption = Nz(DLookup("Description", "Functions", "Current = True"), "No Active Functions")
    Forms!Main.Function = Nz(DLookup("FunctionID", "Functions", "Current = True"), 0)
    
    
Exit_Form_AfterUpdate:
    Exit Sub

Err_Form_AfterUpdate:
    If Err.Number = 3265 Then
        Call New_Func_Letter
        DoCmd.TransferDatabase acLink, "Microsoft Access", "P:\Donors\DbDonor.mdb", acTable, "Letter" & Me.FunctionId, "Letter", True
        Me.Requery
        Me.CampCnt = Me.RecordsetClone.RecordCount
        Forms!Main.FunctionName.Caption = Nz(DLookup("Description", "Functions", "Current = True"), "No Active Functions")
        Forms!Main.Function = Nz(DLookup("FunctionID", "Functions", "Current = True"), 0)
    End If
    If Err.Number <> 3265 Then
        MsgBox Err.Description
    End If
    Resume Exit_Form_AfterUpdate
    
End Sub

[/code}

What can i do to assure that the Navigation pane stays hidden?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top