More on how to merge data from recordsets and queries to Word documents. Access Archon #168 Creating Queries on-the-fly for Filtering Data If you need to send letters to customers, and want the option of filtering by any country, not just the ones with the most customers, the frmMergeToWordDocProps form (shown in Figure D) […]
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 […]
Access Archon #174 The code that does the work of listing, clearing and copying doc properties is listed below. VBA Code Private Sub cmdCopy_Click() On Error GoTo ErrorHandler Dim cbo As Access.ComboBox Dim intType As Integer Set cbo = Me![cboSelectTableOrQuery] strTemplate = Nz(Me![txtTemplate].Value) strRecordSource = Nz(cbo.Column(0)) […]
About the feature that Microsoft has to remove from Office 2007. Just what is the ‘Custom XML’ feature that Microsoft has to remove from Office 2007? The Office 2007 document formats (docx xlsx pptx etc.) are stored in XML format which looks like the HTML used in web pages. For example here’s a bit of […]
Microsoft says it’s been working on the Word 2007 patent patch for months, so why does it look like a rush job? As we’ve previously reported, Microsoft lost another round of the ‘Custom XML’ patent case and must stop selling, in the USA, Office 2007 with the offending code after 11 January 2010. According to […]