Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Controlling Scrollbars in Subforms…

Subforms are a little peculiar when used as Continuous Forms… when the Subform produces 3 records which, in this example, calls for the Scrollbar and you then switch, from the Main Form, and you only have two records or less showing you have this shadow area where the Scrollbar used to be (Figure2)… slightly annoying […]

 1,237 total views,  1 views today

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

Access 2016 Runtime now available…

“The Microsoft Access 2016 Runtime enables you to distribute Access 2016 applications to Users who do not have the full version of Access 2016 installed on their computers.”

To download click here…

 847 total views,  2 views today

 847 total views,  2 views today

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 […]

 2,043 total views

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 […]

 854 total views,  1 views today