Undefined Function - MS Query

[Bill]

Hi All,

I have the error described in the following link but there is no missing
reference.

Any ideas what I am doing wrong please.?

http://support.microsoft.com/kb/824277/


Regards.
Bill

 

[Douglas J. Steele]

Are you saying that you're trying to use the query in MS Query, as opposed
to in Access?

There are very few functions that you can use outside of Access. What
specific function are you trying to use?

 

[Bill]

I'm replying from a different PC so hope this comes through ok.

Yes that is what I am trying to. The function in question is one I have
written myself that converts various textual (or null or blank or zero
length string) representations of a date into a true 'Access' date value.

Regards.
Bill.

 

[Bill]

Ummm ...... the fact that it was saying undefined function lead me to think
there was a way of defining it in MS Query.

Presumably not!!

 

[Bob Barrows [MVP]]

You cannot use custome VBA functions in queries run from outside the Access
environment.
You wil need to come up with another way to accomplish your purpose.

 

[Bill]

Ok, fair enough!! :-(

 

[Bob Barrows [MVP]]

I do feel your pain. we've been wrestling with this limitation for years.

Bob