Results 1 to 5 of 5
  1. #1
    Join Date
    May 2012

    Unanswered: Access 2007 Time() wont work!!!

    Recently we hat to update Office 2003 to Office 2007.
    If getting a lot of complains of my college's of a view things.
    One of these things are that in a Access database i made a button with the command "Time()" in a certain testbox.
    Now (in 2007) this wont work because 2007 probably wont recognize the parameter.
    Also if i use the: " Shift + Crtl + ; " i get the message: The expression you entered has function name that (DB name) cant find.

    I hope some1 can help me to resolve this so i can use the Time() parameter without changing to much of the database, cause this will generate more complains.


  2. #2
    Join Date
    Mar 2009
    Provided Answers: 15
    the function Time still works in Access 2007. The problem must be elsewhere (see screen capture).
    Attached Thumbnails Attached Thumbnails Access2007-Time.jpg  
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    missing reference on the change to v2007?
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    May 2012
    Do you know how to resolve it???

    See the attachment for the code.
    Attached Thumbnails Attached Thumbnails 1233.bmp  

  5. #5
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    AS has been suggested, when apps run fine on one machine and not on another, or run fine in one version and not when run under a newer version, one the first things you have to think about are missing references.

    If you haven't checked for this kind of thing before, here are Doug Steele's detailed instructions on how to troubleshoot the problem:

    Access Reference Problems

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts