Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

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,828 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,760 total views

Filtering Forms…

Here are three ways to filter records on a Single Form or a Continuous Form. (In these examples no Subforms were used.)

Example 1 To toggle back and forth between (Yes/No Data Type) All and Completed (Tasks, Projects, Orders, etc.)…

Step 1

In the Header of you Form place an UNBOUND Check Box and name […]

 12,991 total views,  7 views today

Combo Box to Find Records…

You want your Users to be able to look up and/or add new activities for existing Companies but they may not know or remember the Company Name but they do remember the person they speak to on a daily basis. Well, you don’t want to add a separate Combo Box for Company Name, First Name, […]

 792 total views