Prevent Duplicates

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

Spell Checker Popup Form

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

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

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

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

Simulated Option Group

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