New computer, new errors, old report

[Guest]

I just got a new computer (running Access 2000 as was my old)and several of
the queries and reports that ran fine on the old machine now come up with
errors. The 2 that I've found are in formulas in queries and reports.
Specifically, Access does not seem to be recognizing "Chr(13) & Chr (10)"
which I'm using to remove blank lines in a text box per MS knowledge base
article 209653.

THe other one that I've found is that it is not recognizing the word
"format" in a the fllowing formula "MSRevRec: IIf([Tbl_Milestones]![Revenue
Recognition Milestone]=-1,"Rev Rec - " & Format([Tbl_Milestones]![Rev Rec
DollarAmount],"$#,##0"),"")"

ANy one have any ideas?

 

[Jeff Boyce]

Darby

One possibility is that References are now MISSING. Open a code module,
click Tools | References and inspect the list of references checked. If any
are prefixed as MISSING, uncheck them (and make note of which ones). Close
the References window, accepting the changes.

Reopen the References, re-check them, and accept the changes/close.

Click Debug | Compile ... and see if your .mdb compiles successfully.