• Error trapping

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Error trapping

    Author
    Topic
    WSPeterN
    AskWoody Lounger
    November 12, 2009 at 11:08 am #463811

    I have a main form and a subform. I want to trap the error that pops up if there is a duplicate in the primary key of the main form (I believe it is error 3022 from my research correct me if I am wrong) and give a more user friendly message box. One of the events I need to trap it in is when you move from the main form to the subform. I tried putting the code into the Lost Focus event of the main form as well as On Enter in the subform and neither of those is trapping the Access error and giving me the custom message. Any pointers to the right event to get this error trapping into would be appreciated.

    Reply | Quote
    Viewing 0 reply threads
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      November 12, 2009 at 11:23 am #1185170

      Try the On Error event of the main form. The event procedure has two arguments: DataErr is the error number, and Response is an argument that you can change to tell Access how to react.

      The default value for Response is acDataErrDisplay, meaning that Access will display the built-in error message. If you set Response to acDataErrContinue, the built-in error message will be suppressed.

      Code could look like this:

      Code:
      Private Sub Form_Error(DataErr As Integer, Response As Integer)
 Select Case DataErr
 Case 3022
  MsgBox "You tried to add a record with a value for the primary key that has already been used.", vbCritical
  Response = acDataErrContinue
 Case Else
  ' Let Access handle it
 End Select
End Sub
      Reply | Quote
    Viewing 0 reply threads
    Reply To: Error trapping

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.