Date() Function Not Found -- Operating System Issue

[LarryDeLaruelle]

I recently distributed a small application to about 50 users using a front end download process to put the front end on the user systems. The application is Access 2K. Some users have XP Pro, some have Windows 2K Pro and some have Windows Server 2003 (terminals); all have Access 2K installed locally or on the server.

I use the Date() function to run an age calculation in the main form's source query and to populate a date field on another forms.

On 2K Pro I have encountered no problems. Both XP Pro and Server 2003 choke on the query age calculation. The Date() function setting the form date chokes on the XP Pro only.

I've checked references on the problem systems and all match (closely, depending on what versions of the dll's are installed) with my computer (2K Pro OS) where the app was developed.

Has anyone else encountered OS based problems with functions and, if so, have you found a fix?

Any assistance will be appreciated.

Larry De Laruelle

 

[dhookom]

Most likely different references. Check this thread

http://www.tek-tips.com/viewthread.cfm?qid=1484657&page=1.

Duane
Hook'D on Access
MS Access MVP

 

[PHV]

Does the db compiles properly on the faulty machine ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[LarryDeLaruelle]

It compiles with no problem without the presence of the date() function. I can't use the function in any query/form and save it to try compiling with the function in one of those objects.

I noticed yesterday that I am using the Date() function in vb code when writing a record to a table. That works and compiles on all machines without a problem. I'm guessing that the function in vb works due to the Visual Basic for Applications reference being (I would guess) the same on all systems.

I think Duane may be on the right track with a mismatch on different versions of the libraries referenced. I'm waiting for our chief IT guru to get back from his honeymoon to see if we can push out a standardized set.

Thanks for the assistance and I'll let you know what happens.

Larry De Laruelle