How to fix error in Time and Billing Template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There is an error in the 'Time and Billing' template that comes with Access which makes it useless. I am wondering if anyone knows the solution. In the form Clients>Preview Invoice>Print Invoice there is an error "#Name?" in the fields for 'Total Hours', 'Total Hourly Billing', and 'Total Expenses'. This is the information that is used to create the Invoice, so it makes the entire database non-functional. In design view of the form "Print Invoice" the formula for Total hours is " =IIf([Print Invoice Time Subform].Form.RecordsetClone.RecordCount=0,0,[Print Invoice Time Subform].Form![Total Hours]) ". I do not understand the coding enough to understand where the error might be. Please let me know how to fix this problem in the database.
 
Is that just an observation, or do you need some specific
help? :)

-----Original Message-----
There is an error in the 'Time and Billing' template that
Click to expand...
comes with Access which makes it useless. I am wondering
if anyone knows the solution. In the form Clients>Preview
Invoice>Print Invoice there is an error "#Name?" in the
fields for 'Total Hours', 'Total Hourly Billing',
and 'Total Expenses'. This is the information that is
used to create the Invoice, so it makes the entire
database non-functional. In design view of the
form "Print Invoice" the formula for Total hours is " =IIf
([Print Invoice Time
Subform].Form.RecordsetClone.RecordCount=0,0,[Print
Invoice Time Subform].Form![Total Hours]) ". I do not
understand the coding enough to understand where the error
might be. Please let me know how to fix this problem in
the database.
 
Back
Top