You are here: Home » Archives for Tim Critchley

Text Data Sources in MS Access (part 2)

calendar date June 12, 2007 by · 3 Comments comment link

Judging a file by its cover

In the opening episode of this discussion, I suggested that many developers may be wary of flat files performing the role of data source for their system. From personal experience, I'd attribute the bulk of that sentiment to the fact that however reliable their source, text files are akin to the box of proverbial chocolates – and unless the dancing part of your system takes full responsibility for evaluating their content, your project will likely wind up in another shade of proverbial brown.

Continue Reading: Text Data Sources in MS Access (part 2) »

categories Filed Under: Access, Office (All) · tags Tagged With: ,

Text Data Sources in MS Access (part 1)

calendar date April 24, 2007 by · 1 Comment comment link

Introduction

In the first of a series of discussions, I'd like to share some of my recent experiences of interrogating flat text files. In an age where data management is a zen-like discipline, the prospect of having to work with file data-sources can create a distinct sense of unease within many professional developers.

Continue Reading: Text Data Sources in MS Access (part 1) »

categories Filed Under: Access, Office (All) · tags Tagged With:

Control Arrays in VBA

calendar date February 26, 2007 by · Leave a Comment comment link

Introduction:

Programmers accustomed to Visual Studio, can find themselves frustrated by the absence of control arrays when working in the Microsoft Office programming environment. Experienced VBA developers too are frequently exasperated by the need to create an event procedure for each member of a group of identical controls, when logic suggests that just one generic procedure could be shared by the group.

Althoughthe fact that MS Office does not support true control arrays remains, a technique does exist which harnesses this functionality advantage.

Continue Reading: Control Arrays in VBA »

categories Filed Under: Office (All) · tags Tagged With: