Microsoft Access QueryDefs: Create Saved Queries with VBA

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 skills with an expert-level callback form quiz. The questions cover a deceptively useful detail: hiding a bound Customer ID control does not erase its value or prevent buttons and VBA from reading it. You will also revisit common callback-list issues, including clea…

Need one VBA routine to retrieve several related pieces of information, such as a customer's address, city, state, ZIP code, and country? This episode explores a clean Access VBA pattern for doing exactly that without scattering repeated DLookup code throughout your database. Using a Boolean functi…

Test your Microsoft Access form knowledge with five beginner-friendly questions about labels, bound forms, Form View, sensitive fields, and continuous forms. One key issue is what happens after you edit a record and see the pencil icon. In most bound Access forms, moving to another record commits t…