Prevent Duplicates When entering data into a subform, particularly when you select The data from a combobox, then you probably don’t want the user to be able to select the same item twice. You may want to count the various entries at some stage and having duplicates would just make this inaccurate. There are numerous … Read morePrevent Duplicates
Split a Large MS Access Datasheet in to 3 Smaller Datasheets You’ve got a large “VERTICAL” List of Data in datasheet form, you might prefer to have it spread out across the screen instead of constantly having to page up and down the list. In this set of videos I demonstrate two ways of implementing … Read moreSplit a Large MS Access Datasheet in to 3 Smaller Datasheets
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 moreRun-time error 438
Spell Checker Popup Form Spell Checker Popup Form In answering the question in this Thread, http://www.access-programmers.co.uk/forums/showthread.php?p=767936 missinglinq demonstrated an excellent way of spell checking a text box (text and memo field) text entries. I realised that a Class Module I was developing would probably be put to good use in solving this problem as well! … Read moreSpell Checker Popup Form
Is This Control a Hyperlink? Gasman asked the Question:- Hi all, In the Northwind 2007 database, the id control on the form for Customer List appears to be a hyperlink. However I can not see how this is done.? The isHyperlink property is set to no. Al I can find is in the Tag property … Read moreIs This Control a Hyperlink
Show/Hide & Export to Excel What started out as an answer to a question on Expert Exchange, took on a life of its own and became a pop-up form which allows you to select the columns you want to display in a datasheet. Now, this is not at all a groundbreaking technology! It’s actually already … Read moreShow-Hide-Export to Excel
INSERT INTO SQL Statement I regularly see messages on MS Access Forums where people are struggling to make the INSERT INTO SQL Statement work. I can understand why, for a start the error messages (if you get any) have very little relationship to what is actually wrong. The syntax, the usual suspect, is a minefield, … Read moreInsert Into SQL Statement
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 moreDisplay Data from a Combo Box in a Text Box
Simulated Option Group The normal MS Access Option Groups are stuck at very small size, and notoriously bland and uninteresting. This product from Nifty Access is made like my other products, an easy to “Drop In” component to enhance the Look and functionality of your Database. To use this product all you do is add … Read moreSimulated Option Group
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 process in this short video… This is … Read moreFind The Caption of a Label Attached to a Textbox
