Format$ error/help needed 1

[efinnen]

Well my query seemed to work perfect well on a couple of machines, but not on others.

My situation is the following, I have a query in which it pulls in a date field (mm/dd/yy) and I want to turn in into a field that just says something like Sept 99. So my code is Format$([DATE], "mmmm yyyy&quot and it works just fine.

The problem arises when I move this over to some other machines, the query works fine on some machines and not others.

The ones where it doesn't work I get the following error

Function is not available in expression in query expression Format$([DATE], "mmmm yyyy&quot

Any help or guidance on this matter would be greatly appreciated. Thanks in advance

-Eric [sig][/sig]

 

[phparadis]

My experience with this problem came from saving Access2000 files in a Access97 format and then attempting to use it in an Access97 environment. I believe the solution was to add Microsoft DAO 3.6 Object Library rather than the ActiveX Data Objects Library. (This change can be made by clicking on Tools/References in the code window menu bar) Hope this helps [sig][/sig]

 

[PaulF]

In addtion to the above. Open any Module in Design View, Select Tools-References and look for any Library that may be listed as Missing. Click on the checkbox, next to the item.

PaulF
[sig][/sig]

 

[Umbane]

The OCX's normally missing in above are "microsoft windows common controlls 5 & 6"

Copy mscomctl.ocx and comctl32.ocx into the windows\system directory.
[sig][/sig]