Prev: How to show day of week
Next: Autofill field on form with values from another table
From: jrp444 on 25 Mar 2010 12:25
I have been trying to use "format", Date(), "Mid", "Left"..etc. in a query.
It gives me an error Undefined Function. Could some tell me what to do to
fix this problem.
From: kc-mass on 25 Mar 2010 12:59
Open a module (Cntrl G) in your db. In the tools menu select "References"
You will likely find that one of the checked references has the word
"Missing"
placed in front of it. Make note of the reference like
"Microsoft Excel 11.0 Object Library". Uncheck the reference. navigate down
the list to the missing reference name; check it and your problem should go
away.

Regards

Kevin


"jrp444" <jrp444(a)discussions.microsoft.com> wrote in message
news:E3BAEEE4-70AD-450D-BB3A-466A3D7877D6(a)microsoft.com...
>I have been trying to use "format", Date(), "Mid", "Left"..etc. in a
>query.
> It gives me an error Undefined Function. Could some tell me what to do to
> fix this problem.


From: kc-mass on 26 Mar 2010 06:38
Open a module (Cntrl G) in your db. In the tools menu select "References"
You will likely find that one of the checked references has the word
"Missing"
placed in front of it. Make note of the reference like
"Microsoft Excel 11.0 Object Library". Uncheck the reference. navigate down
the list to the missing reference name; check it and your problem should go
away.

Regards

Kevin

"jrp444" <jrp444(a)discussions.microsoft.com> wrote in message
news:E3BAEEE4-70AD-450D-BB3A-466A3D7877D6(a)microsoft.com...
>I have been trying to use "format", Date(), "Mid", "Left"..etc. in a
>query.
> It gives me an error Undefined Function. Could some tell me what to do to
> fix this problem.


 | 
Pages: 1
Prev: How to show day of week
Next: Autofill field on form with values from another table