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 […]
A reader suggests an alternative method to referencing a subform control. Q: Bob Massey writes to comment on my answer to Noni Nabong’s question in AW 9.03, where I gave the syntax for referencing a subform control. He suggests an alternate method, as follows: I have mostly (99% of the time) resorted to MS Access’ […]
How to create a simple Add-to Combo Box. Access archon #161 Introduction Back when my Access Archon column appeared in Office Watch (around 1998), and there were no code samples, in Access Archon #7 and #8 I described how to create add-to combo boxes that let users enter new list items on-the-fly. In this […]
Access Archon #164 The final (and most complex) procedure is the cmdWordLetters Click event procedure, which creates a new Word document from a hard-coded template for each selected contact; when it is done, the documents are open for inspection. Private Sub cmdWordLetters_Click() On Error GoTo ErrorHandler Dim appWord As Word.Application Dim […]
