Porting app from AccK to Acc2003

[Savvoulidis Iordanis]

Hi there
I found that after porting my app from Acc2000 to Acc2003 format with no
changes (just conversion), the
reports that have unbound expressions like "=[month_value] & " " &
[year_value]" give an error : #Name, although they work perfect in Acc2000.
Also I could not set a public function for use in an expression e.g.
"=MonthName([month_value])

I tried to create a new unbound text field with the same or another
expression like this one in a newly created report
e.g. "=[lname] & " " & [fname]", but I always get the ugly #Name value in
the text box.

The column names are in my query of course.

What's wrong?

 

[Andreas]

Check your references.
Go to a module, then choose Tools.References.
If there is a compatibility (extensibility) library, it is the culprit.
Untick it, and then try your report.

Regards,
Andreas

 

[Graham Mandeno]

Hi Savvoulidis

I suspect that your VBA project has missing references or won't compile for
some other reason. Open the VBA IDE (Ctrl-G) and click Tools>References to
ensure none is "MISSING". If (or when) that's OK, click Debug>Compile
<project> to ensure that all your code compiles.