Results 1 to 5 of 5

Thread: Date() default

  1. #1
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169

    Unanswered: Date() default

    Right, I have made a program on Office 2000 and am wanting to move it between different machines, the problem is that I have tried to use it on a Office XP machine and in the Default for one of the fields i used Date() and when i go into add a new order it brings up #name which i think means it cant find the reference to date() seeing as it works fine on mine?

    Can anyone shed any light on this?

  2. #2
    Join Date
    Jul 2004
    Posts
    125
    Is this a form control? a Table field? In either case, it should be =Date(). next check if your libraries are selected. If using DAO or ADO, the library priority must be moved up as high as possible.

  3. #3
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I heard someone had same problem, and they fixed it by using Now() instead of Date(). I don't know the exact reason why Access does it, but you can try this if you feel desperate.
    ghozy.

  4. #4
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Do you have any missing references? If you edit some code and look in Tools/References does anything show as missing? Missing references cause functions like Left and Right to stop working. And since it is on another machine, that machine might not have something loaded/installed.

  5. #5
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    I have checked their references the other day, there was one missing but i replaced it, it was the Vb6ext.olb or something like that? It got the date() to work in my vba code but still the default in the properties of the field shows #Name. I am going up to take a look today anyway so ill push priorities up because the dao one is lower than ado and i use dao and ill push the vb6ext one up aswell. Ill also try the Now function, thanks everyone, hope it works!

Posting Permissions

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