Zero Day’ problem for Word 2002 users
Information on an unpatched security glitch in Word 2002 (Office XP). Microsoft has disclosed a unpatched security glitch in Word 2002 (Office XP) only,click here for more …
Latest Posts
Articles written by this author
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
Comparison of Access, SQL Server, Visual Studio, and the .NET Framework
A great overview and comparison of Access, SQL Server, Visual Studio and the .NET Framework. From time to time I get a message from a client asking whether they should upgrade from Access to SQL Server, usually after seeing some presentation or ad for SQL Server. Sometimes this is appropriate
Updating Word header and footer fields in documents created from Access Merge
In response to my tip on Updating Word fields in Documents Created from Access Merge in AW 9.11, Peter writes: Note there is a significant issue in the section mentioned above. The code shown does _not_ update fields in headers or footers. Word doesn’t make it easy to work with
Doing Calculations on a Form and Storing the Results
How to do calculations on a form and store the results. Q: Rob Stoker writes: I have a table called “tblPartHistory” where I store the quantity of parts used in the field “quantity”. When I enter the quantity used into the form I want it to subtract the amount used
Mass Emailing of Report Links, Part 1
Access Archon #170 Introduction Several earlier Access Archon articles have dealt with various aspects of mass emailings. In Access Archon #106 I described how to send mass emailings from an Access table, in Access Archon #135 I described how to send reports as attachments for a mass emailing, and in
Office 2007 plus petrol
Microsoft Australia is trying to lure Aussies to buy Office 2007 with petrol. Down in Australia you can buy Office 2007 and get money back for petrol see Office 2007 plus petrol
Microsoft’s support for ODF files – don’t hold your breath
Microsoft may have announced support for the ODF document format, but it’s still a long way off. Microsoft has announced support for the ODF document format in Microsoft Office. But don’t get too excited about it, it’s a long time coming. click here for more …
Removing attachments from your saved messages in Outlook
Here’s how to trim down your Outlook storage by removing attachments from messsages, without deleting the message itself. click here for more …
Changing back end database structure
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
Editing Value Lists in Access 2007
How to edit Value Lists in Access 2007. Access Archon #169 In Access versions through 2003, if you selected Value List as the row source type for a listbox or combo box, you had to type in the list values as a semicolon-separated list, which is a tedious chore for
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
Preventing duplicate data entry
How to prevent duplicate data entry in different records. Q: Nigel Heremaia wants to prevent users from entering the same data in the FirstName and LastName fields in different records. He is using this code, but it isn’t working: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim FirstName Dim LastName Dim
Using ActiveX Controls in Access
Q: Bradley Welland writes to ask if there is any information available on using ActiveX controls in Access. A: This continues to be a sore point, even in Office 2007. ActiveX controls (other than the few native ones) can’t be depended on to work the same in Access as in
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
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
Retrieving basic PC information
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
Changes In Import/Export specifications in Access 2007
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
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
Retrieving records from a recordset
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
Enabling Macros
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
Sending Outlook Attachments
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
ActiveX Controls and Access
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
Hiding the Database Title Bar
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