Results 1 to 2 of 2
  1. #1
    xwnoob is offline Advanced Beginner
    Windows Vista Access 2000
    Join Date
    Nov 2011
    Posts
    76

    How do i give error if date entered is not todays date?

    Hi,



    I have a field which lets user enter a date. What do i enter in the beforeupdate event so that microsoft access will give an error if date entered is not today's date?

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Why are does the user have to enter anything if today's date is

    demanded and anything else is an error? See Date() or Now().

    Quote Originally Posted by xwnoob View Post
    Hi,

    I have a field which lets user enter a date. What do i enter in the beforeupdate event so that microsoft access will give an error if date entered is not today's date?

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

Similar Threads

  1. If statement with Todays Date being criteria
    By robsworld78 in forum Access
    Replies: 2
    Last Post: 08-19-2011, 08:22 PM
  2. Date Record Entered
    By MikeDBMan in forum Access
    Replies: 6
    Last Post: 08-01-2011, 03:59 PM
  3. Update with Todays Date on Open
    By anoob in forum Forms
    Replies: 5
    Last Post: 03-08-2011, 02:00 PM
  4. Adding todays date
    By EDEd in forum Forms
    Replies: 2
    Last Post: 10-08-2010, 06:27 PM
  5. one date entered to hit 3 fields in one table how?
    By techexpressinc in forum Queries
    Replies: 0
    Last Post: 12-10-2008, 10:43 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