Microsoft Access QueryDefs: Create Saved Queries with VBA

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…

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.

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…

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…