The Brileigh Blog

Document Generation using Word Content Controls

  • December 29, 2017
  • One response

This article was abandoned. I found that there were some serious bugs in using Word Content Controls and in particular the Repeating Content Control. In general terms the content of the article still holds. If the structure is either flat, or with children only at only one level below then it seems to works. The problem appears that if you […]

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 […]

Why use Access? Why not?

I have been writing Microsoft Access applications for many years, but most of that time I have felt I needed to be apologetic about using what many have considered to be a rather lame product. For a while I even started having my own doubts about Microsoft Access. When I spoke to other programmers, when they asked me what I […]

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

  • November 26, 2012
  • One response

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

  • October 25, 2012
  • 3 responses

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 […]