A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Invoice in time and billing database



 
 
Thread Tools Display Modes
  #1  
Old October 1st, 2005, 02:36 AM
Fehn
external usenet poster
 
Posts: n/a
Default 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  
Old October 3rd, 2005, 11:48 AM
Vincent Johns
external usenet poster
 
Posts: n/a
Default

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  
Old November 4th, 2005, 07:29 PM
Fehn
external usenet poster
 
Posts: n/a
Default 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  
Old November 4th, 2005, 11:23 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default 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  
Old November 5th, 2005, 12:24 AM
Fehn
external usenet poster
 
Posts: n/a
Default 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  
Old November 5th, 2005, 11:15 AM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default 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  
Old November 6th, 2005, 03:36 AM
Fehn
external usenet poster
 
Posts: n/a
Default 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  
Old November 6th, 2005, 02:18 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default 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  
Old November 8th, 2005, 09:12 PM
PC Datasheet
external usenet poster
 
Posts: n/a
Default 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  
Old November 8th, 2005, 11:39 PM
John Marshall, MVP
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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 05: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


All times are GMT +1. The time now is 01:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.