Invoice in time and billing database

[Fehn]

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.

 

[Vincent Johns]

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 <[email protected]>
Please feel free to quote anything I say here.

 

[Fehn]

I download the time and billing databse here nt this link...
http://office.microsoft.com/en-us/templates/CT011366791033.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.

 

[Brendan Reynolds]

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]"

 

[Fehn]

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.

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

I download the time and billing databse here nt this link...
http://office.microsoft.com/en-us/templates/CT011366791033.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.

 

[Brendan Reynolds]

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

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.

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

I download the time and billing databse here nt this link...
http://office.microsoft.com/en-us/templates/CT011366791033.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.

:

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 <[email protected]>
Please feel free to quote anything I say here.

 

[Fehn]

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

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

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.

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

I download the time and billing databse here nt this link...
http://office.microsoft.com/en-us/templates/CT011366791033.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.

:

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 <[email protected]>
Please feel free to quote anything I say here.

 

[Brendan Reynolds]

I don't have any information on that.

--
Brendan Reynolds

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

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

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.

:

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

I download the time and billing databse here nt this link...
http://office.microsoft.com/en-us/templates/CT011366791033.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.

:

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 <[email protected]>
Please feel free to quote anything I say here.

 

[PC Datasheet]

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
(e-mail address removed)
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!

 

[John Marshall, MVP]

Ambulance chasing AGAIN? These newsgroups are for free support...

John... Visio MVP

 

[Fehn]

Thanks for the warning....

You specialize in jobhunting ...


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 (e-mail address removed) 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.databases.ms-access/msg/46038ba2954261f9?hl=en
-- Also recently it became clear that he has been spamming innocent people asking questions:
http://groups.google.com/group/comp.databases.ms-access/msg/4f76d0ed3e5f58ad?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

 

[Fehn]

Very much helpfull!

Thanks again

You are welcome.
I hope these warnings help you and others indeed.

Arno R

 

[mvs83]

Thanks for the info. But did anyone ever find if there was a fix? I never
had this many prob's. with 2000 and now they are comeing out with the new
office!

 

[Brian Bastl]

mvs83,

no idea what you're referring to. If you're going to start a new thread,
then at least copy and paste the relevant points already discussed, so that
anyone here knows what you're talking about.

HTH,
Brian