Alternatives to printing web pages
Save paper by using OneNote, Word or other methods or saving pages for later reading.“I know it’s old fashioned but I like to print out web pages that interest me and refer to later. But now my printer is broken and while I wait for repairs I have a backlog of open browser windows and […]
Master Document Tips
Wrapping up our look at Master Documents in Word with some extra tips. We’ve been looking at Master Documents in Word and here’s some extra tips to help you get the most from this once feared Word feature that’s come good … · Feature like Page number, Header and Footer, Date and time, index […]
Master Documents without pain
Don’t be afraid – Word’s Master Documents is stable and worth using. The term ‘Master Document’ may cause many to scorn if not outright panic especially those who have been using Word 97 or 2000 version. The most common problem which people faced earlier was the corruption of master documents and the problem of not […]
Word 2007 password bug
According to Microsoft, Office passwords can be up to 255 characters, however our tests of Office 2007 found an interesting and apparently undocumented bug in Word 2007. Writing a book means delving into details and finding the unexpected – that happened as we prepared Privacy and Security in Microsoft Office. Word 2007 has a limit […]
Office 2007 ‘Custom XML’ and update FAQ
Here’s the known situation regarding an enforced change to Word 2007 and Word 2003. We’ll update this page as hard information becomes available. Microsoft isn’t exactly forthcoming about this problem so there are more questions than we’d like and even less answers. Office Watch asked a series of questions to Microsoft and they declined to […]
Placing calculated dates in a Word document
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: […]
The Office Envelope Object and Office 2000
Using the Office Envelope Object in Office 2000 – what works and what doesn’t. Some readers have asked whether the Office Envelope Object (featured in Access Archon #122) can be used in Office 2000. Well, sort of. While writing the article, I tested the two procedures in Office 2000 and found that the Word procedure […]
Reader response to “Merging to Word from Linked Access” article
Charles Hui writes: After reading your article “ACCESS Archon Column #44 – Merging to Word from Linked Access”, I have expanded my WORD template to include a table and have successfully created letters using custom doc property and table together. In our letters, the fixed Borrower Name and Address are printed at the top of […]
Merging Access Data to Word
How to successfully merge data from Access to Word. Q: Bruce Michael writes: “I have been attempting to do a merge in Word 2003 using an Access 2003 query. When I look in the query, the data is correct, but when I actually merge using the data, for one column in the database, the values […]
Merging Data from Queries and Recordsets to Word, Part 2
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) […]
Working with Word Document Properties, Part 2
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)) […]
Merging data from Queries and Recordsets to Word, Part 1
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 […]
Word 2003: Obama or Osama
A look at a few of the embarrassing glitches in Word 2003’s in-built dictionary function. How do you spell ‘Barack Obama’? Maybe it’s ‘Barrack Osama’ ? Word 2003, Vista or Windows Server 2008 might tell you that. click here for more … See Also Why is an eighth grader smarter than Microsoft Word? Spell-checker pulps […]
Working with Word Document Properties, Part 1
Access Archon #174 Introduction Many of my code samples write data from Access tables or queries to document properties in Word documents. For this technique to work, you have to add the appropriate doc properties to the Word template, which can be a time-consuming process. In this article I automate the process of creating […]
What is the ‘Custom XML’ feature in Word?
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 […]
The mystery Word patch
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 […]
