How to use conditional formatting to change the color of the highlighted record in a tabular form. Q:Ashjan Al Mahmeed wants to know how to change the color of the highlighted record in a tabular form.A:This can be done with conditional formatting (a feature added to Access in Office 2000). For each control on the […]
A reader’s having some problems after installing Access 2000 over Access 97. Q:Bob Timms wrote to say he was having problems after installing Access 2000 over Access 97. A:If you don’t need to use Access 97 any more, it is advisable to first uninstall it, then install Access 2000, but if you do need to […]
How to synchronize Access and Outlook – a more advanced lesson. Q: Jim Brooking writes that he is trying to use my Code Sample #49 for synchronizing Access and Outlook contacts, but it doesn’t do all that he wants, in particular two-way synchronizing. A: My Code Sample #49 dates from about 10 years ago, when […]
How to insert a field in a Word document that calculates dates. Q: George Forsythe writes: “I want to insert a field in a Word document that calculates Tomorrow’s date. It would be even better if I could make it Next Weekday’s date. There seems to be no intuitively obvious way to do this.” A: […]
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 […]