Function "Date()" is not available?? 1

[kjds]

Hello all

I have an access database which is used by many users over a network. Many of the queries select data by todays date, ie using Date(). But on one computer only, I keep getting an error message "Funtion isn't available in expressions in query expression([Sample received table].[Date received])=Date()). Other computers will run these same queries with no problem at all.

In fact on this computer, access has a problem with "Date()" were ever it is used.

As far as I can tell the setup is exactly the same on all computers.

I hope somebody can help as this is very frustrating.

kjds

 

[Telsa]

I'm assuming that you also checked the Reference under Tools and have the same versions.... True?????

Mary

 

[kjds]

Mary

Yes, as far as I can tell the computer with the problem is running the same access release, and also the same win98 as most of the other computers.

Could it be a bios problem??


kev

 

[rhicks]

Read the FAQ at the location below. The problem is more than like with the references.

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=107&CFID=8347718&CFTOKEN=6869517

HTH s-)
RDH



Ricky Hicks
rdhicks@mindspring.com

 

[mterveen]

did you ever get this issue figured out? i just moved an access application to another computer and all the aggregate queries that use trim(), date() etc get this error. using access 97 on win 95 and moved it to a win98 machine. i am perplexed to say the least.

 

[MarkSweetland]

Check the versions of DAO350.dll on the machines--you'll probably find two or three different versions.

The later versions of this file have a problem with functions in queries. The older versions that shipped with access get "updated" with newer versions when some applications are installed. This happens a lot when development machines get loaded with programs like Microsoft Interdev, and user of these machines maintain older code with references to the DAO350.dll.

The short of it is to reference a single version of the dll file and stick with it.


Mark

 

[MissyEd]

Ive got one more suggestions. Look in References and remove any that claim not to be found. I found this to be a problem when I took a database I created at home to work. The only difference was I had a reference to some software I had installed at home but not at work. Access seemed to get confused till I went in and physically removed the reference.

HTH Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com

 

[MissyEd]

Ive got one more suggestion. Look in References and remove any that claim not to be found. I found this to be a problem when I took a database I created at home to work. The only difference was I had a reference to some software I had installed at home but not at work. Access seemed to get confused till I went in and physically removed the reference.

HTH Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com

 

[mterveen]

thx for the posts. it was so simple once i looked closely. there was indeed a reference to a file that was missing. i just copied the file from the programming computer to the users computer and it worked.

 

[ALEKSJAY]

I had this problem once, it also happened with the text functions MID and LEFT. I solved it by caling them as VBA.Date, VBA.MID, VBA.Left and so on. Hope it helps

 

[grtammi]

I had the same problem - Date() would not work on some person's computers, and would work on others, etc etc etc ... I was going to move my version of DAO350.dll to the network and force everyone's computer to use that as a reference, but instead, I used the following workaround:

Format(Now(), "mm/dd/yy&quot - same thing as date really, and actually, on date comparisons, you don't need the format function, just the Now() function.

HTH

Greg
If you don't understand, just nod and smile ...