Mysterious "Sub or Function not defined"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yannick Turgeon - 18 Jan 2006 22:36 GMT

Hello,

I'm using A97 (french version) on XP (english version).

Since this afternoon, all the Access built-in french-equivalent
function are generating a "Sub or Function not defined" error. An
exemple: IIf(1=1,"bob","joe") is ok but it's french equivalent
VraiFaux(1=1,"bob","joe") generates the error.

It's not linked to the PC since other applications with this function
are working fine. I have no idea what I could have done to change this.
I did change this application today as I do almost everyday. But I
cannot figure out what could produce this behavior.

Any insight would be appreciate.

Thanks

Yannick

Reply to this Message

(PeteCresswell) - 19 Jan 2006 00:58 GMT

Per Yannick Turgeon:

>Since this afternoon, all the Access built-in french-equivalent
>function are generating a "Sub or Function not defined" error. An
[quoted text clipped - 7 lines]
>
>Any insight would be appreciate

Have you opened up a code window and checked Tools|References?

Things like this can happen if/when the reference to something is lost - as in
the target getting deleted or renamed.

Signature

PeteCresswell

Reply to this Message

Yannick Turgeon - 19 Jan 2006 15:14 GMT

Yes, I did that yesterday and there was no missing reference. This
morning, I re-open the application and everything was working fine.
Don't know why. Yesterday I did try the super-solution (restart the
computer!) and the application generated the same error. It's a
mystery.

So if someone with the same problem read this, go home and take a good
rest night! :o)

Thanks for your time.

Yannick

Reply to this Message