Bad Data is Bad for Business with Pat Hartman

Please join us for our Monthly Chapter Presentation on March 2nd, at 6:30PM Pacific (UTC -8)
(Please verify your Time Zone offset.)

Pat created a database to help people to understand how and why to use the Form’s BeforeUpdate event to validate data before it can be saved to the permanent tables.

It is a great tool to learn how Access works so you can use Form and Control events as the MS Access design team intended them to be used. This can a difficult topic for even experienced developers to get their heads around. Join us for the demonstration and a lively Q & A to explore how you can improve the quality of your data.


Pat Hartman

Mostly retired but still take the occasional call from long time clients.

I started programming in 1967 at The Traveler’s Insurance Co in Hartford. So I’ve been programming since before I was old enough to vote and before there were degree programs for software disciplines.  The Traveler’s took me as a trainee and molded me in their image where I worked for the next 20+ years for them and later as a consultant all over the US and even in the Middle East using COBOL, IMS, DB2, and CICS.  Then in the early 90’s while on assignment at Reader’s Digest I discovered Access.  I thought I’d died and gone to heaven.  I could make pretty forms by pointing and clicking and little code (compared to building a CICS transaction from scratch).  Access could update DB2 tables on the IBM mainframe and was so much more productive than coding everything by hand that I gradually started shifting my practice from mainframe work to Access.  Good thing to because after the Y2K debacle, the mainframe work dried up and moved to India where people were doing it for $5 per hour and no benefits.


For a couple of years, I was an “insider” at Microsoft and even attended a very special event in Redmond where the Access team demo’d the final beta of Access to about 20 of us in early 2006.  I took it home the first release candidate and installed it and never went back.  The following year, Office 2007 was released and along with it, lots of changes.  A number of which still irk me to this day.  It’s all about mouse clicks and change for the sake of change but here we are.  After that I moved on to being an MVP for a few years.


I started answering questions on forums a couple of years after I discovered Access mostly because I could.  I would go in search of a solution and end up helping someone else.  Access is very much like bridge (my other love).  It is obvious enough that you can sort of use it after a couple of hours but it takes a lifetime to master so it never gets boring.

Pat Hartman is also a long-time friend; I’m delighted she agreed to meet with us for this presentation.


Access Pacific holds FREE Q&A webinars the First Thursday of every month, from 6:30 pm to 7:30 pm Pacific.


Please prepare ahead of time by downloading Zoom, if you don’t already have it.

Get Zoom

To join our meetings, please use the following link and phone number or use your computer’s speakers with audio:

When it’s time, join the meeting from here:

Join Zoom Meeting

If you are asked:

Meeting ID: 861 2395 1916
Passcode: AUG_AP1!

Dial by your location
+1 253 215 8782 US (Tacoma)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 301 715 8592 US (Washington DC)
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
Meeting ID: 861 2395 1916
Passcode: AUG_AP1!
Find your local number: