Hi

I have a purchase Order formerly using Excel to print it. Now I have prepared our own Purchase Order System and would like to know how to print my purchase order thru' Excel.

I will picking up some field from 2 or 3 table to form a query and then I have a ready purchase order, Now I would like to insert this field onto the ready made purchase order.

Due to too big the ready made purchase order (I have tried to zip but still too big). I cannot attached on this enquiry.

Pls help.


Thank you,

If you are going to print then try the report function. make a report based on your queries.

Then create a form to execute the report and put a print button and insert following code.

Private Sub Print_Click()
On Error GoTo Err_Print_Click

Dim stDocName As String

Query4Data

'replace rptdatafieldreport with your newly made report file
stDocName = "rptDatafieldreport"
DoCmd.OpenReport stDocName, acNormal

Exit_Print_Click:
Exit Sub

Err_Print_Click:
MsgBox Err.Description
Resume Exit_Print_Click
End Sub