Format Function Unavailable in Query or Control 
Author Message
 Format Function Unavailable in Query or Control

Is there any reason why the Format$ function would be unavailable under
WindowsNT in a query expression or in a control on a report? In the reports
in which I use the format$ function, Access fills the control with "#Name?".
Access tells me that the Format function is unavailable when I run the
queries. These same reports and queries work fine under Windows95. Anyone
know what's going on?  TIA.

Larry Kite



Sat, 23 Dec 2000 03:00:00 GMT  
 Format Function Unavailable in Query or Control
HI Larry,

Open a new module and check Tools/References on this problematic machine.
Uncheck anything marked as "Missing".

HTH
--
Dev Ashish (Just my $.001)
---------------
The Access Web ( http://home.att.net/~dashish )
---------------

:Is there any reason why the Format$ function would be unavailable under
:WindowsNT in a query expression or in a control on a report? In the reports
:in which I use the format$ function, Access fills the control with
"#Name?".
:Access tells me that the Format function is unavailable when I run the
:queries. These same reports and queries work fine under Windows95. Anyone
:know what's going on?  TIA.
:
:Larry Kite

:
:
:



Sat, 23 Dec 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Built-in functions unavailable

2. server function unavailable error

3. NPV function unavailable

4. Access Function InStrRev unavailable

5. Problems using format and format$ functions

6. What API Function to format a disk and How to format a disk

7. Making Control Methods and/or properties unavailable at runtime

8. Controlling Query Critieria With A Function

9. function used in query repeats for each query value

10. formatting rows and columns in unbound data control, rich text box control, or listbox control

11. How do I create a query then use data bound controls on the query

12. Query and concatenation in a Format(

 

 
Powered by phpBB® Forum Software