Nifty Option Group – Wingding 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 … Read more
Next Previous Quit I saw this excellent code by June7 for controlling a Previous/Next set of buttons. https://www.access-programmers.co.uk/forums/threads/database-problems.312570/#post-1705270 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
Between Dates – Selection Form Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat … Read more
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 Nifty Spell Checker PopUp Form Nifty Spell Checker Pop-Up Form Video 1 (1:42) This video demonstrates the spell checker pop-up working 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 download & install the … Read more
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
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 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
This page relates to the first iteration of the “Simulated Option Group” which is now called the “Nifty Option Group”… The “Nifty Option Group” is the latest version, the maintained version, and can be found here:- https://www.niftyaccess.com/nifty-option-group/ “Nifty Option Group” – Is HERE – Click Me!!! Simulated Option Group The normal MS Access Option Groups … 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
