Results 1 to 2 of 2
  1. #1
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    206

    Smile Custom messages to Access' default error messages.

    Hello everyone. I wanna know if there's a way to replace the usual error messages that appear in Access (those messages that are generated not by VBA, but by its engine).



    For example, when a user attempts to encode a foreign key that cannot be found in its pertinent master list table, I should be able to show a custom message instead of the usual "Microsoft Jet cannot find...."

    I know how to create foreign key validations via code, but isn't there any simpler way of doing it? For example, can I just say "On Error 500 Go To..." instead of creating a DAO recordset to find a foreign key value in a master list?

    Looking forward to receiving replies.

    Thanks a lot!

    Joe

  2. #2
    evander is offline Competent Performer
    Windows 7 Access 2003
    Join Date
    Apr 2010
    Location
    Philippines
    Posts
    206
    Sorry for the grammatical mistake in the post's title, as well as in the body. Not a native English speaker here.

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

Similar Threads

  1. Collect data through emails messages
    By DaveyJ in forum Forms
    Replies: 1
    Last Post: 06-19-2010, 12:39 AM
  2. Replies: 3
    Last Post: 10-15-2009, 12:24 PM
  3. Customs Alert Messages on specific dates
    By edupi in forum Access
    Replies: 1
    Last Post: 05-08-2009, 04:51 AM
  4. Error Messages
    By DataGeek in forum Access
    Replies: 0
    Last Post: 12-06-2007, 09:56 AM
  5. SENDING EMAIL MESSAGES DIRECTLY FROM ACCESS
    By Frenchos in forum Access
    Replies: 0
    Last Post: 07-20-2007, 12:51 AM

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 - Senior Forums