FORMAT function doesn't work in Access 97 
Author Message
 FORMAT function doesn't work in Access 97

The very simple FORMAT$ and FORMAT function doesn't work in Access 97. For example, the following function returns an error code when compiling the module:

txtDate = Format(Now(), "mm/dd/yy")

or

txtDate = Format$(Now(), "mm/dd/yy")

I get an error message:
Compile Error. Cannot find object or library.

Any thoughts???

Responses via email are appreciated.
Your help is appreciated. Thank you in advance.

John



Fri, 11 Aug 2000 03:00:00 GMT  
 FORMAT function doesn't work in Access 97

It looks like you have some problems with the Utility.MDA. Try to locate the
file to see if it exists and also check that it is located where Access
expects to find it.



Fri, 11 Aug 2000 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Access 97 doesn't understand VBA functions

2. Format function doesn't work in UserControl

3. Getting back the formatted MsgBox in Access 2000 that worked in Access 97

4. InStr doesn't work correctly in PowerPoint 97

5. Excel 97 - VB - FindFile doesn't work

6. Program from access 97 won't work in access 2000

7. Can't use format, trim, left functions in Excel 97 VBA

8. HELP : Access 97 doesn't recognize my MDB file

9. crystal 6, access 97, doesn't show all records

10. VBA Format Function in Access 97 SR-1

11. Problem w/Access '97 and Crystal Reports Formatting Time Fields

12. Access 97 Functions stopped working!

 

 
Powered by phpBB® Forum Software