Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Sort by Descriptions is gone in Access 2007 and up but…

…you can see them, thanks to a post by JoelS_999 in the Microsoft Community Forums. And, while this may not be exactly what you want, this neat little piece of code will allow you to see them in a table, tblSysObjProps. This is especially helpful when upgrading from Access 2003 and below, where you have […]

 1,071 total views

Navigate a Continuous Form like Excel…

Continuous forms allow you to display data resembling an Excel spreadsheet. However, you can’t navigate a Continuous form like you do an Excel spreadsheet (much to your Users dismay), well, that is, not until now…

In your modUtilities copy/paste the below (If you don’t have a modUtilities create one. It’s a place to keep all […]

 2,637 total views,  1 views today

Excel Manipulation from Access…

Sometimes, I have to send data out to Excel. Every once in a while I have to add a little something to that data… row count, specific Worksheet, a formula, etc. For those times when you find you need to do the same, here’s what I’ve used…

I always use Late Binding, highlighted in […]

 2,588 total views,  3 views today

.Tag, you’re it…

The .Tag Property, not to be confused with Smart Tags, of a Control is probably the most under used and confusing Property of all. So what do you do with it? Here’s some examples…

1. Use it to Lock bound Controls…

Dim ctl As Control Dim frm As Form For Each ctl In frm.Controls If […]

 1,412 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,234 total views,  2 views today