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

What happened to my Form Icon?

So, you checked Use as Form and Report Icon under Options > Current Database for your customized Icon to show on your Forms and Reports but when you opened your Form (or Report) there’s no icon…

Well, here’s the thing, if you choose No in the Properties window for the Form (or Report) under […]

Loading

Create a Splash Screen (Simple)

To create a Splash Screen using a Form…

Create a new Form In the Properties Sheet set… Set the Border to None Set Auto Center to Yes Set Pop Up to Yes Set Moveable to No (optional) Set the Timer Interval to the amount of time (in milliseconds) you want the Splash Screen to […]

Loading

Group/Ungroup Controls

This tip is for Access 2007 and up…

Select all the Controls you want to keep together by holding down the Ctrl key on your keyboard while selecting On the Arrange tab on the Ribbon, select Size/Space then Grouping and click Group/Ungroup

Loading