Nifty Option Group

Nifty Option Group The Option Groups in Microsoft Access are at best a fine utility, however they do not lend themselves to much modification. You are stuck with an antiquated looking Option Group. If you want something a bit special, then have a look at my product “Nifty Option Group” Whilst creating a class module … Read more

Nifty Container

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

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

Split a Large MS Access Datasheet in to 3 Smaller Datasheets

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 more

Run-time error 438

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. [wp_ad_camp_1] Different … Read more

Spell Checker Popup Form

Spell Checker Popup Form [wp_ad_camp_1] 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 … Read more

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

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

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

Display Data from a Combo Box in a Text Box

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

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.