Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
good vb examples
- Thread starter ssj3gohan
- Start date
You could do a search on carl and gary's vb page -
Does any one can help to solve this problem:
I used data environment to produce report. Pass SQL statement as command object. But there is no record of the criteria set in the SQL statment and still the report display with blank page.
WHat I want is that if record does not match then the report should not appear on the screen.
Thanks
Faruque
I used data environment to produce report. Pass SQL statement as command object. But there is no record of the criteria set in the SQL statment and still the report display with blank page.
WHat I want is that if record does not match then the report should not appear on the screen.
Thanks
Faruque
mfi
Please don't hijack someone else's thread! Read faq222-2244 to see why you should start a new problem in a new thread.
To solve your current problem, check your recordset for EOF before showing the report:
If Not myRST.EOF then
DataReport.Show
Else
Msgbox "No records"
End If
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
Please don't hijack someone else's thread! Read faq222-2244 to see why you should start a new problem in a new thread.
To solve your current problem, check your recordset for EOF before showing the report:
If Not myRST.EOF then
DataReport.Show
Else
Msgbox "No records"
End If
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first
'People who live in windowed environments shouldn't cast pointers.'
- Status
