On No Data Event. Displaying a Message if a Report Has No Records in Microsoft Access.

[@akokohjoel9854]

Thanks so much, you are the Oracle of ms access. You teach VBA with simplicity. I love that.

[@599CD]

Thanks for your kind words.

[@ryanw1906]

How are you handling the 2501 error event that happens when cancel = true when calling the invoice from DoCmd.OpenReport behind the invoice button?

[@599CD]

You could trap the error, or just "on error resume next" it.

[@tutsecret499]

Is there a way to create a database with a feature function median, mean and mode. The median is more important for me. Example sample: Data students grades. Would be nice if there is a button or something similar to calculate the median and generate reports with students grades with the median, mean, mode, deviation. In excel we have to make some steps before to use median. In pivot table there is a way to get the median, but still needs some steps before.

[@599CD]

Avg, Rank, Median: 599cd.com/Median --- before asking next time, just Search my site or Google it. I'm sure this video would have come up.

[@ericgerlach1207]

Love the RUSH references! Keep up the great videos!

[@599CD]

Thanks!!

[@Jojosmith342]

Richard always makes life easier for everyone who is searching for solution. Thanks a lot Richard for all your valuable time and hard work. Love every your class

[@599CD]

Welcome

[@muhammadasadkhan3466]

Could we have something similar for forms

[@599CD]

Sure... just use DCount to see how many records will be in the form before you open it. You could also do this with a report instead of On No Data. 599cd.com/DCount

[@VelidBiH]

I have different issue - I want to show on report - No Data, because it exports to PDF. I can omit creation of PDF, but I would rather send report that has 'no data' message on report itself. At the moment looking into changing to NO DATA report that shows only that message.

[@mikewashington4188]

Great tip and the heads up for unattended batch reporting. You are truly the magic man 😀

[@599CD]

Glad to help

[@mandjk8421]

Hey man! Your content is great , thank you! I’m hoping you might be able to help me as I’m brand new to access and DB design. I work at a small business. We do property tax appeals. Sometimes, two spouses/owners might have their own record for the same property. What’s the best practice for merging these accounts in access? If either spouse/owner calls our office, I want to see a single profile for the property show up. I also want to avoid duplications and bad data, ie, one record gets updated but the other does not. Thanks for all you do, I’m learning a lot from you!

[@599CD]

I would base the records on some kind of property ID. That way you are sure to have unique records.

[@ssdusd]

That is very nice Tips very helpful!!!

[@599CD]

Thanks

[@stephenbeswick2163]

That was very interesting type thank you.

[@599CD]

Welcome

[@paulinemaurice9189]

Exactly what I was looking for, thanks so much! :)

[@akokohjoel9854]

Pls can you guild me, I watch your video on ms access on cloud. What will it cost me for 3 users per annual.

[@599CD]

Check their website. Access Database Cloud: 599cd.com/ADC

[@easyspeak101]

Love the Rush-Trees reference. lol 😉

[@599CD]

The best!

[@ramiraghat8496]

Thank you

[@599CD]

Welcome

[@muhammadasadkhan3466]

You are star

[@samokoth1014]

Thanks bro

[@599CD]

Welcome