Help with Time and billing in Access 2003

[Tony Williams]

I have used the Time and Billing template from Access 2000 for some time now
and yesterday I upgraded to Access 2003. Now some of the formulas behind
form controls have #Name instead of the correct values eg the following
worked under Access 2000 and Access XP but I now have a problem with Access
2003
=IIf([Print Invoice Time
Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Print Invoice Time
Subform].[Form]![Total Hours])

Also I'm getting an error message in this line of code
nbrdays = Me.Total_Days which says invalid use of the .(dot) or ! operator
or invalid parenthesis

Again I haven't changed anything it worked OK in 2000 and XP

I realise there are spaces in the field names but this is as it is in the
Microsft template. I haven't changed anything else just did a staright
upgrade. Can anyone help with some reason as to why they won't now work
Thanks
Tony

 

[Arvin Meyer [MVP]]

More than likely, you have a reference problem, perhaps from something that
you once tried in the original database.

Go to any code window, and choose Tools ... References and bring up the
dialog box. Look for any references marked "MISSING" and either uncheck
them, if they're no longer needed, or use the Browse button to locate the
file. Some references just need updating, like a reference to Outlook 9.0
Type Library, may need to be unchecked, and you'll need to reference the
11.0 library. For more on references see Doug Steele's article:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html

 

[Tony Williams]

Thanks Arvin Whilst I know where the references are I don't really
understand them so I'll have a look at Doug's page and then post back if I
can't solve my problem. BUT tomorrow because I'm in the UK and it's 21.35 on
a Sunday night! Sad isn't it playing around with Access on a Sunday night
Thanks again
Tony

More than likely, you have a reference problem, perhaps from something
that you once tried in the original database.

Go to any code window, and choose Tools ... References and bring up the
dialog box. Look for any references marked "MISSING" and either uncheck
them, if they're no longer needed, or use the Browse button to locate the
file. Some references just need updating, like a reference to Outlook 9.0
Type Library, may need to be unchecked, and you'll need to reference the
11.0 library. For more on references see Doug Steele's article:

http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

I have used the Time and Billing template from Access 2000 for some time
now and yesterday I upgraded to Access 2003. Now some of the formulas
behind form controls have #Name instead of the correct values eg the
following worked under Access 2000 and Access XP but I now have a problem
with Access 2003
=IIf([Print Invoice Time
Subform].[Form].[RecordsetClone].[RecordCount]=0,0,[Print Invoice Time
Subform].[Form]![Total Hours])

Also I'm getting an error message in this line of code
nbrdays = Me.Total_Days which says invalid use of the .(dot) or !
operator or invalid parenthesis

Again I haven't changed anything it worked OK in 2000 and XP

I realise there are spaces in the field names but this is as it is in the
Microsft template. I haven't changed anything else just did a staright
upgrade. Can anyone help with some reason as to why they won't now work
Thanks
Tony

 

[Arvin Meyer [MVP]]

BUT tomorrow because I'm in the UK and it's 21.35 on a Sunday night! Sad
isn't it playing around with Access on a Sunday night

I'm reading this at the same time (i.e. 5 hours after you wrote it) Sad? No.
It's fun! You just need a bit more geek juice (high caffeine beverage)