Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Move Selections Up/Down in a List Box…

Moving selections up and down a List Box, sounds simple right? Well, not so much… unless your name is Dale Fry. I wanted a way for Users to be able to reorder items in a List Box, i.e. tasks, to do lists, activities and documents. With this you can move items up or down on […]

 1,926 total views,  1 views today

Delete a line from exported .RTF document…

Recently, I exported an Access Report to Word (.RTF). Nope, did not use Albert’s Super Easy Word Merge because the nature of the report with its many Subreports and Sub-Subreports did not lend itself to a mail merge. Only after I exported it I needed to first copy it in its entirety to another document […]

 798 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,839 total views,  2 views today

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,770 total views,  1 views today

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,605 total views