Next Previous Quit

Next Previous Quit I saw this excellent code by June7 for controlling a Previous/Next set of buttons. A nice feature to add to your Form. I noticed that the code might lend itself to being packaged into to what I call a Drop-In Component. This means I provide the VBA Code in a format … 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

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) … … Nifty Spell Checker – Setup Nifty Spell Checker – Setup the Pop Up! Video 2 (4:29) In this video I demonstrate how to … Read more

Access Table to Many Excel Sheets

Access Table to Many Excel Sheets This handy product from Nifty Access allows you to complete a difficult labour intensive process with ease without using any code! This drop-in component will automatically enhance your MS Access skills, helping you to become the go-to person in your organisation for database development. All the code is available … Read more

Make Excel Sheets From Access Table

Excel Sheets From Access Table OP “avalve” asked this question on Access World Forums:- “Howdy! Let me make a small scenario. Let’s say I have a table with fields CarMake/CarModel/Year/Color. What I am trying to do is to export the table to a single Excel Workbook with each CarMake having their own page displaying only … 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

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


Barcodes Bar-codes along with a bar-code scanner can be a very useful feature to add to your database. You can quickly scan in serial numbers from mass deliveries of items / components. Bar codes are also very handy for managing the repair process of an item returned for repair. For example, by recording a repaired … Read more

Normalization Tool

Normalization Tool This “Transpose Tool” – “Database Normalization Tool” allows you to easily convert Spreadsheet structured data into MS Access structured data. This transformation of your data allows you to build incredibly powerful MS Access Databases. This transformation is a critical process, only known to and practice by “Power Users”, users with a good grasp … Read more

Option Group Label Color Change

Option Group Label Color Change The technique employed in this sample is well worth learning and applying in your own MS Access database. There's always a gotcha when you are developing new code, and I hit one when I was trying to build this. I wrote the code to change the label colours, but it didn't … 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.