Problem: SUDDEN error 2465 EVERYWHERE!!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Gilberto
    New Member
    • Aug 2007
    • 135

    Problem: SUDDEN error 2465 EVERYWHERE!!!

    Hello

    I have a big BIG problem. Im new with acces and ive been creating a db for a month now. It was working perfectly and just after i did a db SPLIT some functions began displaying error 2465. I first thought it was caused by the SPLIT but now ive opened backedup files from weeks ago and it ALSO gives me error 2465 which it didnt give me before. What could have happened??? What can i do???

    Example: this function worked EXCELLENT, now its giving me the error 2465.
    Code:
    Private Sub Form_Open(Cancel As Integer)
    
        On Error GoTo FormOpen_Err
        If (CurrentDb().Properties("StartupForm") = "frmSplashScreen" Or _
          CurrentDb().Properties("StartupForm") = "Form.frmSplashScreen") _
            Then
    [B]        Forms!frmSplashScreen!chkHideSplash = False[/B]
        Else
            Forms!frmSplashScreen!chkShowHide = True
        End If
    FormOpen_Exit:
        Exit Sub
    
    FormOpen_Err:
        If Err = 3270 Then
            Forms!frmSplashScreen!chkShowHide = True
            Resume FormOpen_Exit
        End If
    
    End Sub
    
    '----------------------------------------------------------------
    
    Private Sub Form_Close()
    
    On Error GoTo Form_Close_Err
        If Forms!frmSplashScreen!chkShowHide Then
            CurrentDb().Properties("StartupForm") = "frmMain"
        Else
            CurrentDb().Properties("StartupForm") = "frmSplashScreen"
        End If
    Exit Sub
    
    Form_Close_Err:
        If Err = 3270 Then
            Dim db As DAO.Database
            Dim prop As DAO.Property
            Set db = CurrentDb()
            Set prop = db.CreateProperty("StartupForm", dbText, _
            "frmSplashScreen")
            db.Properties.Append prop
            Resume Next
        End If
        
    End Sub
    It gives me the error highlighting (Forms!frmSplas hScreen!chkHide Splash = False). I actually DONT have ANY control named "chkHideSplash" . The issue is that BEFORE it didnt show me the error and now it does.

    If there is no fix for this...HOW can i simply "DISREGARD/PASS" the error so that it doesnt bring he debugger????

    Thanks
    Gilberto

    NOW ITS EVEN WORSE!!!!
    I just restarted the machine just in case. hehehe. Of course the problem is still here.

    The database is in a network folder and i just opened it on ANOTHER computer and it WORKS....NO ERRORS....NO 2465. So its just MY COMPUTER/ACCESS.

    What could i have done??? How do i check for Reference issues???

    HELP!!!!
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    I would go back to square one, so to speak! Go back to your original, non-split database, then go into the code module for any form, and do two things.

    First check your references: Go to Tools - References. Check all of the selected references. If any of the selected references have "MISSING" in front of them, make a note of their name(s) unselect them and back out of the References dialog box. Now go back into the Reference dialog box and reselect these references.

    Now, on the menu, go to Debug then click on Compile your Db name. Access will guide you thru any errors it finds, allowing you to fix them. For instance, I suspect that the non-existent chkHideSplash did, in fact, once exist! Doing a compile may expose where it's still referred to and allow you to remove it. Once you complie is done see if the 2465s are gone. If the db is now working, try splitting it again. WHile the compile only needs to be done once, before splitting, the references need to be checked on any other machines that have a problem running the app.

    Good luck!

    Linq ;0)>

    Comment

    Working...