Computer Learning Zone

✓

Nõue

VB, VBA, VB.NET, VBScript, and VB6 share a family resemblance, but they are not interchangeable. The key question is not which version sounds newest, but where the code runs and which objects, libraries, and runtime it depends on. For Microsoft Access developers, the answer is VBA, or Visual Basic …

Can Microsoft Access hide password characters typed into a standard InputBox? This quick quiz explores why the built-in InputBox cannot display asterisks and why a custom form with a password-masked text box is the better choice when users need a more polished password prompt. Along the way, it cov…

Learn how Microsoft Access QueryDefs let VBA create and save queries dynamically instead of forcing you to maintain a separate query for every possible field combination.

Test your Microsoft Access report skills with a beginner-friendly quiz on customer directories, report layouts, print preview, and mailing labels.

When VBA adds a new record in Microsoft Access, you often need the AutoNumber ID immediately afterward. That ID lets you open the exact order, customer, or log entry your code created instead of guessing based on the highest number or the newest-looking row. In this episode, Richard explains why re…

Richard Rost shares his eight-month experience trying to use Tiller as a bridge between financial accounts, Excel, and a Microsoft Access database. The goal was simple: reduce the daily time spent checking balances and recent transactions across multiple accounts. Instead, the workflow required rep…

What happens when fraud prevention is so strict that legitimate customers cannot complete a purchase? Richard shares his frustrating attempt to buy concert tickets, complete with valid credit cards, matching billing details, repeated authorization holds, and front-row seats that disappeared while t…

The Expression Builder can look intimidating at first, especially when Access presents a long list of functions, fields, operators, and database objects. This episode explains what an expression is, what the Builder is designed to do, and when it is helpful to use instead of typing everything by ha…

Test your Microsoft Access form and macro knowledge with five advanced questions about preventing edits to paid orders while keeping the rest of the order form usable.