Writing Code for Access Database

Posted by Thomas Alan Gray Oct 23, 2009

I put in a six hour day writing and revising code for a report based on a cross-tab query for a client. The usual method of creating a report on a query just didn't work, and constantly generated an error of one sort or another.

After gnashing my teeth on this for a couple of days and trying various fixes from the Internet, I finally found a method that looked like it would work. It was an "aha!" experience. The code example I found was for Access 2002 but adapted readily to Access 2003 my client is using.

Rewriting the code for my purposes, and developing new sections, took a while, but it's such a good feeling when you get it done and it works. I literally danced into the hall, then treated myself to a well-deserved scotch on the rocks (one of the benefits of working from home) and a few chapters of Slam the Big Door by favorite author John D. MacDonald.

Can't for the life of me think how to put this into a suite101 article.

Try this one instead:

Cracked, Michelle Martin Bossley, 2007