Problem: SUDDEN error 2465 EVERYWHERE!!!

[Gilfdz]

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.

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!frmSplashScreen!chkHideSplash = 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????

Thanksm
Gilberto

 

[MStCyr]

Good morning

Have you tried a repair and compact on both the FE and BE ???

Maurice

 

[GaryPanic]

make a copy
ok

now open up the code (exactly like you have it here) and put a
' in front of every line of this code
now try and open it see what happens

i think whats happend here is you have imported a form into your d/base at some time - and this little gem was hidden in the form properties..
it doesn't look dangerous -so puting a ' should solve it

 

[RuralGuy]

You might also check and see if you have developed any reference problems.

 

[Gilfdz]

Thanks for your replies. 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!!!!

 

[RuralGuy]

Follow the link I posted.

 

[boblarson]

How do i check for Reference issues???

While in the code window (VBA IDE), you go to TOOLS > REFERENCES and check to see if any of the checked ones have the word MISSING beside them. If so, uncheck it and close the database and reopen.