Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Expand SubDatasheets

Okay, so we all know I recommend turning off the SubDatasheet but I can see by the Forums they are still quite popular. For those of you that are still using them…

When you first open your Main Form/Subform (Datasheet View) it opens closed (Little plus signs). This is often quite annoying to Users as […]

Loading

Turn off Datasheet Subform filtering

Tip provided by Don Leverton

Beginning with Access 2007 …

Datasheet style subforms (which I use a LOT of) have been “improved” by offering dropdowns in the top row of fieldnames, which allow filtering and sorting options.

This is something that I DO NOT want!

In order to turn OFF this behavior, go to […]

Loading

Refer to Controls on Forms/Subforms

It’s always a nightmare when you’re trying to reference a control from one Form to another or one Report or another. You think you’ve typed it correctly but it’s still not returning the value. Here are two ways to get that accomplished…

From The Access Web… Refer to Form and Subform properties and controls

OR

[…]

Loading