Search results

'before calling the openreport command On Error Resume Next 'this line let's you pass through the error 2501 generated by the 'on no data event procedure when calling the report 'and setting cancel to true...

thanks to u both.. i've tried the Dcount approach and find it ammm, just consuming... i did the on error approach and i guess this single line saved me.. thanks...

i have a line to open report from a form: docmd.openreport 'reportname', acpreview the report i'm trying to open has a onNoData event procedure and set the Cancel argument to true. this should cancel the opening of the report is empty. but access sets a run time error.... how can i then...

thanks for the reply. yup! i bumped into snapshot viewer, the day i posted my Q, i ramaged through the posts and someone mentioned snapshot viewer and i thank the first who asked this question. now i'm off to sending my reports (with any objects i can include)! and the best part is i've got...

Hi! i'm new here and i've got loads of Qs hope any of you will/can help me. pls.. (begging!) 1. how can i set a report to create dynamically chart object(s)? i need to load a report (that follows a standard format) the problem is, the number of charts to be included within the report depends...