How to create a functional drop-down list control on an Access toolbar. Q: Charles Duwel wants to make a custom toolbar for an Access 2002 form, with a drop-down list control. He tried dragging a combo box to a toolbar, but it just worked like a button. Is it possible to place a functional drop-down […]
Here’s a simple procedure for exporting information from a table to an Outlook calendar. Q:Elizabeth Moeck wants to know if class name and date information stored in an Access table can be exported to an Outlook calendar A:Here is a simple procedure that does this: Dim dbs As Database Dim rst As Recordset Dim appOutlook […]
A handy solution to the problem of disappearing form view headers and footers. Q: Bob writes that in Access 2003, when he is working on a form in design view, and turns on form headers/footers (using the View Form Header/Footer menu command), often the header and/or footer section doesn’t show when he switches to form […]
How to change back end database structure. Q: Peter Matthews writes: “If you have split a data base, and then decide to change the data structure – say to add some extra information to a table – is this a problem? There does not seem to be any way of recombining the files. I am […]
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 […]