INVOICE

[Baine]

I am trying to generate an invoice from the data in the tables I have setup.
Tables: Projects, Customers, Employees, Hours, and Expenses. I created one
query for the projects and a sub-form for the hours. I created a new report
called Invoice. I dragged the query and the form to the report. The report
looks great. I added a field at the bottom of the sub-report to sum the
hours worked field. That also worked. One thing that is happening is when
I open the report a box opens asking for the parameter value of the
customerID. When the projects are entered into the database the CustomerID
is used. It is linked to the CostomerID field in the Customer table. Also
when I step through the records of the invoices it displays a blank page for
the second record and then displays the first invoice again for third
record. It keeps showing the two pages described here until I get to record
nine. It then shows the second invoice.

Should I be using a form with two querys for the invoice?
Should I be using a report with two querys for the invoice?

My son's small company with less than 500 invoices a year.
Using Access 2002

 

[Guest]

Hi

If you have a form that you use to input the amount, incoice date ect, then
you could create a new button to run the invoice (and filter the invoice
CustomerID). I have assumed that you have a field called CustomerID.

Something like this

Private Sub ButtonName_Click()
DoCmd.OpenReport "InvoiceName", acViewNormal, "",
"[CustomerID]=[Forms]![FormName![IDFieldName]", acNormal
End Sub

Change the form name and the ID field name to whatever it is you use.

Hope this helps

 

[Baine]

I will give this a try. Thanks for the help. I was doing it a different
way. I was posting the data into the tables and then trying to get the
report built that would allow me to step through the invoices and print the
last one posted. Your guidance in doing this a different way may be the
solution. I am not sure what acNormal is but I keep mine on high nost of
the year in Texas.

Hi

If you have a form that you use to input the amount, incoice date ect,
then
you could create a new button to run the invoice (and filter the invoice
CustomerID). I have assumed that you have a field called CustomerID.

Something like this

Private Sub ButtonName_Click()
DoCmd.OpenReport "InvoiceName", acViewNormal, "",
"[CustomerID]=[Forms]![FormName![IDFieldName]", acNormal
End Sub

Change the form name and the ID field name to whatever it is you use.

Hope this helps

--
Wayne
Manchester, England.
Enjoy whatever it is you do

I am trying to generate an invoice from the data in the tables I have
setup.
Tables: Projects, Customers, Employees, Hours, and Expenses. I created
one
query for the projects and a sub-form for the hours. I created a new
report
called Invoice. I dragged the query and the form to the report. The
report
looks great. I added a field at the bottom of the sub-report to sum the
hours worked field. That also worked. One thing that is happening is
when
I open the report a box opens asking for the parameter value of the
customerID. When the projects are entered into the database the
CustomerID
is used. It is linked to the CostomerID field in the Customer table.
Also
when I step through the records of the invoices it displays a blank page
for
the second record and then displays the first invoice again for third
record. It keeps showing the two pages described here until I get to
record
nine. It then shows the second invoice.

Should I be using a form with two querys for the invoice?
Should I be using a report with two querys for the invoice?

My son's small company with less than 500 invoices a year.
Using Access 2002