Print Document direct from the form

ahafeez

Hello

I am finding a problem in code to generate an output direct from Access Form. I am explaining my problem with the help of example

I designed an invoice form on the MS Access and designed this document in MS Access Report designer and Crystal Report as well. What i need to do if i am on MS Access form and i am on invoice # 100 when i press "Print" button then from report invoice # 100 will be print.

Kindly send me a code which will use in print button.

Hafeez

PEB

You need to use:
1. docmd.openreport command for more info see help in Access about it

2. You need to change the SQL passed on the report! You have to introduce an filter that shows only the current record! This filter you can pass it bythe command docmd.openreport

The code as well as U do Copy Paste I can't do it without information about your Tables, queries, forms and reports that U use!

U have only to see the use of docmd.openreport as Macro or Code as U want!

msquared

You need to set criteria for opening the report same as with forms.

Expand|Select|Wrap|Line Numbers

 
Private Sub butPrint_Click()

Dim stDocName As String

Dim stLinkCriteria As String
 
    stDocName = "ReportName"

    stLinkCriteria = "[InvoiceNo]=" & Me.[InvoiceNo]

    DoCmd.OpenReport stDocName, acViewNormal, , stLinkCriteria
 
End Sub

Quote:

Originally Posted by ahafeez

Hello

I am finding a problem in code to generate an output direct from Access Form. I am explaining my problem with the help of example

I designed an invoice form on the MS Access and designed this document in MS Access Report designer and Crystal Report as well. What i need to do if i am on MS Access form and i am on invoice # 100 when i press "Print" button then from report invoice # 100 will be print.

Kindly send me a code which will use in print button.

Hafeez

Print Document direct from the form

re: Print Document direct from the form

re: Print Document direct from the form

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about