Video Rewind
By Richard Rost
15 months ago
Video Rewind for September 2024
NOTE: I switch up the format a little. This month reviews AUGUST'S videos. We're not missing one. :)
It's time for another Video Rewind, which is a quick recap of all the videos I released last month.
If you are interested in any of the topics listed, visit the News Feed page or use the Search box.
Keywords
#shorts, #windows, #mswindows, #msaccess, #msexcel, microsoft windows, access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #videorewind, #powershell, #vbnet
Subscribe to Video Rewind
Get notifications when this page is updated
Transcript
This is a quick recap of my videos released in August. To watch any of the videos mentioned, just visit my website at computerlearningzone.com.
Yes, I'm switching formats. The September video rewind, as it's labeled September, is going to rewind and review August's videos. I used to do the August one at the end of August or the beginning of September, and everyone got confused. I'm just switching it now. If you see September, this is August's videos.
At the beginning of August, we finished up our big button form series where you can make big buttons on a form and use those instead of picking from a combo box. This is great if you're using tablets and such.
We did a video on accidental clicks. You know how it is when you've got a button, and people accidentally double-click the button instead of just clicking once, and then it prints the report twice. We'll talk about how to deal with that one.
Office Watch released a new article about how the new Microsoft Outlook is not quite ready for prime time yet, so stay away from it. Use classic Outlook. We learned how to use Enter instead of the Tab key to move to the next record in a continuous form.
I did another series on sending email, this time with CDO or Collaborative Data Objects. It's how to send emails from Access without having to use an email program like Outlook. You can send directly to an SMPP server, something like Gmail or whatever. I also did a follow-up on how to send email just with PowerShell. So that's pretty cool, too. There are lots of options.
I learned a new trick, well it's new to me, about how the Mid function can actually double as the Right function under certain circumstances. This blew my mind. I showed you how to load multiple images at the same time for a record. Let's say you've got a product and you want to load 15 images for that product. Right. We'll do that in this video.
I talked about splitting numbers into pairs. This is useful if you're using speech recognition and you want the computer to say a year, for example, like 1972. So we break it up into pairs. It'll say "19" and then "72" or "2024." Otherwise, it might say "2024." Sometimes it does and sometimes it doesn't, depending on what you're using.
I released Quick Queries 19. If you're not familiar with my Quick Query series, it's basically where I take all the questions that were sent to me over the past month or so, and we just, you know, rapid-fire go through them. Stuff that doesn't necessarily need a whole video on its own. So I've got a bunch of cool stuff we talk about in this one.
In this video, I show you how to filter a list of records based on a date of birth. Usually, you see this in doctors' offices when you go to the doctor's office and they say, "Hey, what's your date of birth?" You give them the date of birth, and then they can very easily pull you up from a short list of customers because probably not a lot of other customers will have the same date of birth. I use date of birth, but you can use anything you want. You can use phone numbers or whatever other number you get from your customers if you want to shorten that list.
I put together a video for my website that explains all the different types of memberships and what their different perks are and what they involve. Most of the emails that I get from people are like, "Well, I want to be a Silver member, but I also like the Learning Connection. What's right for me? What perks do I get?" So if you're a member or you're thinking about becoming a member, check this video out.
If you're interested in learning PowerShell, one of my colleagues Alex has been putting together some PowerShell tutorials. Here's one of them on using credentials. Check that out.
And that's about it. That's going to do it. That's your recap for the videos I released in August. Again, to watch any of these videos, just visit my website at computerlearningzone.com or the short address is 599cd.com. Long story. I've got a whole page on it if you're curious.
And as always, live long and prosper, my friends. I'll see you next month for September's recap.
|
