Results 1 to 3 of 3
  1. #1
    FogLine is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2010
    Location
    GA.
    Posts
    23

    Using the Date() criteria


    I am using Access 2013.
    I have a form based on a query.
    In that query I have a <Date() in the criteria on the Date field.
    The form runs just fine on the developing computer
    but after I distribute it with access 2013 run-time
    it will not run.??
    I'm sure that I must be leaving out some reference with my installer.

  2. #2
    cyanidem's Avatar
    cyanidem is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2015
    Location
    Consett, UK
    Posts
    270
    What do you mean by "not run"? Returns error? No results? Wrong results?

  3. #3
    FogLine is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2010
    Location
    GA.
    Posts
    23
    Quote Originally Posted by cyanidem View Post
    What do you mean by "not run"? Returns error? No results? Wrong results?
    Yes returns error saying that it can not run criteria with <Date()

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

Similar Threads

  1. Replies: 2
    Last Post: 04-02-2015, 12:45 PM
  2. Replies: 20
    Last Post: 01-13-2015, 02:23 PM
  3. Date criteria using between and form date picker
    By killermonkey in forum Queries
    Replies: 3
    Last Post: 03-21-2013, 12:44 PM
  4. Replies: 3
    Last Post: 08-21-2012, 03:05 PM
  5. >Date() criteria
    By BED in forum Queries
    Replies: 3
    Last Post: 12-15-2010, 03:29 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