How to AVOID / SKIP run-time error 2105 and 2499

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

    How to AVOID / SKIP run-time error 2105 and 2499

    Hello, in several forms i have a NEXT, PREVIOUS and SAVE command buttons which were working perfectly...no errors showing...nothi ng!!! i had to convert my DB to 2003 so i could create the .mde. I did the conversion and now my forms give me a run-time error 2105 or 2499 every time i reach the first/last record and try to go one more previous/next record. Im new with access and dont want any fancy error handler i just need to AVOID the error and be able to continue working.

    What can i do??? the following is the code for a NEXT button im using.
    Please help


    Code:
    Private Sub GO_TO_NEXT_Click()
    On Error GoTo Err_GO_TO_NEXT_Click
    
    
    [B]    DoCmd.GoToRecord , , acNext[/B]
       
       Me.Engineering_subform.Requery
        Me.Refresh
       
    
    Exit_GO_TO_NEXT_Click:
        Exit Sub
    
    Err_GO_TO_NEXT_Click:
        Resume Exit_GO_TO_NEXT_Click
        
    End Sub
  • ADezii
    Recognized Expert Expert
    • Apr 2006
    • 8834

    #2
    Originally posted by Gilberto
    Hello, in several forms i have a NEXT, PREVIOUS and SAVE command buttons which were working perfectly...no errors showing...nothi ng!!! i had to convert my DB to 2003 so i could create the .mde. I did the conversion and now my forms give me a run-time error 2105 or 2499 every time i reach the first/last record and try to go one more previous/next record. Im new with access and dont want any fancy error handler i just need to AVOID the error and be able to continue working.

    What can i do??? the following is the code for a NEXT button im using.
    Please help


    Code:
    Private Sub GO_TO_NEXT_Click()
    On Error GoTo Err_GO_TO_NEXT_Click
    
    
    [B]    DoCmd.GoToRecord , , acNext[/B]
       
       Me.Engineering_subform.Requery
        Me.Refresh
       
    
    Exit_GO_TO_NEXT_Click:
        Exit Sub
    
    Err_GO_TO_NEXT_Click:
        Resume Exit_GO_TO_NEXT_Click
        
    End Sub
    Error Numbers 2105 and 2499 produce the same Error Descriptions, namely, Application-defined or object-defined error. Check your References, 1 or 2 may have been corrupted during the conversion. What you are looking for is MISSING in the Library Row.

    Comment

    Working...