Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Maintain Record Position After Update

When updating a record on a Continuous Form it has a tendency to scroll back up to the top. For End Users this can be problematic as they have now lost their place and have to scroll down to find it. Here’s two slightly different Function to prevent that…

This one will cause the record […]

Loading

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