Free Lessons
Fast Tips
Topic Index
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Why Macros
Why Macros
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   2 months ago

A lot of people have asked me why there are six Advanced Access lessons covering macros between the Expert classes and the Developer classes.

I've never been a huge fan of macros. I think they're difficult to work with. I grew up a programmer. I learned BASIC on my TRS-80 back when I was 8 years old. So programming has always come naturally to me. I think in lines of code. Macros, to me, just make things difficult. You have to search through lists of commands and rearrange them in blocks - just counter-intuitive to me.

But, I also understand that some people don't want to learn programming. They have no ambition to be programmers. Macros allow them to add some simple automation to their database. And that's fine. That's reason #1 why I decided to do a few macro classes.

Reason #2 is because at the time, Microsoft had a web-based feature of Access available called Web Apps. These allowed you to take your database and put it on the web. Web Apps, however, didn't support VBA. They only allowed macros. So this is another reason why I wanted to put together some advanced classes for people learn to macros for Web Apps.

Around the time that I was finishing Advanced Level 6, Microsoft discontinued Web Apps, so I decided to stop the macro lessons and move straight into VBA programming. (Side note - a lot of Access haters took this announcement to shout to the world that Access itself was being discontinued, which was so far from the truth that the light from planet truth will take decades to reach us. Haters gonna hate.)

Even though there is a little bit of overlap I think it's still handy for people to learn some macros because you may encounter other databases that have macros in them. Also most of the Wizards create macros, so it's good to know the basics. I also do cover a lot of good material in those classes such as how events are handled.

I don't consider the advanced lessons as time wasted. There's a lot of good material in there. But yes, honestly, when I do re-record the series I will probably leave macros out and perhaps do a separate seminar on the side for just macros for people who don't want to learn programming.


Start a NEW Conversation
Only students may post on this page. Click here for more information on how you can set up an account. If you are a student, please Log On first. Non-students may only post in the Visitor Forum.
Subscribe to Why Macros
Get notifications when this page is updated

Check out these other pages that may be of interest to you:

3/31/2023Startup Form
3/29/2023Refresh v Requery
3/28/2023Requery in Place
3/27/2023On Got Focus
3/25/2023Access Developer 42
3/24/2023Percent Bug
3/23/2023Replication ID
3/22/2023Disable AutoSave
3/21/2023Database Launcher

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/1/2023 12:53:30 AM.
Keywords: macros advanced classes  PermaLink  Why Are There Six Advanced Access Lessons Covering Macros?