Fitness 57

Global Event Handler Trick to Instantly Save and Recalculate Any Form in Microsoft Access. Fitness #57

from Computer Learning Zone News https://599cd.com/Fitness57

Changing Clocks is Still Dumb! We Must Abolish Daylight Saving Time! Nov 2025 Edition

Hey folks, Richard Rost with Computer Learning Zone. Time for my semi-annual rant about how changing the clocks is dumb. And yes, I will keep posting a new video twice a year until this dumb practice is over.

Watch the video here

Like everyone else, I spend a good chunk of time twice a year running around my house changing clocks. My computer, my phone, my Alexa devices, my smartwatch, they've all got it figured out. But everything else, forget it. I've got the digital clock in the bedroom, one in the garage, the car clock that requires an engineering degree, the stove, the microwave, the coffee maker, the wall clock, the oven timer, the air fryer, the old VCR that I keep around just so I can be mad at it. Every single one needs manual intervention.

It's like a time-themed scavenger hunt that I never signed up for. I'm half expecting to find one hiding in the freezer. Why am I doing this twice a year?

Now here in Florida, we get a special spin on the madness. A few years back, our state proudly passed the so-called Sunshine Protection Act to keep daylight saving time year-round. Everyone cheered, we patted ourselves on the back and then nothing happened. Because surprise, we actually need federal approval before we can stop pretending it's 1918.

So we're all down here in the Sunshine State, ready to stop changing clocks, just waiting on Congress to remember that we exist. And here's the kicker, even President Trump said he was on board with making the change. He campaigned on it. He literally called it inconvenient and costly to the nation. So we've got bipartisan agreement on something for once and still, Congress has been sleeping on the job and still getting paid.

In the shutdowns, the hearings, the grandstanding, they can't seem to get around to actual legislation that would make a difference in people's daily lives. Now I get it, there are bigger fires to put out, but come on, this one's easy. Just pick a time and stick with it. Arizona and Hawaii already figured it out. Meanwhile, the rest of us are running around like confused time travelers twice a year.

So here's my appeal to my fellow Floridians. Try saying that ten times fast - fellow Floridians. Let's do what Arizona and Hawaii already figured out decades ago. Let's just stick with standard time year-round and be done with it.

We don't need congressional approval to stop playing this twice-a-year game of guess-what-time-it-is. Instead of changing the clocks, just change what we do. For those of you who are worried that it's too dark for kids in the morning waiting for the school bus, start school a little later. If you want more daylight after work, start work earlier. If you're worried the sun's going to set before you finish the 18th hole of your second round, hit the course earlier. Problem solved. It's way easier than convincing a do-nothing Congress to amend the law from the 1960s, especially a Congress that can barely agree on what day it is.

Alright, so for those of you who didn't catch my last rant, here's a quick recap. Changing clocks is bad for your health, bad for your schedule, bad for your software, and bad for your sanity. Your taxes go up, productivity goes down, and somewhere a poor IT guy is patching another database because timestamps don't match. We've got smart lights that can sense sunrise, but we're still acting like we're saving whale oil for the war effort.

Honestly, if we're going to keep doing this, we might just as well randomly change the calendar too. Let's move lunch to 3 a.m. and call Thursday New Monday. Embrace the chaos.

And now it's time for me to share a few of my favorite memes that people have submitted to me since the last video. This one's from Platinum Member Donald Blackwell. Love a good Star Trek meme. This one's from YouTube Member Fitz027. This one's from Gold Member Anna Blakely. If you've got a good meme you want to send to me, post it in the comments, email it to me, post it on the website, maybe it'll be included in the next video.

Alright, for those of you who haven't seen it yet, here's the rest of my previous video, and yes, I'm going to keep adding to this every year until something actually changes.

Hey folks, it's Richard Rost with Computer Learning Zone. It's that time of the year again. It's my semi-annual rant about how changing clocks is dumb. And I used to complain about daylight saving time, but it's not just daylight saving time. If you want to keep extra sunlight hours in the summer, that's fine. I don't care. Just leave the clocks alone. Stop messing with them.

And while we're at it, hey, President Trump, this one's for you. You've been signing all kinds of executive actions. Why not take a shot at this? I know it technically requires an act of Congress, but you renamed the Gulf of Mexico, so why not push this through and see what happens? Why wait for Congress? The great state of Florida, of which your residence has already voted to get rid of this dumb stuff. And you expressed support for eliminating it during your campaign. You called it inconvenient and, quote, very costly to the nation, unquote. You said the Republican Party would use its best efforts to eliminate daylight saving time. So let's get this done. Make it happen. Or as Picard would say, make it so.

