Results 1 to 2 of 2
  1. #1
    ga3la is offline Novice
    Windows 7 Access 2003
    Join Date
    Jan 2010
    Posts
    3

    warning to make update note


    hi everyone,

    i create a project in access, it's for seller card phone, with contrat 24 mounths and create and warning every 6 months, till now everything alright the problem is with the warning apear that mean i need make note but imagine i didn't check my program that mean i lost make note for some customers...that i'm thinking if there is code can aplicate for stay warning always active till i make note??

    thank you for everyone

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373

    Post

    If your are taking about a form, on the form BeforeUpdate event check to see if the note field is Null (empty); if Null cancel the event and set focus to the note field, e,g,

    if isnull(me.NotefieldName) = true then
    cancel=true
    me.notefieldname.setfocus
    enf if

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

Similar Threads

  1. Replies: 1
    Last Post: 02-04-2010, 11:17 AM
  2. How to create warning notice
    By bluepowa in forum Programming
    Replies: 3
    Last Post: 09-29-2009, 03:15 AM
  3. Need help with 'note book' idea.
    By Luk3y in forum Access
    Replies: 0
    Last Post: 06-26-2009, 09:54 PM
  4. Records deleted with NO warning message.
    By evanscamman in forum Access
    Replies: 2
    Last Post: 12-14-2007, 11:18 PM
  5. Security Warning
    By mojo53777 in forum Security
    Replies: 0
    Last Post: 11-16-2007, 06:23 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