Undefined function [Format$] in qry

[cehowski]

Since installing VS2003, I'm getting the following message, with queries that utilize the Format function, to parse date portions to fields. I understand from that it has something to do with Type Libraries needing to be referenced (a tip I found about a similar probem in Acces 97), but they did not work for me (the tips). Any ideas on this? It is Access 2000 and I recently installed Visual Studio 2003.

 

[mhartman1]

Hello:

Sounds like you have a broken or missing reference. In your code window, select Tools, References and see if there are any missing references noted.

Regards
Mark

 

[PHV]

Does your DB compiles properly ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886