Quick Queries #50
By Richard Rost
8 months ago
Difference Between Form Controls and Fields in VBA In this Microsoft Access tutorial, I will show you how to handle common questions about naming form controls and fields, using the dot and bang operators in VBA, deciding between using Excel or Access for managing small databases, understanding membership options on my site, and the differences between working with macros and VBA in Access. This video also addresses questions about downloading exercise files, membership access issues, and tips for getting help with troubleshooting your databases. PrerequisitesLinksRecommended CoursesUp Next
Keywords TechHelp Access, AccessLearningZone.com, Captains Log, form controls, text box naming, control source, field naming, me operator, bang operator, LastUpdated, membership benefits, fitness database, exercise files, VBA vs macros, events, course access, event timing, trusted location, macro lessons
Intro In this video, we answer a range of viewer questions about Microsoft Access, including the difference between control names and field names on forms, how the Me dot and Me bang syntax work in VBA, and tips for avoiding errors by matching control and field names. We also talk about choosing between Excel and Access for your database needs, explain how AccessLearningZone membership and video access work, discuss the availability of free Access Beginner files, and compare using macros versus VBA in Access.Transcript Welcome to another Quick Queries video brought to you by AccessLearningZone.com. I am your instructor, Richard Rost.
Today is going to be a short one. I have been dealing with some dental issues over the past week or so, and let's just say it has not been a fun week. I have been writing about it in my Captain's Log, and if you are not following the Captain's Log, it is on my website - the little blog that I do. I try to write something every day, and it is more behind-the-scenes stuff. Sometimes it is an Access deep dive, sometimes it is personal stuff, my rants, philosophy, Star Trek references, all that kind of stuff. So check it out. I will put a link down below if you want to subscribe to it. It is just another little way to keep in touch.
All right, let's head over to the YouTube grab bag here. Let's see what we have. One of the reasons I want to mention the Captain's Log is because Fun in the Rain 13 asked if I have released part 15 yet, because members can see the videos as soon as I post them on YouTube, even though I schedule them to come out once a day. I am lucky that I have scheduled these to go out a week in advance because I have not been able to talk for the last four or five days. If you are not a member, you would not notice anything because you see your video coming out every day, but members have had access to all these for the past week or so. Part 14 is the last one that is up online and that one goes live Tuesday for the rest of the world, but I am working on it.
In fact, I have several more levels ready to go. I just have to record; I have them all outlined. I have not been able to talk, so I have been sitting here doing stuff and working on things, and I have it all fleshed out. We are going to be doing some major revisions to it when we come back. That is okay because that happens with databases a lot. Sometimes you start off with a road map of what you want to accomplish, and then you get halfway through it, and you are like, no, this is not flowing well, so let's change it. You are going to see we are going to do some fun stuff, but sit tight. I plan on doing some more recording this weekend now that I can actually move my jaw, and we will get to it soon. Thanks.
Both Jangles 52 said they do not pay you enough, Rick, oops, that is us. Click that blue join button down below and take care of that.
All right. Rick Level is working with my timestamp video, and it says, hey, to change the VB code to me.LastUpdate = Now, I keep getting an error that it thinks LastUpdate is a variable that is undefined. Why did I have to do this? But it works for you without the me. I wonder.
Normally, I tell people not to use that me. Me is something that you normally have to use only for form properties. I can always tell when someone sends me some code or a database or whatever and they have me.FirstName, me.LastName everywhere. Generally, me is only reserved for form properties, things like me.Caption. You can set the caption of the form.
Now, as a courtesy, what Access does for you is it takes the form controls like FirstName, LastName, LastUpdated, that kind of stuff, and it will create properties out of them, but it does not always work. I do not like relying on them. In your particular case, what this is telling me is if me.LastUpdated worked, that means you might have a control, a text box on the form, named LastUpdated, but it is not bound to a field called LastUpdated. When it is trying to say lastupdated = whatever, it does not know what you are talking about because maybe you have the field name spelled wrong in the underlying table, I do not know. There are a bunch of different things it could be.
What you will end up with is me! (the exclamation point), me!FirstName, that goes right to the field. Me.FirstName goes right to the control, which is usually bound to the field. That is why I say, if you are going to put a field on a form, it is best to have it with the same name so the control source and the text box itself have the same name. What I am thinking is maybe you do not have LastUpdated as the actual field name, but you named the text box LastUpdate, as you can do that.
For example, here is FirstName, and I made a button called DoStuff, and all DoStuff is doing is setting FirstName equal to Joe. If I click it, simple enough, that works.
Now, if you said me.FirstName = "Joe", that is going to work just fine because that control is called FirstName. So me.FirstName is that control, that text box. Likewise, you can talk directly to the field in the form with the bang operator. That is what that does. If I hit it, it works the same.
Now watch this distinction. Let me rename the control. So instead of FirstName, it is going to be called CustomerFirstName, but it is still bound to a field called FirstName in the table. FirstName is the field; CustomerFirstName - actually, let's call it FirstNameBox so we know it is the text box.
Close and reopen. If I come over here and just say FirstName = "Joe", nothing appears to have happened, but look, the record went dirty. Why is that? Because it changed the field, the FirstName field in the record, but the text box did not update. It changed the value in the background. If I move off this record and back to it again, it did update, but the text box did not update. It is weird, I know. So let's try it again and put it back to Richard.
If I come in here and say me.FirstName and hit the button, same thing - it updated it, but in the background.
Now, what if I say FirstNameBox = "Joe"? Well, it changed the actual box, and now you can see it. What if I try this with a bang in there? Sometimes it will work too, regardless of whether it is bound or not. If you just do this, it will work too.
That could be why you are thinking it is not working. Maybe one is named differently from the other, and it is making that change. Watch the dirty pencil over here. It could be making that change in the background, but it just does not appear to be working for you.
That is why I always say if you can, always make sure that your boxes and stuff are named the same as their control source. Once in a while you are going to have to make a different one, like if you have something in a footer and then again in the detail section, and it is bound to the same field, but you want to be able to change these. Once you have to be FirstName2 or whatever, but you only really need that me when you are dealing with the properties of the form, like me.Caption = either, and that will change the form's caption because that is a property of the form.
Access, as a courtesy, turns all these boxes into properties as well because they know that people will type this in, but you do not need the me unless you are dealing with form properties.
Check that out and see what it might be. This is why I like doing stuff like this in the forums on my website because we can go back and forth, you can post screenshots. It is hard doing any kind of troubleshooting in YouTube comments because I do not often check the replies. I am in here maybe once a week.
Based on what you told me, my guess is your text box is named LastUpdate, but the field that it is bound to is not named the same thing. That is my guess, and I could not tell you without seeing it.
Next up, TheGreat1207 said it is crazy that I came to the channel today because I am trying to build my own fitness database. Will this be added to the free templates? Is there a way to pay to get a copy of the database?
One of the ways I get people to join as a member is that you can download the databases that I build in the TechHelp video. If you join as a Gold Member, then you can download all of the fitness databases with all the extended cut perks too. Right now it is 9.99 a month, so yes, that is the cost to download it, or you just follow along with the videos and build it yourself, and you will learn better that way too. You will learn better by building the database yourself as opposed to just downloading mine.
That is okay; some people like to learn by tearing my databases apart too. When I was first learning Access, I learned a lot by tearing apart the Northwind database, the sample database that came with Access. I learned so much by just seeing how they built stuff, so both methods work.
BungMe4164 says this is the best video on YouTube, very clear and concise. Yes, I agree. Thank you very much. It is the best video ever put on YouTube! No, seriously, I am pretty proud of this one myself. That is a good one. Thank you, though.
GoneFishin2006 says, I am replying to my little video that I did where I got mad at Quora because they just deleted my Microsoft Access space that I created on their site after a few years of building it, and no warning, nothing. He said that he just deletes and filters it as junk because it is.
I actually have to disagree. I used to read Quora on a regular basis. I get their newsletter with a digest. There is lots of cool stuff on there, lots of cool posts, lots of stuff from people from different sciences I used to follow, and people giving answers and just all kinds of different walks of life. I used to enjoy reading that as just something, for example, for toilet-time reading, not serious book reading, but it was enjoyable. I even paid for their Quora Premium, or whatever it was, it was like 40 bucks a year to not have to see ads and stuff, but they decided to nuke me. All right, bye. It used to be good. It has gone downhill over the last couple of years.
I get asked this a lot. Nature-Retreating says I am starting my role as Administration Officer, trying to create a database for the children registered in our organization. I am trying to ask if it is better for me to create a database in Excel or Access.
I have a whole separate video on that which discusses the differences between Excel and Access. Here is a link to it right there, and I will put a link down below for you.
This depends: what is the size of your organization? If we are talking about a small school with maybe 15 or 20 classes, and you have a couple hundred kids, you could very easily manage and maintain that in Excel without a problem. Even if it is something where you feel like you might want a database, there is no shame in starting it in Excel and using that to track. Start a sheet for your students, and then if you are a private school, you are doing billing, keep a sheet for your billing. That will at least help you build a road map so you know when it comes time to build your Access database: what tables you are going to need, what fields you need in those tables, what stuff has to relate to each other, because one of the powers of Access is that you can relate things together. You can set up a student ID, and that can link to their courses.They're enrolled in, or there's their billing information. So it's not just all separate, disjointed Excel sheets. This really depends on what your needs are and how big your organization is. If you're a small private school with a couple of classes, I wouldn't necessarily say you need a full database for that. Start it in Excel, and then when it gets to be, you know, you've been using it for a month or two and you see how it's going, then you can make that decision on whether or not to upgrade it to Access. But watch that video; it'll give you a lot more information.
I get this one a lot: "I'm a member. When I try to view a YouTube video for members only, I'm unable to watch it. The only option I see is to join, but no login option. Is my only choice to log into your site and search for the video there?"
Yes, Robert, if you are signed up as a member on my website, then you have to watch the extended cut videos on my website. I just checked, and you are, and you have an account there, and I see you logged in recently, maybe after you made this post five days ago.
One of the things is it's two separate membership systems. If you sign up on YouTube, you can watch the members videos on YouTube, and then you just have to email me so I know you exist and I can set you up with an account on my website as well.
But if you sign up directly on my website, I can't give you access on YouTube. I have no control over that. I can't just set someone up as a member. I wish I could, but I can't. They don't let you do that.
So as long as you're happy being a member on my website, then that's fine. The only downside is you have to watch the extended cuts there. That's all.
Collins says, "Well presented, keep up the good job of skilling the word." Whatever that means. Are the exercise files available? Yes. Access Beginner 1 is completely free. The exercise files are on my website. I'll put a link down below. You can download the databases, the handbook, the video files, everything about Access Beginner 1 is completely free.
Why is it free? Well, because I want you to love it and come back and buy more, and that's why I put these online for free.
Adrian says, "I'm a silver member. Thank you. If I start a course of VBA and pay for it, will it remain open for good to look back, or is there a limited time period?"
It depends on which membership you choose. If you join as a Learning Connection member, that's where you get a new class every week or at whatever interval you pick, and you get a 50 percent discount. Those are yours to keep forever.
If you join as what I call the MYOLP, the My Online Learning Membership, that's like an all-you-can-eat buffet. You get access to everything, but only while you're a member.
So it all depends on which one you want, and if you have any more questions, just email me and I'll be happy to answer them for you.
I've got multiple memberships available because over time, different people have wanted different things. Some people have always said, "I want to learn, but I can't watch too many too fast," so that's why I've got the weekly one. Then I've got other people that want everything at once, so then I've got that one. Whatever you like, I try to accommodate.
But if you just purchase a course outright, which you can do as well without becoming a member, that's yours forever. There's no time limit. You can download the videos and watch them on a plane, and watch them when you're 90 years old. I don't care.
Next up, O'Cott from Uganda says he wants to see some videos on macros instead of VBA because VBA is quite tricky to understand. I actually think it's exactly the opposite. I think that VBA is so much easier to understand than macros are, and they're so much easier to work with. You only really have to learn a handful of commands for 90 percent of what you're gonna do, and the macro editor is just so bulky and difficult. You have to pick from combo boxes and click and drag to move stuff around. I've never liked working with macros in Access.
I do have six lessons on my website; I called them the Advanced Lessons. They're sandwiched in between the Expert Series and the Developer Series. Expert is all non-programming stuff, but it's all functions and methods and that kind of stuff. The Advanced courses go into macros, and I've got six levels of them, and I teach you how to do a lot of stuff with macros. This is for the people that don't want to be VBA developers.
But, if you're gonna go this far, I would... Maybe it's because I'm a programmer, and I've been a programmer since I was eight years old. I learned BASIC when I was almost still in diapers, but I've just always found VBA easier than working with macros.
I was gonna do more with macros because I started making these back when Microsoft was pushing the Access web page thingy. What do they call them? Data Access Pages or whatever. It was supposed to allow your Access database to work on the web, but those were all macro based, so I thought, okay, cool, I'll do some macro lessons to get people into this and we'll move into that.
By the time I got to level six of this, they announced that they were canceling it, so I stopped making macro lessons. Honestly, most people don't even like these. When I say these, I mean macros, not these lessons - these lessons are awesome.
As far as content, I do cover a lot of things like event timing and when certain events run, like the On Current event, the On Double Click event, tying macros to events, and when we get to the Developer Series, we take all of these things that we did with the macros and we get rid of the macros. I show you how to do all the same stuff with VBA code so you can appreciate how much easier VBA is. I can write one line of VBA code - it's like a six-line macro, and it's just easier.
But am I gonna do more with macros? Probably not, honestly. I really don't like macros. There are a few things you can only do with macros; I've got some videos on that, like checking to see if your database is in a trusted location, but I don't really see a lot more macro stuff coming down the line. Maybe once or twice here or there - I don't know. We'll see.
If you - and I mean anybody other than O'Cott - want to see me make some more macro videos, then post a comment down below and we'll see how many people are interested.
I said I was gonna keep today's video short, and here we are almost at 17 minutes. Once I get talking about this stuff, I could just go all day with Quick Queries. I could sit here and answer questions all day, but I'm gonna go take some ibuprofen and ice my jaw.
That's gonna do it for today's Quick Queries. I'll be back Monday with Fitness Part 13, and I've got a lot more recording to do over the weekend. I hope you learned something. Live long and prosper, my friends. I'll see you next time and enjoy your weekend.
TOPICS:
Difference between control name and field name in Access forms
Use of Me dot syntax versus Me bang syntax in VBA
Why naming form controls to match field names is recommended
Binding text boxes to fields in Access forms
How Access interprets Me dot and Me bang references
Updating form controls and fields using VBA
Troubleshooting 'variable not defined' errors in Access VBA
What happens when control and field names differ in forms
Renaming controls and its effect on VBA references
How Access defaults form control properties as object properties
Members-only YouTube video and website access differences
Handling Access membership systems for content access
Availability of free Access Beginner 1 exercise files
How to obtain Access exercise files from the website
How to keep access to purchased courses
Explanation of different AccessLearningZone membership types
Differences between Excel and Access for tracking data
How to start tracking organizational info in Excel
Macro versus VBA use in Access
Why VBA may be easier to use than macros
Events covered in Access macros such as On Current and On Double Click
When to use macros versus VBA in Access
History of macros in Access web apps (Data Access Pages)
Where to find Access macro training in Advanced Lessons
COMMERCIAL:
In today's video, we're discussing a variety of questions from viewers in another Quick Queries session. We'll talk about whether you should use Me in Access VBA and the difference between field names and control names on forms, how to decide if you should build a database in Excel or Access, details on accessing members-only and extended cut videos on the website versus YouTube, and which membership types let you keep courses forever. We'll also touch on where to find free Access Beginner files, talk about macros versus VBA, and why there may not be many new macro lessons coming up. You'll find the complete video on my YouTube channel and on my website at the link shown. Live long and prosper my friends.Quiz Q1. What is one reason Richard suggests keeping the control name and the field name the same in Access forms?
A. It avoids confusion and ensures that code works consistently
B. It automatically updates the forms caption
C. It prevents the form from going "dirty"
D. It allows Access to automatically generate reports
Q2. In Microsoft Access VBA, the "me" keyword is typically used for:
A. Table properties only
B. Only field values in a record
C. Form properties and controls
D. Only report objects
Q3. What does the "bang" operator (exclamation point), as in me!FirstName, do in Access VBA?
A. References a form property
B. Refers directly to a field or control by name
C. Creates a new database object
D. Converts the value to uppercase
Q4. If a text box on a form is named differently from its bound field, what potential issue did Richard describe?
A. The form's caption will not update
B. Data changes might not appear immediately in the text box
C. The database cannot save new records
D. Forms cannot be closed
Q5. According to the video, when is it acceptable to have control names different from field names in a form?
A. Always, to improve readability
B. When you need to reference similar fields in different sections, like a footer and detail section
C. Only in subforms
D. Only when using macros
Q6. What is a benefit of being a Gold Member on AccessLearningZone.com as mentioned in the video?
A. Access to all free courses only
B. Ability to download all databases and extended cut perks
C. Lifetime access to all Microsoft products
D. Direct technical support via phone
Q7. What advice did Richard give about choosing Excel versus Access for tracking student information?
A. Always use Access, regardless of the size of the organization
B. Start in Excel if the scale is small, then consider upgrading to Access if needed
C. Use Word for small databases
D. Only use Access if you are experienced in SQL
Q8. Why might a member of AccessLearningZone.com sometimes be unable to view member videos on YouTube?
A. Membership on the website and YouTube are separate systems
B. The videos are only available during business hours
C. YouTube no longer supports Access tutorials
D. The member's browser is outdated
Q9. If you purchase a course outright (not using a membership), what is the access policy according to Richard?
A. You have a limited period to access the course
B. Access lasts only as long as you remain a subscriber
C. You get lifetime access and can download the materials
D. The course must be renewed every year
Q10. What is Richard's opinion about VBA versus macros in Access?
A. Macros are much easier than VBA for most tasks
B. VBA is generally easier to learn and more flexible than macros
C. Macros provide more event options
D. Macros are required for all advanced features
Q11. What was Richards criticism of working with macros in Access?
A. They cannot interact with tables
B. The macro editor is bulky and difficult to use compared to VBA
C. Macros produce less reliable results
D. Microsoft has removed all macro support
Q12. What should you do if you want to see more macro videos from Richard?
A. Email Microsoft support
B. Post a comment to let him know you're interested
C. Subscribe to the Quora newsletter
D. Only watch the Developer Series
Q13. Why did Richard stop making more macro lessons after level six?
A. He lost the source code
B. Microsoft canceled the Data Access Pages feature, which relied on macros
C. Macros were deprecated in Access 2010
D. Students preferred Excel instead
Q14. What is given for free on the AccessLearningZone.com website, according to the video?
A. All content on the website
B. Access Beginner 1 course, databases, handbooks, and videos
C. Only exercise files for members
D. Only paid courses are available
Q15. What learning method does Richard suggest helps you learn Access best?
A. Only watching video tutorials
B. Building the database yourself as you watch
C. Reading the handbook without practice
D. Relying solely on sample databases like Northwind
Answers: 1-A; 2-C; 3-B; 4-B; 5-B; 6-B; 7-B; 8-A; 9-C; 10-B; 11-B; 12-B; 13-B; 14-B; 15-B
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.Summary In today's Quick Queries video from Access Learning Zone, I will be addressing a range of questions from viewers. This is a shorter session than usual, as I have been recovering from some dental issues this past week. If you're interested in what goes on behind the scenes or want to read more about what I've been up to, make sure to check out my Captain's Log on my website. It's my daily blog where I share a mix of Access insights, personal updates, my thoughts on various topics, and sometimes even Star Trek references.
Now, let's get into the questions from the YouTube comments.
First, Fun in the Rain 13 asked about the release schedule for my video series. Members on my site get early access to videos as soon as they're uploaded, even though public releases are paced at one per day. This has worked out well lately, especially since I had to schedule videos ahead while I couldn't talk for several days. If you're not a member, you would not notice a difference—your videos are released daily as scheduled. For members, the most recent one available now is Part 14, which goes live for everyone else on Tuesday. I already have several more parts outlined and ready to record, and now that I'm finally able to speak again, I plan to get back to recording this weekend. Sometimes, as you work through a database project, you realize you need to change direction, and that is completely normal in Access development.
There was a quick comment from Jangles 52 about supporting the channel. If you'd like to help keep the tutorials coming, there is an option to join as a member on the channel.
A technical question came in from Rick Level, who is working with my timestamp video. He mentioned encountering an error when changing his VB code to use me.LastUpdate = Now, where Access seems to think LastUpdate is an undefined variable. This leads to a common area of confusion in Access VBA. Typically, I tell students to use me only for form properties like me.Caption. While Access does let you refer to controls like me.FirstName or me.LastName as a courtesy, it does not always behave consistently. If me.LastUpdated works for you, that likely means there is a control on your form named LastUpdated. If it's not working, the field and the control names might not match up. The exclamation point syntax, as in me!FirstName, directly references the underlying field, while me.FirstName refers to the control on the form. It's best to name your controls and their control sources the same to avoid confusion. In most troubleshooting cases like this, mismatched names are the culprit. If you want to discuss these things further or share screenshots, the forums on my website are a superior place for back-and-forth troubleshooting than YouTube comments.
TheGreat1207 asked whether the fitness database I've been building will be available as a free template and how to obtain a copy. Members can download the databases I build in my TechHelp videos. If you join as a Gold Member, you can access the fitness database and other perks. The current cost is $9.99 per month. That said, a great way to learn is to build the database yourself while watching the videos. However, some learners do prefer to take apart my finished files, which is also a good way to learn.
Another viewer, BungMe4164, paid me a compliment about the clarity of the videos. I appreciate the positive feedback and take pride in producing helpful tutorials.
GoneFishin2006 commented on my video about the Access space I used to run on Quora, which was deleted without warning. While some people disregard Quora, I used to enjoy reading a variety of topics there. However, after their decision to remove my Access community there, I have moved on from the platform.
Nature-Retreating requested advice on whether to use Excel or Access for setting up a student database for a small organization. I have a dedicated video on this topic, and the choice really depends on your needs and the size of your organization. For a small school with a limited number of students and classes, Excel might be sufficient. Start with Excel to track your data, which can help you determine what tables and fields you need if you decide to move to Access in the future. Access is especially powerful when you need to relate different sets of information, like linking student records to billing or course enrollment. But for a small project, Excel is an easy way to begin, and you can transition to Access later if your needs expand.
A common question I get is from members who have trouble viewing YouTube members-only videos if they signed up on my website. These are two separate membership systems. If you join on YouTube, you can view members-only content on YouTube and, after emailing me, also get access on my site. If you sign up directly on my website, I cannot give you access to YouTube member content, as I do not control YouTube's membership system. In that case, you simply view extended cut videos and other content on my website.
Collins asked about access to exercise files, and I can confirm that all materials for Access Beginner 1 are completely free and available on my website, including databases, handbooks, and video files. I make this course free so that you can try it out before deciding to purchase more.
Adrian had a question about course access after payment, specifically regarding VBA courses. If you join as a Learning Connection member, where you receive a new class at the interval of your choosing with a discount, you keep those classes forever. If you join the My Online Learning Membership, which allows you to access everything as long as you're a member, access is limited to your membership period. If you purchase an individual course outright, it is yours permanently with no time limit, and you can even watch offline.
O'Cott from Uganda requested more videos on macros rather than VBA, since VBA can be challenging. Personally, I find VBA easier to work with and more flexible than macros. The macro editor can be cumbersome, requiring more clicking and dragging, while VBA achieves most tasks with just a few lines of code. That said, for those who prefer macros, I have six Advanced lessons available on my website that focus on macros. These are positioned between the Expert Series and the Developer Series. If there's enough demand, I may consider creating more macro content, but for now, my main focus will remain on VBA, as it is generally more efficient for most tasks in Access.
Before I go, I want to thank everyone for your questions and participation. Even though I promised a short video, these Quick Queries sessions tend to grow as I try to answer as many questions as I can. It's always enjoyable to help out and share knowledge, but now I need to go and rest up a bit more.
That wraps up today's Quick Queries. Remember, the complete video tutorial with step-by-step instructions on everything discussed here is available on my website at the link below. Live long and prosper, my friends.Topic List Difference between control name and field name in Access forms
Use of Me dot syntax versus Me bang syntax in VBA
Why naming form controls to match field names is recommended
Binding text boxes to fields in Access forms
How Access interprets Me dot and Me bang references
Updating form controls and fields using VBA
Troubleshooting 'variable not defined' errors in Access VBA
What happens when control and field names differ in forms
Renaming controls and its effect on VBA references
How Access defaults form control properties as object properties
Members-only YouTube video and website access differences
Handling Access membership systems for content access
Availability of free Access Beginner 1 exercise files
How to obtain Access exercise files from the website
How to keep access to purchased courses
Explanation of different AccessLearningZone membership types
Differences between Excel and Access for tracking data
How to start tracking organizational info in Excel
Macro versus VBA use in Access
Why VBA may be easier to use than macros
Events covered in Access macros such as On Current and On Double Click
When to use macros versus VBA in Access
History of macros in Access web apps (Data Access Pages)
Where to find Access macro training in Advanced Lessons |
