Wednesday, February 18, 2009

Searching All Tables In A Database


Recently I was asked to produce a general "search all the tables in the database for a text string solution". This sent me scurrying back to an article that I wrote for a visual basic magazine in the 90's. I modified this for Access and wrote an article on the topic.

Sunday, February 15, 2009

Creating Charts/Graphs in an Access 2007 Database


When I first started with Microsoft Access back in 1995, I focused on writing a data mining tool using Microsoft Graph. That tool of mine still sells a few copies today and it still works in almost the same way in Access 2007 as it did in Access 2. Now whilst I did my upgrade about a year and a half ago, I never actually developed any custom charts for clients. Therefore, it was surprising to me when a client asked me about charts that I found it was very hard to find out anything about this charting tool in Access 2007. So here is my story on Access 2007 Graphs