Conditional Display

[Guest]

I am making a database with a list of all of my employees. I have a report
that prints out all of their phone numbers. I just want the report to only
print out active employees. I have a Yes/No object in the table named
"Active". The form I have setup understands it but I'm not sure how to make
the report understand it too.

 

[Guest]

To the print report command line you can add a criteria

Dim MyWhere As String
MyWhere = "[Yes/No Active FieldName] = True"
Docmd.OpenReport "ReportName", , , MyWhere

 

[Guest]

I'm pretty new to Access. Where would I find that?

To the print report command line you can add a criteria

Dim MyWhere As String
MyWhere = "[Yes/No Active FieldName] = True"
Docmd.OpenReport "ReportName", , , MyWhere

--
\\// Live Long and Prosper \\//
BS"D

I am making a database with a list of all of my employees. I have a report
that prints out all of their phone numbers. I just want the report to only
print out active employees. I have a Yes/No object in the table named
"Active". The form I have setup understands it but I'm not sure how to make
the report understand it too.

 

[Guest]

I'm still not sure how to make this work. Any ideas?

I'm pretty new to Access. Where would I find that?

To the print report command line you can add a criteria

Dim MyWhere As String
MyWhere = "[Yes/No Active FieldName] = True"
Docmd.OpenReport "ReportName", , , MyWhere

--
\\// Live Long and Prosper \\//
BS"D

I am making a database with a list of all of my employees. I have a report
that prints out all of their phone numbers. I just want the report to only
print out active employees. I have a Yes/No object in the table named
"Active". The form I have setup understands it but I'm not sure how to make
the report understand it too.

 

[Guest]

I'm sorry it took me a while to come back to you, create a button on the form
where you got the active employee, and on the button OnClick event add this
code

Check this link, it might make things more clear

http://www.databasedev.co.uk/report_from_form_record.html

--
\\// Live Long and Prosper \\//
BS"D

I'm still not sure how to make this work. Any ideas?

I'm pretty new to Access. Where would I find that?

To the print report command line you can add a criteria

Dim MyWhere As String
MyWhere = "[Yes/No Active FieldName] = True"
Docmd.OpenReport "ReportName", , , MyWhere

--
\\// Live Long and Prosper \\//
BS"D


:

I am making a database with a list of all of my employees. I have a report
that prints out all of their phone numbers. I just want the report to only
print out active employees. I have a Yes/No object in the table named
"Active". The form I have setup understands it but I'm not sure how to make
the report understand it too.