Users Printing Individual Report From Data Entry Form Submit Button (Testing)

[Holli]

Hi June 7

I wasn't able to try the code until today. Having some trouble it prints all of the reports. Should I retrieve the record then print?

RunCommand acCmdSaveRecord
If MsgBox("Would you like to print your report?", vbYesNo) = vbYes Then
DoCmd.OpenReport "CAREER PATH ASSESSMENT EMPLOYEE REPORT", "EmployeeID" = Me.EmployeeID
MsgBox "Thank you for your participation. Please complete your Department Survey and any Department Survey you may have a skill set in."
Me.Requery
DoCmd.Close
End If

End Sub

Thanks



Holli

[pbaldy]

You have it in the wrong position. Look at help on OpenReport; you want this bit:

"EmployeeID" = Me.EmployeeID

in the wherecondition argument.

[Holli]

Thanks Paul

I made the changes to the code. Printing one page but it is blank. Only the report text prints not the user's answers. I can see the individual report in (Reports) but I can not pull it to print.

RunCommand acCmdSaveRecord
If MsgBox("Would you like to print your report?", vbYesNo) = vbYes Then
DoCmd.OpenReport "CAREER PATH ASSESSMENT EMPLOYEE REPORT", acViewNormal, , "EmployeeID" = "Me.EmployeeID"
MsgBox "Thank you for your participation. Please complete your Department Survey and any Department Survey you may have a skill set in."
Me.Requery
DoCmd.Close
End If

End Sub

[pbaldy]

You changed the wherecondition (and I just noticed it wasn't right anyway). Try

DoCmd.OpenReport "CAREER PATH ASSESSMENT EMPLOYEE REPORT", acViewNormal, , "EmployeeID = " & Me.EmployeeID

More info here:

BaldyWeb wherecondition

[Holli]

Great !!! Thanks Paul

Just one more question . Now I am printing multiple reports pages (4 or 9) but the printer status is total pages printed 1.

Any thoughts?

Again thanks so much

Holli

[pbaldy]

If a single report is 4-9 pages long, not sure why it would do that. If you're looping through and printing 4-9 1-page reports, that's would I would expect.

[Holli]

No just a one page report, but now it is showing duplicate entries for the same person in the report view and printing duplicate copies of same report.

Again thanks a lot, you saved me

Holli

[pbaldy]

Happy to help!