Access MVP (2010-2015)


Where’s the Cursor?

When tabbing between Controls on Forms and they contain text all the data within the Control is selected. This can be problematic as Users may inadvertently overwrite what is already there and not even realize it as they begin typing. To avoid that you can force the Cursor to land at the beginning or the […]

 680 total views,  1 views today

List Tables and Fields…

When I’m designing a database I usually start off with one of my Templates. But, as with any Template, the Tables therein do not always fit exactly with the Client’s needs. And, since I like to document changes I built this tool…

In a nutshell… After the Template database is created I import the […]

 1,404 total views,  2 views today

Conditional Image on a Continuous Form (Reminders)…

Since Microsoft Access 2007 getting a different Image to show up for each record is pretty easy, you just need to bind the Image Control to the field that holds the path to the image and you are done. However, I wanted a conditional image on my Continuous Form based on whether there was a […]

 1,968 total views,  1 views today

Tools, Utilities and more…

Recently, I watched Free Tools for Microsoft Access recorded by Crystal Long and Adrian Bell (Microsoft Access MVP’s) on Channel 9. Upon looking at comments below it dawned on me there is no central location for all those great free tools! How is anyone to find them? After all, you may not know they […]

 634 total views,  2 views today

Controlling Scrollbars in Subforms…

Subforms are a little peculiar when used as Continuous Forms… when the Subform produces 3 records which, in this example, calls for the Scrollbar and you then switch, from the Main Form, and you only have two records or less showing you have this shadow area where the Scrollbar used to be (Figure2)… slightly annoying […]

 1,193 total views