Access MVP (2010-2015)


Conditional Image on a Continuous Form (Reminders)…

Since Microsoft Access 2007 getting a different Image to show up for each record is pretty easy, you just need to bind the Image Control to the field that holds the path to the image and you are done. However, I wanted a conditional image on my Continuous Form based on whether there was a […]

 1,880 total views

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

Conditional Row Shading on a Continuous Form

Row Shading has come a long way since Access 2003 where you had to use code to get it to happen. Remember this…

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If bluebar Then Detail.BackColor = 16777215 Else Detail.BackColor = 13888992 End If

bluebar = Not (bluebar)

End Sub

Then came Access 2007 and we […]

 3,011 total views,  2 views today

Navigate a Continuous Form like Excel…

Continuous forms allow you to display data resembling an Excel spreadsheet. However, you can’t navigate a Continuous form like you do an Excel spreadsheet (much to your Users dismay), well, that is, not until now…

In your modUtilities copy/paste the below (If you don’t have a modUtilities create one. It’s a place to keep all […]

 2,484 total views,  2 views today