Nifty Container The “Nifty Container” offers you a graphical way of managing the controls on your form. All you do is surround a group of controls with a box, choose one of the coding examples, or write your own, and there you go, you have a simple and easy-to-use method, which avoids using your Control(s) … Read more
Run-time error 438 Run-time error 438 – Object doesn't support this property or method. – (Microsoft Access) This problem often occurs when you Loop through a set of controls with a For Next Loop. It happens because you are examining the properties of a control. However not all controls have the same properties. Different Controls, … Read more
Display Data from a Combo Box Combo boxes are one of the most valuable controls you can have on a form, they are so versatile and give you such an extra range of functions for your form that you should really consider understanding how to use them. Also with a combobox as your foundation, you … Read more
Getting the Caption of a Textbox Label Getting the Caption of a Textbox Label Caption of a Label Attached to a Textbox You might think getting the caption of Textbox Label would be just as simple as getting the caption of a Command Button. However it’s a little bit more involved. I run through the … Read more
Use “Value” or Not? I’ve noticed a couple of minor glitches caused by the default of a ‘textbox’, the value; not being assigned explicitly. It’s not a big problem and I don’t think it will affect many people, possibly nobody! However I think there’s a good blog in it for someone, possibly me, when I’ve … Read more
Attach a Label Attach a missing label – Nifty Access – The problem you are facing is, you’ve got a Control and it’s missing its Label. To duplicate the situation, first create a Textbox on an MS Access Form. Created a text box with a label. When you move the text box, the Label moves … Read more
List Box Default Please be aware that while upgrading the Nifty Access Website I discovered this post. I tried to link it back to the original post on Access World Forums, however I couldn’t I find the post. I found one that looks similar, but I don’t think it is the correct one! I’m going … Read more
Control Wizard The Control Wizard is a very handy feature of MS Access. It provides built-in wizards, which simplify many of the processes you have to partake in to build your MS Access database. Button Wizard (Access 2007) Button Wizard (Access 2007) Video 1 (2:09) Demonstrate how to use the MS Access (2007) command button wizard … Read more
Enable or Disable by Command In this video I demonstrate how to make a control appear greyed out. In other words, you can’t do anything with it. I demonstrate the process by using two separate command buttons, however it is possible to do it with a single command button. I have a video demonstrating this, … Read more
Vertical Text If you’re stuck for real estate, (a crowded jumbled Form) a particularly busy Form then one way of getting a bit more room might be to have a label oriented vertically. An alternative would be to take stuff off your Form and put it on a pop-up Form. You can see my blog … Read more
