Time and Billing - Print Invoice Error 2465

M

Mike

I am using Microsoft Access 2003 and the Time and Billing Template (in Access
2003 format) downloaded from Microsoft's template site. I have spent a
considerable amount of time customizing the DB and have run into a problem
with the Print Invoice form. This form has an AfterUpdate [Event Procedure]
(associated with both the Start and End date fields) as follows:

Private Sub Begin_Date_AfterUpdate()
Me![Print Invoice Time Subform].Requery
Me![Print Invoice Expenses Subform].Requery
End Sub

However, it appears that there is no Print Invoice Time Subform embedded in
the Print Invoice form. (My understanding is that 'Me!' directs Access to
the current form and 'Requery' is a command to retrieve data. [This is my
first Access project and, while I've learned a lot I cannot seem to overcome
the issue described in this post.])

It appears, however, that the Time and Billing template included with Office
2003 does have these subforms embedded in the Print Invoice form, though that
template appears to have some problems as well.

It seems to me that something is not quite right as, according to the MS
template download page, thousands of people have D/L'd this template and an
exhaustive search reveals only one post on this issue in early November.
Further, how could it be that such a basic and necessary function of time and
billing -- i.e., the printing of an invoice, could be so flawed as to go
unnoticed. Am I doing something wrong? (I have retested the problem with a
fresh copy of the 2003 template as to exclude any modifications I made to my
version.)

Please help! Am I doing something wrong; problem with my system? Is there
an updated version? Is there a fix to apply/insert. If no user error, no
update or easy fix, would importing the Print Invoice form from the template
version that contains the subform (i.e., the T&B version that came with
Office 2003) into the updated web version of T&B solve the issue? If no to
all these, does anyone have any suggestions?

Thanks in advance,
Mike
 
H

Haris Rashid

hi Mike,

can you please post the link to the template. it will be interesting to
explore.

Thanks,
 
B

Brendan Reynolds

You're not doing anything wrong, the template really is broken.

I'm sure it would be possible to fix it, but only you can be the judge of
whether you think you will find it easier to fix it rather than starting
from scratch.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top