Access MVP (2010-2015)


Remember when…

Okay, I may be showing my age here but remember when…

…*Hard Drives* involved a car

…*Memory* was something you lost with age

…an *Application* was for employment

…a *Program* was a television show

…a *Cursor* involved profanity

…a *Keyboard* referred to a piano

…a *Web* was a spider’s home

…a *CD* was a Certificate […]

 686 total views

Custom Navigation Buttons…

While Access provides Navigation Buttons, they must always be at the bottom of the Form. This does not work for my Form designs (Figure 1). Using the code below you can put your Navigation buttons where you want them AND avoid the *No Current Record* message that happens when the underlying recordset contains no records. […]

 3,099 total views

Custom Record Count…

There are times you want to display a Record Count on your Form. Or, maybe, you want to use your own Navigation Buttons but how to get the Record Count to display? Here are two options…

Click to see entire Form

txtPage is the name of the unbound TEXT field between the […]

 1,682 total views

Sort using Labels…

On continuous forms Users always want to Sort and while they could do it from the Toolbar (Access 2003 or lower) or the Ribbon (access 2007 or higher), here’s another option…

The two fields we’re going to use are Date Modified and Import Date. As you can see, I changed the LABEL back color to […]

 1,583 total views


Toon-A-Day (c)

A distraught senior citizen phoned her doctor’s office.

‘Is it true,’ she wanted to know, ‘that the medication you prescribed has to be taken for the rest of my life?’

‘Yes, I’m afraid so,’ the doctor told her.

There was a moment of silence before the senior lady replied, ‘I’m wondering, […]

 1,148 total views