Alright, for the rest of you, here's the rest of my previous video. So you get all the history and all the good stuff about daylight saving time and why it's so dumb. And yes, I said savings again. It's a habit.

Hey folks, Richard Rost from Computer Learning Zone. I know you just had to watch this video back in November, but I'm going to keep posting it until our lawmakers finally get rid of this stupid practice of changing clocks twice a year. It's dumb. And clearly, I'm not the only person who feels this way. Look at these people. This guy is so angry, his legs fell off his body. And this guy brought his cello to the party. So yeah, it's not just me.

Hey folks, this is Richard Rost with Computer Learning Zone. I want to just take a minute to say that we should abolish daylight saving time once and forever. It's dumb. It's time to stop changing the clocks twice a year. DST is dumb. It causes problems with both people and computers, and we're going to talk about that in just a minute. And it's time to get rid of it.

So daylight saving time was originally introduced in Germany and Austria in 1908 to conserve energy during the war. In the United States, we had the Uniform Time Act of 1966. That's what gave us daylight saving time. And it's daylight saving time, not savings time. I know I catch myself saying it wrong from time to time as well. And that's how dumb daylight saving time is.

And of course, it's a big myth that it was to help the farmers with their crops when actually the agricultural industry lobbied against DST. They hate it. No, that's a big myth.

Now Arizona, which we'll talk about in a minute, and Hawaii passed state laws to exempt themselves from DST. So they're on standard time year-round. Twenty-nine other states, including where I live in Florida, have passed state laws to make DST permanent. However, and this is why it's stupid, since doing anything other than exempting yourself from DST goes against that law we talked about. It requires congressional approval because it's interstate commerce and blah, blah, blah.

So we could exempt ourselves in Florida from DST, which means we'd be on standard time all year round, but we don't want that. They want to make DST permanent, so that requires congressional approval. The whole thing is dumb.

And let's talk about some more craziness inside of Arizona. You've got this mess. Arizona is exempt from DST. However, inside Arizona, you've got the Navajo Nation, which does observe DST. But then inside the Navajo Nation is the Hopi Nation, which does not observe DST. So yeah, it's crazy.

Now the Sunshine Protection Act, introduced by two Floridians, Senator Marco Rubio and Rep. Vern Buchanan, was aimed at making DST permanent and it's been introduced in Congress multiple times. It's passed in the Senate, but it's not passed in the House. So the House members need to get their butts moving. And no, those pictures in no way represent my feelings toward Congress.

Now, in addition to being a nuisance, DST has been shown to have many negative effects on humans. It can disrupt sleep patterns, mood, alertness, appetite. It messes with your circadian rhythm. Even this morning I woke up and it was seven o'clock and of course my body still thinks it's eight o'clock. You can trigger mental illnesses like bipolar disorder and seasonal affective disorder. I had that really bad when I lived up in New York, because it was dark all the time. And of course, those things are all indicators for elevated risks for cardiovascular diseases, injuries, and immune-related diseases. These are all from scientific papers, not just my opinion. You want some references? Google it.

Now of course this is Computer Learning Zone. So DST has also been shown to have many negative effects on technology, which is my emphasis. Switching clocks is dumb. It causes time synchronization issues, scheduled task disruptions, logging and auditing challenges. For example, time clocks with shifts that span the DST switchover. Sure, Windows itself can handle the change, but does your software calculate those differences properly? If your shift starts at midnight and ends at 8 a.m., is your time clock software properly programmed to notice that daylight saving time kicked in? I've done lots of software fixes for people that had databases or spreadsheets where that wasn't the case.

In fact, I remember back in 2011 when the iPhone had a huge glitch and everyone was complaining about it. Its clock fell back an hour instead of springing forward during the DST transition, and lots and lots of people had problems waking up that morning. But of course, it's an iPhone. So what do you expect? Android forever.

Anyway, if you've got Excel spreadsheets that track time clock data, the best way to do that is to use UTC or universal time. Basically, Greenwich Mean Time. Store that in your spreadsheets. I just did a video on this a couple of days ago. I'll put a link down below if you want to watch it.

