#Name? Error in control of an Access 2003 Form from DB built in Ac

F

FrankJ

I built a database in MS Access 2002 at home and brought it to work where I
have MS Access 2003. There is an expression on one of my forms that reads:

=IIf(BudgetAreasSubform.Form.RecordsetClone.RecordCount=0,0,[BudgetAmount]-BudgetAreasSubform.Form!TotalExpenses)

It works fine in Access 2002 but returns a #Name? in the field on the form
in Access 2003. Everything is spelled correctly and is in order in the
expressioon.

I am also having the same issue in another database that uses a subform and
an expression similar to the one above. Are there issues between the two
versions of Access?

If so is there a fix? Any help will be much appreciated...

Frank
 
F

FrankJ

Thanbks for the reply...there is no change...still returns the #Name?

KARL DEWEY said:
Try replacing the periods with an exclamation mark.

FrankJ said:
I built a database in MS Access 2002 at home and brought it to work where I
have MS Access 2003. There is an expression on one of my forms that reads:

=IIf(BudgetAreasSubform.Form.RecordsetClone.RecordCount=0,0,[BudgetAmount]-BudgetAreasSubform.Form!TotalExpenses)

It works fine in Access 2002 but returns a #Name? in the field on the form
in Access 2003. Everything is spelled correctly and is in order in the
expressioon.

I am also having the same issue in another database that uses a subform and
an expression similar to the one above. Are there issues between the two
versions of Access?

If so is there a fix? Any help will be much appreciated...

Frank
Click to expand...
Click to expand...
 
M

MONDAY

FrankJ said:
I built a database in MS Access 2002 at home and brought it to work where I
have MS Access 2003. There is an expression on one of my forms that reads:

=IIf(BudgetAreasSubform.Form.RecordsetClone.RecordCount=0,0,[BudgetAmount]-B
udgetAreasSubform.Form!TotalExpenses)

It works fine in Access 2002 but returns a #Name? in the field on the form
in Access 2003. Everything is spelled correctly and is in order in the
expressioon.

I am also having the same issue in another database that uses a subform and
an expression similar to the one above. Are there issues between the two
versions of Access?

If so is there a fix? Any help will be much appreciated...

Frank
Click to expand...
 
J

John Vinson

It works fine in Access 2002 but returns a #Name? in the field on the form
in Access 2003. Everything is spelled correctly and is in order in the
expressioon.
Click to expand...

Check your References. The RecordsetClone property is a DAO recordset;
this expression may not work unless you have the DAO object library
referenced.

Open the VBA editor, select Tools... References, and unless it's
already checked, scroll down to Microsoft DAO 3.6 Object Library and
check it; see if that helps.

John W. Vinson[MVP]
 
R

RTL

We were getting that when a DLL had a different version from one machine to
another. For us, that was a tricky one to diagnose :|

Good luck,

Rich
 
Top