Handling Parameters in Reports

[Liz_I3]

I have two questions about how to handle paramenter in a report (run from a query).

First - if I enter a paramenter that produces a recordset with no data , how do I stop the report from being previewed. I just want a Message to come up No records for the data specifiec. I was going to use the Nodata event but thats for printing, I want to stop it from being previewed

The second question is - one of my parameters is a date (shortdate) field that asks for a start date and and end date. If the date is mm/dd/yy and the user enteres dd/mm/yy I want it to check for a valid date and if it is not a valid date send a message "Please enter a valid date". How do you refer to the date being imput by the user (that is asked for in the perameter) in is case a date which is to match a biweeklydate field in a query?

I would be greatfull for tips

thanks
liz

 

[guybrush]

First part of Quesiton:

Actually, I have used the NoData event to prevent
users from viewing a report in print preview mode.
Did you remember to cancel?

Private Sub Report_NoData(Cancel As Integer)
MsgBox " This Report is Empty. " & Chr(10) & _
" Please change the Criteria!", vbOKOnly, "Known Error"
Cancel = True
End Sub


Second Part of Quesiton:

I don't know of a way to "validate"
data when you use parameters in a report query.

However, I do know how to validate data on a form. My suggestion
would be to create a form that validates the dates before you open
the report. You could even present a nice calander for users
to click on (further simplifying validation).

Hope that Helps!