|
||||||
Access MVP (2010-2015) |
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 […] 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 […] Recently, while trying to Debug some code a colleague of mine suggested I leave Compile on Demand1 unchecked. Since in all my years of developing I have always left it checked, I asked why and here’s what he said got… Many years ago, Michael Kaplan mentioned that this setting was known to cause problems, […] …you can see them, thanks to a post by JoelS_999 in the Microsoft Community Forums. And, while this may not be exactly what you want, this neat little piece of code will allow you to see them in a table, tblSysObjProps. This is especially helpful when upgrading from Access 2003 and below, where you have […] After seeing a post in a Forum asking about how to add the word *continued…* to a Multicolumn Report I thought it would be fun to create a sample database showing off the feature, to download click here (Access 2007 or above needed and an unzipping program. Images are not included!). And, of course, like […] |
 |
||||
|
Copyright © 2026 Gina's Coffee Shop - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
