Format

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I have the following statement in my module.
For some reason (I can't understand...) it is running on
one pc but not running on the other.
I am getting an error about format function. Can you help
me please....
qdf.SQL = "SELECT CVSSN, CVGRP, CVLOC, Format
(CVLECY, '00') & Format(CVLEYR, '00') & Format
(CVLEMT, '00') & Format(CVLEDY, '00') AS EFF, ...
 
anonymous said:
I have the following statement in my module.
For some reason (I can't understand...) it is running on
one pc but not running on the other.
I am getting an error about format function. Can you help
me please....
Click to expand...

Check the references (open code module, Tools:References, uncheck any
marked as MISSING).
 
Are you using any ActiveX controls in your application? If so check they are
properly installed and registered on the PC that gives the problem. I don't
know why this should cause this type of behaviour, but it happened to me - a
machine without some controls installed gave errors on various string
functions such as Left and Format.
 
Back
Top