Document Generation using Word Content Controls – Back in Business
This article shows how to create a complex structured Word 2019 Document from a template using XML as a data source. I wrote this to apply to Word 2013 / 2016’s Repeating Content Controls. I abandoned this article in 2017 when I found that the results were not consistent when the structure of the XML file became more complicated, i.e. […]
Export XML Data from Microsoft Access – Part 3 – Matching a schema
Previously Export XML Data from Microsoft Access – Part 1 – Tricks and Traps Export XML Data from Microsoft Access – Part 2 – using VBA In the previous two parts of this series we found it easy to Export XML data from Microsoft Access either using the UI or VBA, but that the schema (or structure) of the output […]
Export XML Data from Microsoft Access – Part 2 – using VBA
This follows on from a previous blog Export XML Data from Microsoft Access – Tips and Tricks, about how to export XML data from Microsoft Access using the interactive tools in Access. The example used the Northwind database to export the Order information for one Customer, so that they could use this XML document for merging with Microsoft Word using […]
Export XML Data from Microsoft Access – Part 1 – Tricks and Traps
Ever since Microsoft Access 2003, Access has had the inbuilt ability to easily export data as XML, and the schema of the underlying table or query to an XSD.. Even before this it was possible to write XML from Access by using VBA to write it out as a text file, or by setting a reference to the MSXML or […]
Document Generation with Microsoft Word and Microsoft Access
Background Back in the late 80’s early 90’s I wrote some software called Rendezvous and sold it as shareware. I wrote it in Clipper (a dBase III compiler). It’s purpose was generally for lead generation and outbound telemarketing. Telemarketing using databases was relatively new at the time. For general lead processing one of the better strategies was to call the […]
Expanded MouseOver and MouseOut events
In the previous post Simple Microsoft Access MouseOver and MouseOut Events the only type of control monitored was the CommandButton. This expands on the same idea but extends this to the major form controls. It still does not handle where controls are close to each other or overlapped, as the MouseOut event will only be fired when then the mouse […]
Simple Microsoft Access MouseOver and MouseOut Custom Events
Microsoft Access supports mouse events for a number of control types. The mouse events Access supports are MouseDown, MouseUp, and MouseMove. When the mouse is moved over a control the MouseMove event is fired, not just once, but potentially for every pixel, depending on the speed of the mouse movement. There is not a specific event for when the mouse […]
Installing Windows 7 on a Solid State Drive with relocation of Users, Program Files and ProgramData folders – Part 2
It has been a couple of months since I installed Windows 7 on a relatively small but fast SSD, with the program files on a fast modest sized conventional hard drive and user data on a large average speed hard drive, which I wrote about in a previous blog. This is a review of the experience and some tweaks I […]
Installing Windows 7 on a Solid State Drive with relocation of Users, Program Files and ProgramData folders
My life as a developer is full of clutter, organised, but nonetheless clutter. I have been developing custom applications for many years and as a consequence I have written client applications which run under a variety of generations of equipment, operating system versions etc. Unlike many developers I do not insist that my clients constantly update their equipment, and I […]