Same thing for Microsoft Access, which is my forte. If you've got a database where you're keeping track of your time clocks or any other kind of scheduling and calculating the number of hours between clock-in and clock-out is important, make sure you're using UTC time. Here's a video on that. And yes, you can hear me complain about DST some more in these videos.

And of course, I shouldn't even have to tell you how much of a pain it is to run around changing the stove, the microwave, the wall clocks, the clock in the car. It's just easier for me just a couple of months out of the year to know that my clock is wrong than to change it everywhere. Remember the VCR. I hate it. I still have to do it today.

Today, DST just - wait, we just went to standard time today. We fell back. So I'm not looking forward to it. I've got like six clocks I have to change. The pain, twice a year.

Alright, so instead of me just complaining about it, what am I going to do? Well, I'm going to write my congressman and I'm going to encourage as many other people as I can to write your congressman as well. There is the link. You can just Google 'write to my congressman' and you'll find house.gov.

I'll put a link to this down below as well. You can just click on it. You type in your zip code. There's my rep, Byron Donalds. And right down here, you can find a link to email them. See that little link right there? Click on that. You type in your zip code right here. Don't worry about the plus four. Hit submit. Or there are links up here if you'd rather Facebook them. I hate Facebook. Facebook them. Tweet them. And yes, I'm going to call it tweeting. It's not Xing or whatever they're trying to do nowadays. Or there's a YouTube channel on some of them. Different congressmen have different ways to contact them. I'm going to email mine.

And what do you say to them? Well, I wrote a letter. There it is. I'll put a copy of that down below too. You can find it at this page right here. DST is dumb. Feel free to copy and paste if you want. Put your congressman's name up here, your information down there and send it.

So if you're like me and you hate daylight saving time, here's something we can at least try to do. I don't know if they actually read these or not or if it has any effect or whatever, but I'm going to at least try instead of just complaining.

Alright, now I can check this off my list. This is my Rick's Life missions checklist. I'm going to convert the world to ISO dates. I've already done several videos on this. This is the proper date format - year, month, day. It's confusing when people around the world use it differently, and it causes software problems too.

I've done a lot of videos on this. If you're sharing a spreadsheet with someone who's in, let's say, England and they're doing day, month, year, which is more logical than the way we do it here in the US. No, this is the way everyone should write dates. I've been putting it on my checks this way for years. And yes, I occasionally still write checks. I'm old.

Alright. Mission two, abolish daylight saving time. I complain about it every year. Time to do something about it. This one I don't see happening in my lifetime. Or this one, get everyone to use the metric system. Come on. Pounds, inches, dumb. And yes, I think we should switch to a 28-day calendar. It makes more sense. January 1st is always a Monday. You'll need 13 months of 28 days each, each month is the same number of days. Shift the month names so that October is actually the eighth month. Shift all the rest of them over. Then we've got to add a 13th month. What do we call it? I don't know. Call it Rickember. I don't know.

Then you take New Year's Day. Make it a holiday. You can either add it as the 29th day of the last month or whatever you want to do. Or make it outside of the calendar. Make it a party day. And then your leap day is election day every four years and give everybody off so they can go vote or do online voting, which we should do, which I don't know why we don't.

Alright. So there we go. That's my annual tirade on abolishing daylight saving time. It's dumb. Go write your congressman. Tell them I sent you. Point them to my video. Spread the word. Share this. Let's get rid of daylight saving time forever. And yes, I know I just said savings time. That's how dumb it is. OK, bye.

The Plumber, the Programmer, and the Piano Hands

Sometimes the question isn't whether you can do something, it's whether you should. As a developer, I know I can build just about any software I need if I throw enough time at it. The real question is: how much time is it going to take, and is that time worth it? Sometimes it makes more sense to just buy something off the shelf and move on with your life.

Case in point: a little while ago I bought some color-changing LED lights for the outside of my house. I wanted to be able to dim them, and maybe set orange for Halloween or red and green for Christmas. Simple idea. I've got eight white lights out there, so I thought, no problem. I got out the ladder, climbed up, and did the first one. And that's when I realized it was a big pain in the ass. To do seven more of them would take me all day. Not to mention I only have vision in one eye, so I'm not exactly comfortable up on a ladder. My balance isn't great, and I'd prefer not to break a hip in the name of festive lighting. I love holiday spirit, but not enough to spend it in a neck brace. I already had cuts and scrapes on my hands from the sharp aluminum under the soffit where the lights were mounted after doing just one. That's when I decided to call in help. Sure, I could do it myself, but my time (and my delicate piano hands) are worth more than that. (1)

