undefined function (access 2000, win xp)

[jozino01]

hi,

due to my hdd crash, i moved from win 98/office 2000 to win xp home edit/office 2000.

now, when i try to run some queries/reports i am getting an error message undefined function 'format' for expression like format([curdate], "mmmmm')

any idea, please?

 

[PHV]

No missing references ?
when in VBE, menu Tools -> References ...

Does the database compiles properly ?
when in VBE, menu Debug -> Compiles ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jozino01]

well, there is no vba code, just queries and reports created in query/report view.
i tried repair and compact (done without any trouble) but still the same problem

 

[PHV]

I strongly suggest you check at least the references: you may have used some exotic controls ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

As PHV has suggested, if format is an undefined function you almost assuredly are missing a reference!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[jozino01]

what references? i just wrote these queries in sql view and system says undefined function left, undefined function format, etc.


SELECT LOGS.DATE, LOGS.NAME, LOGS.INVOICE, LOGS.PCS, LOGS.VALBS, LOGS.CHAINS, LOGS.PERCH, LOGS.SWIFTERS, LOGS.PERSW, LOGS.OTHER, LOGS.VALUE
FROM LOGS
WHERE (((Left(Format([DATE],"mm/dd/yy"),2))=[ENTER MONTH AS mm:]));


SELECT [CUTS].[CUTID], [CUTS].[NUMBER], FORMAT([CUTS].[CUTDATE],"MMMMM"), [CUTS].[CUTCHARGE], [CUTS].[MISC], [CUTS].[INBOUND], [CUTS].[REMAN], [CUTS].[TRUCKING], [CUTS].[COMMISSION], [CUTS].[DUTIES], [CUTS].[SCALING], [CUTS].[TOWING], [CUTS].[PROFIT], [CUTS].[EXP_VOLUME]
FROM CUTS;

 

[PHV]

what references?
when in VBE (Alt+F11) menu Tools -> References ...

Furthermore, does the DB compile properly ?
menu Debug -> Compiles ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jozino01]

no, debug/compile says "cannot find project library

 

[MichaelRed]

cannot find project library translates fairly directly to REFERENCES.



MichaelRed

 

[lespaul]

did you try PHV's FIRST suggestion:

when in VBE (Alt+F11) menu Tools -> References

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[jozino01]

well, i did the debug/compile, then i got an error message, i clicked ok, and unchecked references missing:microsoft activex plugin.
i have not any idea what caused all this trouble, but now it seems working ok again.
thanks everybody!