View Single Post
  #7  
Old November 6th, 2005, 02: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.