Computer Learning Zone

In this episode, we address common issues in Microsoft Access, such as why totals sometimes do not calculate in form footers and the reasons behind error messages. We discuss solutions for summing calculated fields, combining records from multiple tables using union queries, and troubleshooting differences between database behavior on different computers. Additional topics include handling file paths in VBA, managing rolling date cycles, distinguishing tables from queries, configuring Rich Text fields, and understanding the docking capabilities of forms. We also cover table-level validation rules, data macros, and answer various viewer questions related to Access database development.

Alright, it's that magical time of year again when we all pretend the Earth suddenly decided to spin faster and we have to adjust our lives accordingly. Twice a year we do this weird national ritual where millions of adults run around their houses pressing tiny buttons on appliances like we're trying to defuse a bomb in an action movie. Somewhere in my house right now there's a clock blinking 12:00 that's been doing that since the Clinton administration, and honestly I'm starting to respect its resistance to the system.

I like to imagine how this would work in Star Trek. You'd hear Captain Picard on the bridge saying, "Computer, shift the entire Federation ahead by one hour," and Geordi would be in engineering yelling, "Captain, half the warp cores just desynchronized and the Vulcans are very annoyed." Even Rush warned us about this kind of nonsense. Time Stand Still. That was the advice. Just pick a time and leave it there. But no, we've decided as a society that twice a year we're all going to play temporal hopscotch for absolutely no good reason.

Anyway, for those of you who've been watching these over the years, you know my tradition. Every spring and every fall I record a new intro complaining about daylight saving time, then I tack it onto the front of the previous video so the rant gets longer and longer like some kind of chronological Russian nesting doll of irritation. So if you've never seen this before, welcome aboard. And if you have, congratulations, you're about to watch the extended director's cut of "Richard Complains About Time."

In this episode, we discuss how to use the MkDir command in Microsoft Access with VBA to automatically create folders for each customer, allowing invoice PDFs to be organized by customer rather than stored in a single directory. I show how to add VBA code that will generate the necessary folder structure when exporting invoices, handle basic error situations like folders already existing, and structure the exported PDF files by customer. We will also briefly mention possible improvements and related topics covered in other videos, with more advanced handling reserved for the extended cut.

In this episode, we build our first queries and views in SQL Server using the graphical query designer, noting key differences from Access in sorting, filtering, and saving queries. I demonstrate how to construct, execute, and modify queries, discuss the importance of using fields intentionally, and explain the distinction between saving queries locally and as views on the server. We walk through saving a view, connecting it in Access, and how server-side filtering improves performance by reducing network traffic. We'll discuss ORDER BY in views and how server-side processing changes how data is managed and displayed in Access.

In this episode, we connect Microsoft Access to SQL Server by setting up linked tables rather than importing, so your Access front end works with live server data. I show you the step-by-step connection process, discuss choosing the right ODBC driver, explain the difference between file and machine data sources, and clarify how to handle the DateTime2 data type. You will also learn about managing DSNs, common pitfalls in setting up connections, and some best practices for naming conventions and maintaining compatibility between Access and SQL Server.

In this Quick Queries video, we discuss an Access form optimization that can speed up read-only forms by setting the Recordset Type to Snapshot. We also talk about automating billing statement emails, RAM recommendations for Access and SQL Server, setting custom database icons, combo box design for linking tables, handling VAT rates, why you should not run Access databases from Google Drive, database size and user limits, and more. I respond to viewer questions about form printing, running balances, Access and cloud storage, cancel button behavior, and Access Day event details.

In this episode, we will walk through the steps to connect to SQL Server from another machine on your network. I will show you how to configure SQL Server Express for remote connections, enable the necessary protocols and services, check your Windows Network Profile, and set up both Windows and SQL Server Authentication logins. We also discuss how to open the correct firewall ports and troubleshoot common issues if you are unable to connect. By the end, you should be able to access your SQL Server remotely from a workstation.

How can I stop one of my long processes with the keyboard? I watched your video about using a checkbox to cancel it, but it feels clunky, and most of my users are older and prefer the keyboard. Is there a way to just press the ESC key to cancel something while it's running instead of clicking a button?

See the video: https://599cd.com/EscapeKey

In this Quick Queries episode, we tackle several Microsoft Access topics, including why queries sometimes stop showing all your records due to the TOP VALUES setting and how to fix it, working with SharePoint as a backend and its common challenges, displaying multiple query results in a single report or dashboard, managing Access security with trusted locations, techniques for reusable controls, VBA debugging tips, and resolving common issues like form parameter prompts, slow combo boxes, and handling ByRef vs ByVal for form references in code.See the video here: QQ78

Let's talk about vibe coding, where developers use AI tools to generate code by describing what they want rather than writing it themselves. We'll discuss the benefits and risks of relying on AI for coding, the importance of understanding programming fundamentals, and why it's crucial not to skip the learning process, especially for business-critical applications. You'll also hear some thoughts on how AI is changing the nature of learning to code and why structured tutorials still matter in today's environment.

Learn More: 599cd.com/VibeCoding