Report opening without record (1 Viewer)

[moi]

I need help of my report, I based my report to a query, and i wanted if no record to display, a message popup "no records to display", close the msgbox, focus will go back to "printmgr" form control where my selection starts..

thank you for any help..

 

[Gasman]

Use Dcount() on the report criteria before opening report.
Check record count of source on load of report. Exit report if zero.

 

[Pat Hartman]

Use the OnNoData event of the report to display your message.

You may also need to add error trapping in the event that opens the report to catch the 2501 error.

 

[tvanstiphout]

Use Dcount() on the report criteria before opening report.
Check record count of source on load of report. Exit report if zero.

That would require the db to be queried twice - unnecessary in light of the Report_NoData event.

 

[moi]

Use the OnNoData event of the report to display your message.

You may also need to add error trapping in the event that opens the report to catch the 2501 error.

Hi Pat,

Would you please expand, as a beginner, my knowledge is very limited.. Where is the "OnNoData" event, and the error "2501".

Appreciate your kind help on both of these.. Any link where i can get a good demo/sample, please.

Thank you.

 

[CJ_London]

Where is the "OnNoData" event

where all events are - in the property sheet events tab

and the error "2501".

this error can apply to many things (just google 'vba error 2501'). But you should have a message as well which tells you where to find it. Since you are talking about reports, my guess would be this link will be indicative

Access: Canceling Report generation causes error 2501

can't believe I am losing so much time on this one. I have an order form, and when I click on a button "reports", a dialog pop ups with a list of different reports to chose from. Double-clicking s...

stackoverflow.com

 

[moi]

where all events are - in the property sheet events tab
View attachment 113942



this error can apply to many things (just google 'vba error 2501'). But you should have a message as well which tells you where to find it. Since you are talking about reports, my guess would be this link will be indicative

Access: Canceling Report generation causes error 2501

can't believe I am losing so much time on this one. I have an order form, and when I click on a button "reports", a dialog pop ups with a list of different reports to chose from. Double-clicking s...

stackoverflow.com

Thanks CJ_London, I will check the link and see if i get to work.

 

[tvanstiphout]

2501 is not really an error. That's why in the Northwind 2 Developer Edition template's central error handler we write:
If lngError = 2501 Then Exit Sub '2501 = The OpenForm or OpenReport action was canceled. Not really an error.