|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
December 7th, 2003, 05:08 PM
|
|||
|
|||
|
info window on report
I have a monthly report and I would like to show a window everytime the monthly report is empty telling the user that there are no reports for that month.
how can I do this? I've tried with IF but I keep getting error. hope you can help. thanks
|
|
#2
December 8th, 2003, 12:09 PM
|
||||
|
||||
|
Open the underlying query via DAO before opening the report and if RecordCount is 0 then pop up a MsgBox telling the user that there are no records for that month.
I guess you were trying something like that. Can you post the IF that causes error.
|
|
#3
December 11th, 2003, 08:18 PM
|
|||
|
|||
I did it. how?
in the properties box on the report theres' a field that's called "On No Data" there I put the Msgbox and after that I put Cancel =1 so it will automatically close when user pressed ok thanks for your help anyway, I appreciate it
|
|
#4
December 12th, 2003, 05:01 AM
|
||||
|
||||
That's great. congratulations!
__________________
BRegs, TBÁrpi "I can only show you the door. You're the one who has to walk through it."
|
|
| Viewing: ASP Free Forums > Database > Microsoft Access Help > info window on report |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