It's the same with plumbing. I can fix a simple clog or swap out a faucet, but if the problem is something deep in the pipes, I'm calling a plumber. Could I take apart the toilet, figure it out, and fix it myself? Probably. But it would take me the entire day, and honestly, I don't care enough about plumbing to want that skill in my toolbox. If a plumber can show up and fix it in twenty minutes for a hundred bucks, that's money well spent. When I was younger and broke, I had more time than money, so I'd tackle those jobs myself. Now my time is worth more, and I'd rather spend it doing something productive or enjoyable instead of learning how to snake a drain. Besides, once you've seen what comes out of those pipes, you can't unsee it. Also, I wouldn't want to accidentally scar my wife for life if she catches sight of my plumber butt.

This same logic applies to software. Just because you can build something doesn't always mean you should. I've seen plenty of business owners start out wanting to build their own Microsoft Access database. And that's great - if you want to learn it, if building databases excites you, if you enjoy the challenge, then by all means go for it. That's why I teach this stuff. But there comes a point when some people realize they'd rather spend their time running their business than writing VBA code and fixing bugs. That's when it might make sense to hire someone from my Developer Network to help.

Even then, though, I always encourage people to learn the fundamentals. Understand how tables, queries, and relationships work. Maybe dabble a bit in VBA. That way, if something goes wrong, you're not dead in the water. You'll also be able to talk to your developer in their language. Instead of saying, "I want a screen that shows stuff," you can say, "I need a cross-tab query that summarizes sales by month." That makes everyone's life easier.

Businessman Sy Syms once said, "An educated consumer is our best customer." The same applies here - an educated Access user is a developer's best client. If you know the basics, you'll get better results and you'll appreciate the work that goes into it. The same principle holds true in any field. If you're talking to a lawyer, it helps if you understand a few legal terms. If you're dealing with an electrician, it helps to know what a breaker is. And if you're dealing with a developer, it helps if you understand Access.

In business, it's always about time versus money. When you're just starting out, you usually do everything yourself. You handle your own bookkeeping, run payroll in Excel, answer every customer email, design your own marketing materials, and maybe even manage your own inventory. That makes sense when you're small and cash is tight. But as your business grows, your time becomes more valuable. Eventually, you realize it's worth paying for a service like Paychex, hiring an accountant, outsourcing customer service, or bringing in a marketing agency so you can focus on running and expanding your business instead of juggling all the little pieces yourself.

When I first started 599CD, I used to literally make my own CDs by hand. I burned them one by one, printed the labels, slipped them into envelopes, and drove them to the post office. It was time-consuming, but I was young, broke, and excited to be doing it. That was the scrappy startup phase. As things grew, I eventually realized it was worth outsourcing duplication and fulfillment to a professional service. Sure, I could still do it myself, but that time was better spent creating new lessons instead of standing in line at the post office. (2)

I used to build my own computers back in the 90s. It made perfect sense then. You could save a few hundred bucks by buying all the components yourself and assembling the machine piece by piece. When a good computer cost around $2000, that savings really mattered. Plus, there was some pride in booting up a system you built with your own hands. But times have changed. These days, buying a computer is like buying a toaster. Even I don't bother building them anymore. I just pick up a laptop and get to work. The only people who still build their own machines are gamers or hardcore enthusiasts who genuinely enjoy tweaking every little nook and cranny of what's inside the case. And that's great, because they're doing it for the passion, not just the savings. For me, hardware was never the fun part. I've always been more interested in what makes the thing tick once it's running. Plus building computers, once again, can be rough on the piano hands. So many sharp edges inside those cases.

In fitness, it's the same story. When I first decided to get serious about health back in my 30s, I was young and broke, and the idea of paying a personal trainer was laughable. I also hated going to the gym. I've never liked working out around other people, so I built my own home gym in the garage and did everything myself. This was before the internet was packed with fitness influencers, so I hit the bookstores instead. I read every book and magazine I could find on nutrition, weight training, and metabolism. I studied how the body works and how to eat properly. It took a lot of time, but it paid off. I built the knowledge from the ground up, and that was a valuable skill to learn.

