Restricted Employee Access to Reports

[SetanPutih]

Thanks for the reply.. I really appreciate it. Just to clarify so its a single quote mark ' rather than a double quote mark " only around the EmployeeID?

 

[SetanPutih]

So the first line would look like.. ? Sorry again. Really new to this.

Select Case Me.List2.Value
Case "Employee Activity Report"
DoCmd.OpenReport reportname:="rptEmpActivity", WhereCondition:=’[EmployeeID]='’& gEmployeeID & ‘", view:=acViewReport
Case "Training"

 

[Gasman]

No, probably like

DoCmd.OpenReport reportname:="rptEmpActivity", WhereCondition:="[EmployeeID]=" & gEmployeeID , view:=acViewReport

TBH I have never used keyword parameters, just positional.

DoCmd.OpenReport "rptEmpActivity",acViewReport,,"EmployeeID=" & gEmployeeID

Intellisense will walk you through each parameter in turn.

https://docs.microsoft.com/en-us/office/vba/api/access.docmd.openreport

The quotes/or not are around the value of what you are looking for, not the name of the field.

HTH

 

[SetanPutih]

it Worked! You legend! If I could buy you a pint I'd buy you two.

Thank you

 

[Gasman]

Just glad I got it right.