Results 1 to 3 of 3

Thread: Required Error

  1. #1
    Join Date
    Nov 2002
    Posts
    154

    Question Unanswered: Required Error

    Does anyone know of a way, if you have a form that has several REQUIRED (NOT NULL) constraints on table fields, if there is a way on a form to capture which field is causing the error (error 3314)? I ask this so I can craft more informative and easier read messages in the error event for the form to let the user know what the problem is. Thank you in advance for your time and your responses.

  2. #2
    Join Date
    Dec 2004
    Location
    Coon Rapids, Minnesota
    Posts
    41
    Im not too sure on what can be done with regards to the error itself, if there is a property of the error that identifies the problem field. However, what I usually do is have some code behind the submit button (or whatever it is you are doing on the form that causes the problem) which checks the fields that need to have something in them and then provides a nice friendly MsgBox listing each of the fields that are empty. Then when the user clicks ok on the message i automatically SetFocus back to the first of the fields that is missing.

  3. #3
    Join Date
    Nov 2002
    Posts
    154

    Smile Thanks

    It turns out that I just did that right after I posted--I was kinda hoping someone would know of a property of the error but it was just me being anal retentive--I wish that access had the vb.net 2005 validation tools--ah well, one can dream.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •