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
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. |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
Invoice in time and billing database
"PC Datasheet" schreef in bericht ink.net... Fehn, If you are still having a problem and need help, contact me. I specialize in fixing problems in existing databases. You specialize in jobhunting ... 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! To Fehn: Steve just does *not* care about the newsgroups. He has *no ethics at all*. Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground. -- He abuses this group and others for job-hunting and advertising over and over again -- He is insulting lots of people here when they ask him to stop this -- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions (the latest 'star's': 'Access Resource' and Tom and Andy) -- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here -- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all': http://groups.google.com/group/comp....954261f9?hl=en -- Also recently it became clear that he has been spamming innocent people asking questions: http://groups.google.com/group/comp....3e5f58ad?hl=en So why would ANYBODY ever trust a person like him and hire him? ************************************************** ****** Explanation and more links on this answer: http://home.tiscali.nl/arracom/stopsteve.html Arno R |
#10
|
|||
|
|||
Invoice in time and billing database
Thanks for the warning....
"StopThisAdvertising" wrote: "PC Datasheet" schreef in bericht ink.net... Fehn, If you are still having a problem and need help, contact me. I specialize in fixing problems in existing databases. You specialize in jobhunting ... 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! To Fehn: Steve just does *not* care about the newsgroups. He has *no ethics at all*. Steve *only* cares about making *money*, and he acts as if the groups are his private hunting ground. -- He abuses this group and others for job-hunting and advertising over and over again -- He is insulting lots of people here when they ask him to stop this -- He posted as Steve, Ron, Tom, Rachel, Kathy, Kristine, Heather and ??? while asking questions (the latest 'star's': 'Access Resource' and Tom and Andy) -- He tries to sell a CD ($125,--) with FREE code he gathered from these groups here -- There even has been a 'Scam-alert' about him which has been explained recently in the thread 'To all': http://groups.google.com/group/comp....954261f9?hl=en -- Also recently it became clear that he has been spamming innocent people asking questions: http://groups.google.com/group/comp....3e5f58ad?hl=en So why would ANYBODY ever trust a person like him and hire him? ************************************************** ****** Explanation and more links on this answer: http://home.tiscali.nl/arracom/stopsteve.html Arno R |
|
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 |