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
|
|||
|
|||
Help with Time and billing in Access 2003
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 |
#2
|
|||
|
|||
Help with Time and billing in Access 2003
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/Ac...nceErrors.html -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Tony Williams" wrote in message ... 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 |
#3
|
|||
|
|||
Help with Time and billing in Access 2003
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 "Arvin Meyer [MVP]" wrote in message ... 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/Ac...nceErrors.html -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Tony Williams" wrote in message ... 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 |
#4
|
|||
|
|||
Help with Time and billing in Access 2003
"Tony Williams" wrote in message
... 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) -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
Thread Tools | |
Display Modes | |
|
|