This shows you how to filter contacts, then merge the filtered records to Word documents. Access Archon #130 Introduction Thanks to John Lehmus for suggesting this article, which combines the fancy filtering of Access Archon #129 with the four types of merging featured in my Code Sample #24, so that
How to export contacts from an Access table to an Outlook folder. Q: Farouk Dawood has written code to export contacts from an Access table to an Outlook folder, using the CreateItem(olContactItem) syntax, but it isn’t working – the new contacts are being created in the default local Contacts folder
Here’s a brief overview of my latest book, Expert One-on-One Microsoft Access Application Development. I wrote my latest book (Expert One-on-One Microsoft Access Application Development, Wrox) for experienced Access users, who know how to create tables, queries, forms and other Access objects, and have some familiarity with writing Access VBA
How to suppress printing of a record or a control on a report. Q: Luis Pelaez is looking for a way to suppress printing of a record on a report if the Balance Due field is zero. A: If you wish to just suppress printing of one or more controls,
How to change the Overtype mode in text boxes to Insert mode. Q:John Lawrence is frustrated with the Overtype mode in Access text boxes, and wants to know if it can be changed to Insert mode. A:Yes, this can be changed in the Options dialog. Click the Keyboard tab, then
How to set column heading text for datasheets. Q: Jane H. writes that she has started using a naming convention for form controls (Helen’s comment: definitely a good idea!), but now she is seeing the control names, with prefixes, as the column headings in datasheet subforms. Is there any way
Access Archon #170 Before we finish this article a reminder that mass emailing should always comply with all local laws. More generally, you should ensure that all mailings are to people who have authorized the use of their email address for that purpose. Our purpose is to help you efficiently
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
How to ensure Access Watch isn’t mistakenly marked as spam in Outlook. Sometimes Office Watch newsletters end up in the Junk Email folder, it might seem like a conspiracy by Microsoft but it’s probably not. You can tweak the Outlook spam filter to ensure Access Watch isn’t mistakenly marked as
How to merge data from linked tables Q: Lisa Hartley writes: I’m planning to use the code in code2.zip to merge data from Access into word documents. Could you please give a couple lines of sample code which would tell me how to get data from a related table. In
How to rename files in a folder. Q: Richard Bryant writes: I have written the following code to change the name of files imported as .tif files from the county deed books for use by my Access program. Private Sub Command2_Click() Dim Path1 As String Dim Path2 As String Dim
The correct code to run when you want to add a record to a table with a value from a form. Q: Sarah Balthazor writes that she is getting an error message when trying to run the following code, intended to add a record to a table with a value
How to open a form record from a listbox selection. Q: Martin Wichmand is trying to open a form to a specific record from the DblClick event of a listbox, using the ID primary key, but he can’t make it work with the following procedure: Private Sub lstMandag_DblClick(Cancel As Integer)
How to throw up a flag if someone’s editing an existing record. Q: Julie Garret writes to ask if there is a way to throw up a flag if someone edits an existing record. A: On a bound form, you can use the form’s BeforeUpdate event for this purpose. Here
A reader wants to know where to find Functions information for more recent versions of Access. Q: Marty Nizlek writes: “In Access 97 one could easily find a summary page listing Functions alphabetically. As well, there was the ability in the Builder Wizard to select a function, then hit help,
How to make the combo box display the DistrictName value when the combo box is closed. Q: Mary V. writes: “I have a combo box that is bound to a DistrictID field, but the drop-down list shows a descriptive field, DistrictName. (The column widths are 0; 2). This works fine
A reader reported that the Office XP templates for my Time & Expense Billing application don’t work in Office 2003, so I’ve provided a new set. Dan Gifford wrote to report that the Office XP templates for my Time & Expense Billing application (Code Sample #29on my Web site) don’t
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
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
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
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
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
How to update Word fields in documents created from Access Mergee. Q: Richard Lally writes: I am very interested in trying the Mail Merge method you suggest but I am anxious about one thing. The templates include a number of fields that need updating when a document is created from
How to use Rich Text in memo fields in Access 2007. Access Archon #157 Introduction Over the years, the functionality of Access forms and reports has been significantly upgraded. In Access 2007, one long-requested feature has finally arrived in a workable form (I recall an early and unreliable implementation that
