Date Value

[dgaller]

I have a DB that I use the date() function in a form as a default value and just Date in the code for comparison of today. This works fine on all my computers. When I tried running the DB on 2 other computers I get an error at start up and all the default dates show as Name? and I get VB errors when it should compare to todays date.

Any ideas?

 

[boblarson]

Check for Reference Errors.

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[dgaller]

Thanks. I was able to resolve by opening a blank DB and importing everything into it. Which after reading your resolution I think was a long way of doing what you said.

 

[boblarson]

Glad to hear you got it working for you though