|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 10th, 2006, 04:03 PM
posted to microsoft.public.access.forms
|
|||
|
|||
#Name? Access 2003
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? -- Thanks. Maria. 
|
|
#2
February 10th, 2006, 04:16 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? Access 2003
"Maria" wrote in message
news  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
|
|
#3
February 10th, 2006, 04:31 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? Access 2003
The control box name is "Account Balance" and the formula is "=IIf([Accounts
Subform].Form.RecordsetClone.RecordCount=0,0,[Accounts Subform].Form!Balance)". -- Thanks. Maria. "Tom Lake" wrote: "Maria" wrote in message news 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
|
|
#4
February 10th, 2006, 05:36 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? Access 2003
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.
|
|
#5
February 10th, 2006, 07:35 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
#Name? Access 2003
I had that once before.
A compact and repair fixed it. Don't know why, but it's worth a shot.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Access 2002 vs. 2003 | Neil | General Discussions | 51 | February 16th, 2006 10:18 PM |
| Suggestion on updating Access 2000 to Access 2003 | Irshad Alam | General Discussion | 5 | August 10th, 2005 01:51 PM |
| What is the difference between 2002 and 2003? | Red Sonya | General Discussion | 2 | March 1st, 2005 05:10 AM |
| Access 2003 | RK | General Discussion | 12 | June 14th, 2004 10:16 AM |
| Access 2003 less functional than Access 97? | George Hester | General Discussion | 2 | June 4th, 2004 04:53 PM |
Linear Mode
