Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Export a Parameter Query to Excel…

It’s always tricky when you want export filtered data to Excel. You will get an error message if you put try to put the Forms Control in the Criteria section of the Query. Why? Because Access insists on having the value before it can execute the export and not from the Form but directly in […]

151 total views, no views today

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

154 total views, no views today

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

499 total views, no 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 […]

709 total views, 1 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…

119 total views, no views today

119 total views, no views today