Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Call Me…

Calling an Event Procedure from one Form to another…

Every once in a while I need to use the same code I have in the Event Procedure of a one Control in another Forms Event Procedure, whether it be the On_Click event of a Command Button or the After_Update of a Combo Box. 99% of […]

 614 total views

Highlight Current Record…

Highlighting the current record is an often asked question. You could use Conditional Formatting but then you have to do it for each Control in the Detail section of your Form. I prefer this way…

Step 1

Make sure all visible controls have been set for a Transparent background

Step 2

Put an invisible Control […]

 2,053 total views

Exporting clickable Hyperlinks…

Generally, I store the path to my file and the name of the File in two separate fields. I do this because if there is a likelihood that the database will be upsized to SQL Server the Hyperlink data type in Access is not supported and I’d have to do it anyway. Not a big […]

 2,811 total views

Help…

Ever need to create a few instructions for your database? Or maybe you just want to include some assistance to the End User for easier data entry. This database allows you to do just that. While not designed for extensive *Help* it does give you the ability to provide information to your End User.

To […]

 1,750 total views

Another post on Sequential Numbering…

The most often asked question is about customizing Autonumber.

The answer is, don’t! If you want to use a sequential numbering system Autonumber is not the Data Type to use. Even if you want to include Autonumber with another Field to make a composite… don’t, it’s not always sequential. (More on that later) Leave Autonumber […]

 6,561 total views