Discover
Computer Learning Zone
126 Episodes
Reverse
When a Microsoft Access combo box is populated by a UNION query, it can appear to work perfectly until selecting one item suddenly displays another. The usual culprit is a duplicate numeric ID coming from different tables, such as Employee ID 15 and Customer ID 15.This episode explains why AutoNumber values are unique only within their own tables, not across a combined query result. When a combo box binds to the shared number alone, Access cannot tell which source record was actually selected.Learn how a simple prefixed selector value, such as E15 and C15, prevents these ID collisions without changing the underlying tables. The discussion also covers a real example involving foods and meals, plus what to consider when VBA code needs to determine which source table the selected item belongs to.
Why can 0.1 plus 0.2 sometimes produce 0.30000000000000004? Computers are not forgetting basic arithmetic. They are working with finite binary approximations of decimal values that cannot always be represented exactly.
Test your Microsoft Access VBA fundamentals with a quick developer-level quiz on variables, duplicate record checks, DLookup, and message box responses.
Why do so many retail prices end in 9? In this episode, Richard Rost explores how to automatically adjust prices in Microsoft Access so values like $10.00 become $9.99 without increasing the original price.
Downloaded Access databases can trigger security warnings for a good reason: they may contain active content such as macros, code, or other features that should not run automatically until you trust the source. This quick beginner quiz explains what those warnings mean and why they matter.It also covers a few practical Access habits that save headaches, including extracting database files from ZIP folders, using trusted locations appropriately, creating desktop shortcuts instead of duplicate files, and not worrying about gaps in AutoNumber values.Test your Access basics and see whether you are ready to keep your database vault secure.