The fact that I let myself go in my 40s wasn't because I didn't know better - it was because I moved to Florida and got lazy. Now that I'm back on track, I'm applying all that knowledge again. The difference today is that there's so much information online, and you have to be careful about what you follow. There are legitimate experts out there, but there's also a lot of nonsense. So before you let someone tell you that seed oils are evil or diet soda is toxic, check their credentials. Nutrition science is clear: seed oils aren't going to kill you, fats don't automatically make you fat, and the secret to weight loss isn't magic - it's calories. Measure your intake, move your body, eat real food, and stay consistent. It's not rocket surgery.

And if you don't want to spend months (years!) learning all that yourself, that's fine too. You can hire a personal trainer to teach you how to lift properly and a registered nutritionist to set up a plan for you. Just make sure they're actually qualified and not just someone who looks good in gym selfies. Whether you do it yourself or pay for expert guidance, the key is finding what works for you and actually sticking with it.

Philosophically, it's about deciding which skills you actually want to learn and which ones you're fine letting someone else handle. But there are some things you should never outsource, and thinking is one of them. You can hire someone to fix your plumbing, build your software, or run your payroll, but you can't delegate your worldview. Too many people just download their beliefs like a piece of off-the-shelf software and never question where it came from. Whether it's politics, religion, or whatever's trending on social media, it's easy to let someone else do the thinking for you. Don't just scroll to the end of the software agreement and click "I agree."

That doesn't mean you should ignore the experts, though. Quite the opposite. Trusting experts isn't blind faith - it's recognizing that they've spent their lives studying things you haven't. My electrician understands wiring better than I ever will, and my plumber knows how to fix things I'd probably just break worse. The same goes for virologists, immunologists, and astronomers. You could spend twenty years learning all of that yourself, or you could rely on the people who already have. The difference between science and dogma is that scientists constantly challenge each other. They don't protect bad ideas - they tear them apart. Believe me, I've seen that same instinct in Access developers. If one of us posts bad code or a wrong tutorial online, the rest of us are quick to call it out. Experts love catching other experts being wrong. That's how progress happens. You've seen me critique other bad articles, websites, and videos before.

So yes, build your own worldview, but use good tools and solid data while you do it. You don't have to reinvent the wheel every time, but you should at least understand how it turns. Think for yourself, question what you hear, but don't assume every expert is part of some grand conspiracy. Most of them are just people like me - nerds who care deeply about getting it right.

I still like hands-on projects when they're fun or I'll learn something from them. I installed a ceiling lifter in my garage - took me forever, but it was a good challenge. Would I do it again? No way. I'd hire it out. Same with assembling my home gym. It's all about whether I consider it work or play. If I enjoy it, I'll do it. If it feels like work, I'll gladly pay someone else.

Even in Star Trek, the same principle applies. In the Next Generation episode Booby Trap, Geordi La Forge nearly burns himself out trying to free the Enterprise from an energy-draining snare. He's brilliant, and given enough time he probably could solve the problem, but instead he does something smarter: he creates a holographic version of Dr. Leah Brahms, the engineer who originally designed the ship's engines. With her help, they find the solution together. Geordi could have kept struggling on his own for days - or years - and maybe never found the answer. The point is, even the best engineers know when to call in an expert. You don't always have to prove you can do it yourself. (3)

Sometimes the smartest thing you can build isn't software or hardware - it's free time. In the end, that's the only currency we really have that's worth anything.

LLAP
RR

(1) Side note: don't call an electrician for something a handyman can do. I probably paid three times as much because I didn't think that through. Lesson learned.

(2) I am so happy that everyone can stream video online now. Because shipping those CDs was a major pain and a huge time waste. And even after I was able to outsource it to a company that did that for me, you still got to deal with returns and broken disks, and it was just a nightmare.

(3) And yes, before anyone points it out, when the real Dr. Leah Brahms shows up later, she's understandably not thrilled to find out Geordi built a holographic version of her and spent a little too much time with it. Let's just say that episode didn't age well in today's HR environment.

Quick Queries #64

What's Coming to Microsoft Access in 2026 - The Status of Future Updates - Quick Queries #64

from Computer Learning Zone News https://599cd.com/QQ64

Fitness 56

Add Color-Coded Goal Indicators to Forms in Microsoft Access - Fitness #56

from Computer Learning Zone News https://599cd.com/Fitness56

Fitness 55

How to Save and Load User Settings in Microsoft Access - Fitness #55

from Computer Learning Zone News https://599cd.com/Fitness55

Scroll Wheel Rich Text

Why Your Scroll Wheel Doesn't Work in a Rich Text Box in Microsoft Access

from Computer Learning Zone News https://599cd.com/ScrollWheelRichText