1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access 2010 date field validation problem

Discussion in 'Business Applications' started by abmcrm, Jul 29, 2014.

Thread Status:
Not open for further replies.
Advertisement
  1. abmcrm

    abmcrm Thread Starter

    Joined:
    Jul 29, 2014
    Messages:
    2
    I want to add a validation rule to a date/time field in Access 2010. This worked in 2003 and I'd like to know why it won't work now.

    The rule is

    Is Null Or <= Date()

    I have entered this through the expression builder as well as typing it to avoid typos.

    The error message is:

    Unknown function 'Date' in validation expression or default value on 'Artists.Date edited'.

    I am doing this at work: we are running Windows 8, Server 2012, Access 2010 via virtual desktop.

    Any help would be gratefully received!

    Thank you
    Alison
     
  2. OBP

    OBP Trusted Advisor

    Joined:
    Mar 8, 2005
    Messages:
    19,400
    Alison, welcome to the Forum.
    I think you will find that this is an Access problem of Access 2010.
    You may be able to overcome it by using Now() instead of Date().
    If not I can provide you with some simple VBA code that will do the same thing that may work.
    I have also seen advice to open a new 2010 blank database and import everything in to it to solve this problem.
     
  3. abmcrm

    abmcrm Thread Starter

    Joined:
    Jul 29, 2014
    Messages:
    2
    Hi OBP

    Thanks a lot for your suggestions: using Now() instead of Date() works fine.

    What's really irritating is Microsoft use Date() in an example of a validation rule!

    Anyway, all sorted and I can carry on writing my training notes with a working example.

    all the best
    Alison
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1130552