Results 1 to 5 of 5
  1. #1
    yuriyl is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Overland Park, KS
    Posts
    5

    Cool Linked Table Field Validation


    My MS Access application links to several oracle tables. I have form which connects to one of these tables for the users to be able to edit data and also add new records. The issue i'm having is when a user choses to add a new record and then decides to exit the form with out filling out some of the required fields MS Access displays an error something to the extent that some required fields are missing. I would like to display my own custom message, I tried doing a validation check with with form Unload and OnClose events but, the error comes up before these events are fired. Any suggestions?

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Try the OnError event of the form. Normally you would do this type of validation in the BeforeUpdate event of the form which is probably where this error is coming from.

  3. #3
    yuriyl is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Overland Park, KS
    Posts
    5
    Ok thank you I will give that a try.

  4. #4
    yuriyl is offline Novice
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Overland Park, KS
    Posts
    5
    That worked thanks!!! I'm using the BeforeUpdate event

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You're welcome. Glad I could help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Linked table to sql 2000 db
    By tcroninstl in forum Access
    Replies: 1
    Last Post: 03-23-2009, 07:27 PM
  2. Referencing table data in field validation rule
    By toad848 in forum Database Design
    Replies: 3
    Last Post: 03-19-2009, 07:03 AM
  3. Editing a Linked Table
    By amndza in forum Access
    Replies: 2
    Last Post: 01-21-2009, 01:27 PM
  4. Validation rule for a text field
    By wasim_sono in forum Forms
    Replies: 4
    Last Post: 03-14-2006, 11:39 PM
  5. Field Level Date validation
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums