I am a 2007-2012 MS Access MVP Awardee

Check my blog GPG on Access. You might find recent discussions about SharePoint and Access interesting.

Published Books

In addition to Grover Park George On Access, Two of my former colleagues at Advisicon and I collaborated on a book on Access 2010 and SharePoint, MS Access in a SharePoint World.

It's not all about billable hours

One reason I've been happy and successful as an Access/SQL Server developer is that I love the work itself. Moreover, I've found ways to give back by participating as an Administrator and contributor at  Utter Access . Partly as a result of my activities at UA, and elsewhere, MS has repeatedly awarded me as an Access MVP. If you want answers to specific problems, visit us at UA.

Been There, Done That, Sent it to Production

Another way I've tried to give back is to create demos and sample databases from time to time. Demos currently available from GPC Data are listed below. These are working databases (accdb's work with Access 2007 or 2010, mdb's with previous versions of Access), with limited features. They illustrate a particular technique or method that I've used to solve a problem, or sometimes just for fun.

I am always on the Look out for Demo ideas.

What would you like to see?  Send me your ideas, please.

If you have an idea and want to see how it would turn out in a sample mdb or accdb, let me know. I might give it a shot.

Want to Share YOUR Demo?

If you would like to share your work, Send me your demo to post, please.

I am also looking for examples of techniques you've developed, or methods you find useful. If I like the demo, I'll upload it here. I can only post accdbs or mdbs after you and I have reviewed your code and agreed on posting it, so if you don't want to share the code in your demo, this won't be a good place for it. But if you have a killer search function, or a fantastic method of importing text files, or whatever, I'd love to see it and maybe make it available here.

Additional GPC Downloads

Create a DUAL table Demo

Here's a handy way to completely hide a table. And I do mean completely....

A Hidden "System-Like" table to support UNION queries in Searching Combo Boxes

Dual tables have characteristics similar to the ORACLE DUAL table:

a) Hidden, so users are not tempted to use it for other purposes.
b) Consist of a single column and contain a single record.
c) Not editable.

You can read about the reasons for creating this demo, which you can use to create your own DUAL tables, in my blog.

Most of the code in this demo was created by my friend Banana Republic.

Random Values, Variable Number Demo

If you've ever wondered how to avoid database bloat in Access databases, you need to check this one out.

Random Selection of "N" members in each Category

This little demo grew out of a question regarding a recordset from which the user needed to RANDOMLY select three records from each category. Normally that's possible with a subquery to select the Top 3 records to match. However, in this table, there was no primary key, and therefore, no way to order the subquery records so as to get the correct results. My solution was to generate a temp table with a randomly generated unique key for each record, from which the Top 3 subquery could select the right records. For the demo, I added support for selecting ANY number "N" of records per category.

However, in order to support the constant addition and deletion of records in a temp table without bloating the main accdb, I added support for creating an on-the-fly scratch accdb into which the temp table could be placed.

Singing Cowboys Demo

Many-to-Many relationships are often confusing for newbies.

Many-to-Many in a main form/subform design.

This little demo shows ONE way to enter records in all three tables in a many-to-many relationship. It was created in response to a thread at Utter Access. The content is recordings and artists. One artist can record many songs, one song can be recorded by many artists. The use of two main form/sub form pairs allows the user to enter either songs or artists or both and slip back and forth easily between them.

Travel "Pack" Demo

One-to-Many data entry requires a main form/sub form approach.

One-to-Many in a main form/subform design.

This little demo is based on a travel scenario, where groups of people travel together, "in a pack". I did it for a poster at Utter Access. I am also including it here because it is a good illustration of the main form/sub form design required to manage one-to-many relationships in a transaction scenario. The transaction itself (the journey, or travel) is tracked in the one-side table, and the details of the transaction (the "pack members" traveling together) are tracked in the many-side table.

Tenant Billing Demo

Simple Tenant Billing Demo

Here's a demo I created for a question at Utter Access. The question had to do with billing tenants for charges pertaining to their leased properties. This simple demo shows how to track charges and payments in two different workflows, and how to calculate balance due. Of course, in my typical fashion I couldn't leave well enough alone and ended up with a fairly complex Union query for one  report. However, the basic queries are there and should be useful as guides.

Oh, this one only has an Access 2007 version. I decided to see how much of it I could build with just embedded macros. Worked out pretty well, I think.   Simple Tenant Billing Demo

Multi-Field Filter Demo

Multi-Field Filter Demo.

A recent question at Utter Access was the motivation for this one. The poster needed a way to filter records on a form, but the standard methods he'd found in MS templates didn't cover the range he needed. After a while, it became a challenge for me to make it work for a variety of situations and the result is Multi-Field Filter Demo.

I also included a second form to model the method I use to search for a record using a selecting combo box. This one if very common and there isn't anything too unique in my approach. I only included it because it IS so common and a good example seems worthwhile. Enjoy.

Previous Weekday Demo

Previous Weekday Demo.

I uploaded a new demo database, available in both Access 2003 (mdb) and Access 2007 (accdb) formats.  The demo itself is fairly simple; it takes two arguments--a start date and a weekday--and returns the date in the prior 7 days on which that weekday falls. To me, the larger significance of the demo is that:

1) it's my first demo using Access 2007, and

2) it has some simple language swapping in it to change captions on controls on the forms from one language to another (English and Español only so far).