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
|
|||
|
|||
Invoice in time and billing database
Please Help.
I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. |
#2
|
|||
|
|||
Fehn wrote:
Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#3
|
|||
|
|||
Invoice in time and billing database
I download the time and billing databse here nt this link...
http://office.microsoft.com/en-us/te...366791033.aspx Im not sure if my computer has the problem or my office 2003. If anyone knows how to correct the run time error 2465 problem, please let me know. Thanks. "Vincent Johns" wrote: Fehn wrote: Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#4
|
|||
|
|||
Invoice in time and billing database
It's not your computer, neither is it your installation of Office. That
template is broken. The code behind the "Print Invoice" form contains several references to controls named "[Print Invoice Expenses Subform]" and "[Print Invoice Time Subform]", but no such controls exist. This is the cause of the 2465 error. On the report, the invoice total text box that is displaying "#Error" has the following expression as its control source ... =Forms![Print Invoice]![Total Expenses]+Forms![Print Invoice]![Total Hourly Billings] The form "Print Invoice" does not include any controls named "[Total Expenses]" or "[Total Hourly Billings]" -- Brendan Reynolds "Fehn" wrote in message ... I download the time and billing databse here nt this link... http://office.microsoft.com/en-us/te...366791033.aspx Im not sure if my computer has the problem or my office 2003. If anyone knows how to correct the run time error 2465 problem, please let me know. Thanks. "Vincent Johns" wrote: Fehn wrote: Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#5
|
|||
|
|||
Invoice in time and billing database
Thank you so much Brendan!
Since this template has been out a long time ago, did anybody fixed this already? If not, then, do you know how I can fix this? Thanks. "Brendan Reynolds" wrote: It's not your computer, neither is it your installation of Office. That template is broken. The code behind the "Print Invoice" form contains several references to controls named "[Print Invoice Expenses Subform]" and "[Print Invoice Time Subform]", but no such controls exist. This is the cause of the 2465 error. On the report, the invoice total text box that is displaying "#Error" has the following expression as its control source ... =Forms![Print Invoice]![Total Expenses]+Forms![Print Invoice]![Total Hourly Billings] The form "Print Invoice" does not include any controls named "[Total Expenses]" or "[Total Hourly Billings]" -- Brendan Reynolds "Fehn" wrote in message ... I download the time and billing databse here nt this link... http://office.microsoft.com/en-us/te...366791033.aspx Im not sure if my computer has the problem or my office 2003. If anyone knows how to correct the run time error 2465 problem, please let me know. Thanks. "Vincent Johns" wrote: Fehn wrote: Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#6
|
|||
|
|||
Invoice in time and billing database
On my PC, I have a version of the Time and Billing template that was
installed on my hard disk when I installed Access. This version appears to have fewer errors than the on-line version - in this version the Print Invoice form does have the two subform controls referred to in the code, and does have the two text boxes referred to by the expression in the control source of the text box on the Invoice report. Unfortunately, while it appears to have fewer errors then the on-line version, this template is not without errors of its own. If you want to try it, you can get to it from within Access 2003 by choosing 'New' from the 'File' menu, then 'On my computer ...' in the 'New File' task pane, then selecting the 'Databases' tab in the 'Templates' dialog. If you didn't do a complete install, it is possible that you may need to re-run setup and choose the option to add remove components. I'm afraid that Microsoft's templates appear to have a quality control problem, and frequently contain errors. Does this mean that they should be avoided? I'm not sure. Perhaps they contain no more errors than a beginner would make without using a template. Ultimately, you'll have to decide for yourself whether they have value for you. -- Brendan Reynolds "Fehn" wrote in message ... Thank you so much Brendan! Since this template has been out a long time ago, did anybody fixed this already? If not, then, do you know how I can fix this? Thanks. "Brendan Reynolds" wrote: It's not your computer, neither is it your installation of Office. That template is broken. The code behind the "Print Invoice" form contains several references to controls named "[Print Invoice Expenses Subform]" and "[Print Invoice Time Subform]", but no such controls exist. This is the cause of the 2465 error. On the report, the invoice total text box that is displaying "#Error" has the following expression as its control source ... =Forms![Print Invoice]![Total Expenses]+Forms![Print Invoice]![Total Hourly Billings] The form "Print Invoice" does not include any controls named "[Total Expenses]" or "[Total Hourly Billings]" -- Brendan Reynolds "Fehn" wrote in message ... I download the time and billing databse here nt this link... http://office.microsoft.com/en-us/te...366791033.aspx Im not sure if my computer has the problem or my office 2003. If anyone knows how to correct the run time error 2465 problem, please let me know. Thanks. "Vincent Johns" wrote: Fehn wrote: Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#7
|
|||
|
|||
Invoice in time and billing database
I used to have this time and billing database in office 2000 format, and it
works just fine... i dont know what happened in this 2003 format. do you know if they are fixing it? Thanks for your help "Brendan Reynolds" wrote: On my PC, I have a version of the Time and Billing template that was installed on my hard disk when I installed Access. This version appears to have fewer errors than the on-line version - in this version the Print Invoice form does have the two subform controls referred to in the code, and does have the two text boxes referred to by the expression in the control source of the text box on the Invoice report. Unfortunately, while it appears to have fewer errors then the on-line version, this template is not without errors of its own. If you want to try it, you can get to it from within Access 2003 by choosing 'New' from the 'File' menu, then 'On my computer ...' in the 'New File' task pane, then selecting the 'Databases' tab in the 'Templates' dialog. If you didn't do a complete install, it is possible that you may need to re-run setup and choose the option to add remove components. I'm afraid that Microsoft's templates appear to have a quality control problem, and frequently contain errors. Does this mean that they should be avoided? I'm not sure. Perhaps they contain no more errors than a beginner would make without using a template. Ultimately, you'll have to decide for yourself whether they have value for you. -- Brendan Reynolds "Fehn" wrote in message ... Thank you so much Brendan! Since this template has been out a long time ago, did anybody fixed this already? If not, then, do you know how I can fix this? Thanks. "Brendan Reynolds" wrote: It's not your computer, neither is it your installation of Office. That template is broken. The code behind the "Print Invoice" form contains several references to controls named "[Print Invoice Expenses Subform]" and "[Print Invoice Time Subform]", but no such controls exist. This is the cause of the 2465 error. On the report, the invoice total text box that is displaying "#Error" has the following expression as its control source ... =Forms![Print Invoice]![Total Expenses]+Forms![Print Invoice]![Total Hourly Billings] The form "Print Invoice" does not include any controls named "[Total Expenses]" or "[Total Hourly Billings]" -- Brendan Reynolds "Fehn" wrote in message ... I download the time and billing databse here nt this link... http://office.microsoft.com/en-us/te...366791033.aspx Im not sure if my computer has the problem or my office 2003. If anyone knows how to correct the run time error 2465 problem, please let me know. Thanks. "Vincent Johns" wrote: Fehn wrote: Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#8
|
|||
|
|||
Invoice in time and billing database
I don't have any information on that.
-- Brendan Reynolds "Fehn" wrote in message ... I used to have this time and billing database in office 2000 format, and it works just fine... i dont know what happened in this 2003 format. do you know if they are fixing it? Thanks for your help "Brendan Reynolds" wrote: On my PC, I have a version of the Time and Billing template that was installed on my hard disk when I installed Access. This version appears to have fewer errors than the on-line version - in this version the Print Invoice form does have the two subform controls referred to in the code, and does have the two text boxes referred to by the expression in the control source of the text box on the Invoice report. Unfortunately, while it appears to have fewer errors then the on-line version, this template is not without errors of its own. If you want to try it, you can get to it from within Access 2003 by choosing 'New' from the 'File' menu, then 'On my computer ...' in the 'New File' task pane, then selecting the 'Databases' tab in the 'Templates' dialog. If you didn't do a complete install, it is possible that you may need to re-run setup and choose the option to add remove components. I'm afraid that Microsoft's templates appear to have a quality control problem, and frequently contain errors. Does this mean that they should be avoided? I'm not sure. Perhaps they contain no more errors than a beginner would make without using a template. Ultimately, you'll have to decide for yourself whether they have value for you. -- Brendan Reynolds "Fehn" wrote in message ... Thank you so much Brendan! Since this template has been out a long time ago, did anybody fixed this already? If not, then, do you know how I can fix this? Thanks. "Brendan Reynolds" wrote: It's not your computer, neither is it your installation of Office. That template is broken. The code behind the "Print Invoice" form contains several references to controls named "[Print Invoice Expenses Subform]" and "[Print Invoice Time Subform]", but no such controls exist. This is the cause of the 2465 error. On the report, the invoice total text box that is displaying "#Error" has the following expression as its control source ... =Forms![Print Invoice]![Total Expenses]+Forms![Print Invoice]![Total Hourly Billings] The form "Print Invoice" does not include any controls named "[Total Expenses]" or "[Total Hourly Billings]" -- Brendan Reynolds "Fehn" wrote in message ... I download the time and billing databse here nt this link... http://office.microsoft.com/en-us/te...366791033.aspx Im not sure if my computer has the problem or my office 2003. If anyone knows how to correct the run time error 2465 problem, please let me know. Thanks. "Vincent Johns" wrote: Fehn wrote: Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. If you haven't invested much time yet in trying to use this database, I suggest you look for another source. Or you might ask the party from whom you got it what went wrong. I imagine you won't be happy with a database that does most things properly except that it prints wrong totals! :-) If you HAVE spent a lot of effort on it, AND you think you understand it well enough that you can replace all the parts that don't work, then you might try posting the details here. But you still might be ahead getting something that works properly to begin with. -- Vincent Johns Please feel free to quote anything I say here. |
#9
|
|||
|
|||
Invoice in time and billing database
Fehn,
If you are still having a problem and need help, contact me. I specialize in fixing problems in existing databases. -- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com If you can't get the help you need in the newsgroup, I can help you for a very reasonable fee. Over 1000 Access users have come to me for help. Need a month calendar or 7 day calendar? Need appointment scheduling? Need room reservations scheduling? Need employee work scheduling? Contact me! "Fehn" wrote in message ... Please Help. I downloaded the time ad billing database and I havent change anything, But when I checked the invoice, and I put a start date a run time error 2465 shows up, it also says Print Invoice Time Subform cannot be found and if i close the debugger the the report will show up and everything is ok except for the invoice total, it says error. |
#10
|
|||
|
|||
Invoice in time and billing database
Ambulance chasing AGAIN? These newsgroups are for free support...
John... Visio MVP "PC Datasheet" wrote in message ink.net... Fehn, If you are still having a problem and need help, contact me. I specialize in fixing problems in existing databases. PC Datasheet |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Time and Billing" database question -- access | SBC_2005 | New Users | 25 | May 31st, 2005 05:53 PM |
Anyone used the Time and Billing sample database? | Tony Williams | General Discussion | 2 | April 26th, 2005 09:29 AM |
"Time and Billing" database template | Lou DiNetta | General Discussion | 0 | November 5th, 2004 04:57 PM |
Modifications to Time and Billing database template | CCallies | Running & Setting Up Queries | 1 | September 8th, 2004 08:39 PM |
Time and Billing Database from MS Office Online | Stumped | New Users | 1 | July 20th, 2004 12:13 AM |