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
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
How to get basic system specification info from the PC. Q: Briant Manix writes: “Do you know how to get basic system specification info from the PC? I would imagine that the function would either use a Windows API or e look up in the Registry. I want to get
Q: Fred Kerr writes that code for importing data from text files that worked fine in Access 2003 doesn’t work in Access 2007. Why? A: If you are using a saved Import spec, it won’t work in Access 2007. There was a significant change in Importing/Exporting in Access 2007; import/export
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 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 enable Macros in Office 2007. Q: Marge W. writes that a client called her in panic, saying that “nothing works” in the updated database she just delivered. Upon questioning, it turned out that nothing happened when buttons were clicked on the main menu, and that the client had
Q: Sanjay Singal wants to know how to send an attachment generated from Access data in an Outlook email message. A: Access Archon #148 deals with this topic (creating and mailing attachments in an email message). In this sample database, the values of various email message fields are picked up
Q: Bradley Wellard writes: “I am still a bit of a novice and have been attempting to find some useful information on how to apply/use ActiveX controls in Access with little success. I am particularly interested in any information regarding the Microsoft ImageCombo Box control V.6. Are you aware of
Link to information about hiding the database title bar. Hiding the Database Title Bar Q: Bill Johnston wants to know if there is any way to hide the database title bar. A: I found something on the Web (I haven’t tried it). See Terry Kreft’s post on TheScripts Developer Network
Suiting Access 2007’s Navigation Pane display to your liking. Q: Gordon Rennie writes: “Now with Access 2007 the database window has disappeared and been replaced with a stupid list at the side that only shows one item per line. Is there any way to get the database window back? or
From: Bill Coan DataPrompter 2007 Add-In for Word Speeds Up Document Creation For Word 2000 to Word 2007 One of the oldest and most popular add-ins ever created for Microsoft Word has been upgraded for 2007 with a number of new productivity features designed to speed your work and improve
From: Bill Coan New freeware tool helps you unlock the data in your Microsoft Office XML files and other XML files As Microsoft Office XML files and other XML files proliferate, the amount of data stored in those files grows larger by the day. But did you realize that the
From: Microsoft Microsoft Learning launches new Microsoft Office Project 2007 Certification program to help advance project management as a profession and maximize value for its customer base of nearly 20 million Microsoft Office Project user licenses. REDMOND, Wash., Oct. 20, 2006 – The growing number and complexity of projects that
Here’s a cute utility to turn your mouse into a volume control Those clever people at Nirsoft have a nice utility to use your mouse as a volume control for your computer. Volumouse is a free utility with good configuration options. The mouse wheel becomes a volume control when you
We’ve found a screen saver that truly keeps evolving and has really wonderful graphics There are plenty of screen savers available but most don’t hold our interest after a short time and we’re back to the My Pictures screensaver in Windows (which shows a random set of images from your
Microsoft will release a ‘patent patch’ for Word 2003 and Word 2007 – but why bother? Quietly, in last hours of 2009, Microsoft released some details of an ‘end user’ patch to cover the ‘Custom XML’ patent dispute. Looking at KB article 978951 says there will be a link to
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
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
A simple fix to make PDF preview work in 64-bit Windows 7 Windows 7 has a nifty file preview pane in Explorer, available by clicking the icon on the right of the toolbar. Most common document types are supported either by Windows itself or appear when the appropriate software is
Yet again, you can take advantage of a Microsoft offer and pay more for Office 2007 than you need to. Eileen T writes “I received this offer by email and was wondering if it’s real and good value? “ The short answer is Yes and certainly NO. Here’s the offer
Microsoft loses another round in a Word patent case, an Office update is coming in the new year. A US court judgment seems to have forced Microsoft to release an update to Office 2007 in the new year. The US Federal Circuit Court of Appeals has upheld the judgment that
A little ‘mistake’ by sales staff can cost the unwary serious money plus other Win7 buying tips. We don’t normally delve into the world of Windows but a visit to some big electronics stores revealed a nice little ‘earner’ for the store and Microsoft. Lot’s of people are heeding the promotions
It’s too late for Christmas cards but not too late for a simple Xmas Email. We’re the first to admit that sending a Christmas email isn’t the most traditional method but it can be done with good cheer and grace. Here’s just one example from a friend and some tips
