If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Functions not working
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. |
#2
|
|||
|
|||
Functions not working
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" wrote in message ... 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. |
#3
|
|||
|
|||
Functions not working
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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|