#Name? Access 2003

[Guest]

I have a user that used the ledger template in Access 2002. We up graded to
Access 2003 and now when she opens the Accounts form, the box that should
show an account balance shows "#Name?" instead. She can still get the
account balance on a computer running Access 2002, but whenever she is on her
computer (and others) running Access 2003 she gets the same error in the
account balance box. The computer has XP service pack 2 and office 2003
service pack. Any ideas?

 

[Tom Lake]

I have a user that used the ledger template in Access 2002. We up graded to
Access 2003 and now when she opens the Accounts form, the box that should
show an account balance shows "#Name?" instead. She can still get the
account balance on a computer running Access 2002, but whenever she is on her
computer (and others) running Access 2003 she gets the same error in the
account balance box. The computer has XP service pack 2 and office 2003
service pack. Any ideas?

What's the name of the control? 2003 has more reserved words than 2002
Maybe that program has one of those new words in it.

Tom Lake

 

[Guest]

The control box name is "Account Balance" and the formula is "=IIf([Accounts
Subform].Form.RecordsetClone.RecordCount=0,0,[Accounts
Subform].Form!Balance)".

 

[HKComputer]

Are you working with a split database? Connecting to Foxpro Database?

Try accessing the table directly instead of through the forms and see
what happens.

 

[Guest]

I had that once before.
A compact and repair fixed it.
Don't know why, but it's worth a shot.