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 more Prevent Duplicates

Spell Checker Popup Form

Spell Checker Popup Form Nifty Spell Checker PopUp Form Nifty Spell Checker Pop-Up Form Video 1 (1:42) This video demonstrates the spell checker pop-up working Product Details and Download Video 1 (1:42) https://www.youtube.com/watch?v=a3T8Xw9BVag … … Nifty Spell Checker – Setup Nifty Spell Checker – Setup the Pop Up! Video 2 (4:29) In this video I demonstrate how to … Read more Spell 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 more Is 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 more Show-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 more Insert 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 more Simulated Option Group

Do you need a hand in the right direction?

You are in the right place.