See Code Below, Need to Print out ALL Records, How???

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

On Error GoTo Err_Command75_Click
'Forms!FEmpTotHours.Visible = False
DoCmd.OpenReport "RCheckAll", acNormal, "",
"[EmployeeID]=[Forms]![FEmpTotHours]![EmployeeID]"

Exit_Command75_Click:
Exit Sub

Err_Command75_Click:
MsgBox Err.Description
Resume Exit_Command75_Click

--


---------------------------------------------------------------------
This email and any files transmitted with it from Dave Elliott are
confidential and intended solely for the
use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the
sender.
All Mail is pre-scanned with Norton Antivirus 2004 for your protection.

http://[email protected]
 
You are telling Access to open the report using
"[EmployeeID]=[Forms]![FEmpTotHours]![EmployeeID]" as a filter. That is, to
show only the records where EmployeeID equals the value of the specified
field on the specified form.

If you want the report to include all EmployeeIDs, remove that clause:
DoCmd.OpenReport "RCheckAll", acNormal

Hope this helps,
 
Back
Top