How old is that person?

Another simple but powerful piece of code I get asked for a lot:  Age calculations.  it sounds so simple…but it isn’t!  You can use variations of this for other purposes like aging receivables, calculating time lapse, etc. Requirement:  a date field (in...

MDE vs MDB and ACCDB…confused?

Only because this was an issue for several people over the last year who called us…note the following: Older Access databases end in .mdb (Access 2003 or earlier) Newer Access databases end in .accdb (Access 2007 and later) If you compile a database (Click File,...

Using Cases to Change Events on Tab Controls

In order to give a tab control different events for each tab being clicked, you can use a case statement. The case statement uses the case number to match to the Tab Page Index.  Each tab has an identifier, starting at 0. This works well, as long as you don’t...