How to use Access 2007’s new “multi-valued fields” feature. Access Archon #159 Access 2007 has a new feature for fields: one field can now hold multiple values. This feature is called “multi-valued fields,” and is implemented by creating a field with the Lookup Wizard. On the first screen of the Wizard, select the I want […]
A reader responds to the AW article on the new “save to PDF” feature in Access 2007. Tom Van Dam writes: just finished reading your latest Access Watch on the new PDF feature in Office 2007. I have often wanted to save files to PDF format for storage and later reading. I came across a […]
An easy-to-use form that applies either one or two filters to data on a form. Introduction In Access Archon #129(Fancy Filters), I described a form that allowed you to filter data using seven filters and two sorts. Some readers found the complexity of this form overwhelming, so in response to their pleas, I have constructed […]
Some helpful insights about the future of DAO, and what it means for you. For several years now, there have been rumors that DAO would be dropped, so that in future only ADO could be used to work with Access data. While doing research for my new book, I even came across a Microsoft document […]
The phantom breakpoint: what causes it and how to solve the problem. Q: Don R. writes: When I click a command button to print a Word letter (this button runs VBA code to create the letter from a Word template), the code stops on a certain line, which is highlighted in yellow. What is causing […]
