How to enable Macros in Office 2007. Q: Marge W. writes that a client called her in panic, saying that “nothing works” in the updated database she just delivered. Upon questioning, it turned out that nothing happened when buttons were clicked on the main menu, and that the client had just done a fresh install […]
How to use records selected in a recordset as the record source for the Detail section of a report. Q: Mark Jackson writes to ask if records selected in a recordset can be used as the record source for the Detail section of a report. A: I think the best way to do this would […]
How to merge data from a recordset based on a query to Word documents. Access Archon #168 Introduction An AW reader wrote to me asking if the document properties merge code in my Code Sample #24could be modified to merge data to Word from a query, instead of selections in a listbox. While the […]
Suiting Access 2007’s Navigation Pane display to your liking. Q: Gordon Rennie writes: “Now with Access 2007 the database window has disappeared and been replaced with a stupid list at the side that only shows one item per line. Is there any way to get the database window back? or is it a matter of […]
How to filter a form from a listbox selection. Q: Martin later wrote with a related question: he is getting Runtime error ’13’: Type mismatch when running the following code (which is intended to filter the current form by the double-clicked item in the listbox): Private Sub lstSamtaler_DblClick(Cancel As Integer) Dim LngID As Long […]
