Cheap Microsoft Office 2007 Manage large groups of

visitor blogger is Accessibility MVP Garry Robinson, who presents the Sensible Entry assortment of content articles at Sensible Accessibility Solutions, Doug Steele was asked “What if I have quite a lot of totally different controls–say, text boxes, labels, and look at boxes and I would like to make them invisible or visible whenever a sort is getting used? this section of code,Windows 7 Ultimate Sale, you can see how to loop by means of all the controls on the type and manipulate them implementing VBA. handle in Access has a Tag residence that you can use to retailer any additional data about a form, report, part,Windows 7 Home Premium X64, or handle needed by your software. It is really relatively straight forward to set the Tag house for each on the controls you want to treat the same way and then loop by means of all controls on the sort, utilising that residence to check whether or not to complete the action. Here is a simple version of your code that you would use: As Command
Dim booCondition As Boolean For every ctlCurr In Me.Controls If ctlCurr.Tag = "Group1" Then ctlCurr.Visible = booCondition End If
Next ctlCurr for this to work you need to set the Tag home of all with the controls in the group to identical value ("Group1" in my sample code). To set the Tag properties for a lot of controls in one step, select all with the controls you should group together. (If you're not familiar with selecting multiple controls at once, you possibly can draw a rectangle around all with the controls utilizing your mouse, or you possibly can hold down the Shift key while clicking on just about every control with your mouse.) Figure 1 shows a screen with several controls selected. 1 selected all of the controls,Windows 7 Ultimate Product Key, the Properties window will contain only those properties that exist for all with the selected controls. Assuming that you're about the Other or All tab in the Properties window,Cheap Microsoft Office 2010, the Tag home should be the last one listed. Type the name you ought to use for your group into the Tag house setting,Cheap Microsoft Office 2007, and it will apply to all for the selected controls (see Figure 2 for an example).
Figure 2 happens if the manage doesn’t actually have the home that you simply are manipulating? approach does possess a potential problem. Not all properties exist for every command. For example, you might have added a CheckBox to a group in which you're going to manipulate the Font. CheckBox controls, unfortunately, don't possess a FontName house, so if you attempt to set the FontName home on the CheckBox just because it has its Tag home set to the right value, your code will blow up. having to be very careful with what properties you'll be able to change for what groups, you'll be able to add a verify in your error trapping to handle this. Depending on how you're referring to a property that doesn't exist for a given command, you'll get either error range 438 ("Object doesn't support this method") or error amount 2455 ("You entered an expression that has an invalid reference to the property"). address the problem, you'll need an error checking routine along the lines of this code: GoTo Err_ChangeGroupProperties
'--- Management HANDLING CODE GOES HERE
End_tglFont_Click: Exit Sub Err_ChangeGroupProperties: If Err.Range = 438 Or Err.Range = 2455 Then Resume Next
Else MsgBox Err.Description & " (" & Err.Number & ")" Resume End_tglFont_Click
End If this code returns management to the line of code following the line of code that caused the error if either error 438 or 2455 occurs, thus ignoring the error. If the error is anything other than 438 or 2455, the error gets trapped in the Else part from the If statement. both simpler and more versatile ways to manipulate management properties, see Doug’s full article from the Wise Access collection at
a guest blogger! Send your favorite Access tips to Mike & Chris at accpower@microsoft.com.