Microsoft Access Quick Queries #25: Access End of Life, Forms to Reports, Try It, and More!

In today's Quick Queries video, we'll answer a range of your tech questions. We'll explore misconceptions around Microsoft Access's end of life, sharing insights on versions and future support. You'll also learn efficient techniques for converting forms to reports using the 'Save Object As' feature. Discover how to set default print previews for reports and expand your Access VBA knowledge with a special code shared by one of our community members. For those struggling with viewing videos on mobile devices, we'll discuss the best way to consume our content. Additionally, get advice on avoiding ActiveX controls and hear some of our favorite community comments. Also we address the dynamic resizing of rows in continuous forms.
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Quick Queries #25: 599cd.com/QQ25
PREREQUISITES:
Quick Queries Listing: 599cd.com/Quic...
Quick Queries #24: 599cd.com/QQ24
LINKS:
Access Going Away: 599cd.com/Goin...
Access End of Life: 599cd.com/a?10...
Save Object As Report: 599cd.com/a?10...
Adam's Convert Form To Report: 599cd.com/a?83826
Try it Yourself: 599cd.com/Try
Treeview Control - Access Developer 20: 599cd.com/ACD20
Progress Bar: 599cd.com/Prog...
UP NEXT:
Quick Queries #26: 599cd.com/QQ26
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Deve...
Access Beginner 1: 599cd.com/ACB1
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/Diam...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Close All VBA Windows, Access VBA, Access Dropdown Problem, Convert Form to Report Access, Access Save Object As, Access Print Preview Report, Access Report Default View, ActiveX ListView Control Access, Access Programming Mistakes, Access Experimentation Techniques
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@bryancoleman773]

I like the screen you record at. People should be watching the road when driving, not videos. I enjoy all you videos - I do need to come up with how to remember what video you showed how to do what I am trying to do Thank you for taking time with what you do share with no fee. The Srek Trek sound effects in the backgroud is AWESOME!!

[@davidmunro5577]

Good idea Richard! I like it!

[@Micky-l4i]

70 / 5.000 Thank you Richard for your efforts Thank you and have fun at work

[@josemariaroman7057]

Collaborative learning is much more rewarding than knowing it all.

[@seanmahoney1077]

Chris Tyson @ 05:22..."I look at these videos while I'm driving". Accident looking for a place to happen!

[@giorgiorovelli1542]

Tech Help Free Template mentioned at 4:41 in the video but how do I get it?

[@josemariaroman7057]

Trying something that does not work is not failing, it is experimenting. Failing would be puting something together, sending it to production 'a lo loco' and creating a problem with the operations of your company. Try it, learn it, test it and release it to a small controlled group of users. You never know all unintended behaviors that could be happening.

[@appleintosh]

IT departments hate access because somebody will build a database for their little department, then leave the company, and now that department suddenly starts asking IT to support the database even though they had no involvement in its development and probably didn’t even know it existed. And let’s be honest, most people’s VBA and database architecture leaves a lot to be desired. It makes sense that IT wouldn’t want to touch it with a ten foot pole.

[@stuartround]

Hi Richard, if you like treeviews I have a lovely bit of code that replicates the Outlook treeview for selecting objects from Outlook without moving out of Access. If you'd like it, let me know and where to send it.

[@mitchellfolbe8729]

Please respond to this comment in >10 years.