Nifty Check Box – Nifty Access GROK TEST






Nifty Check Box – Nifty Access


Nifty Check Box

The Microsoft Access interface has improved substantially over the years. However, for some reason one of the most basic components you can put on your MS Access Form, the humble check-box has remained the same standard 1990s style object. Well, that’s about to change! I’ve made my own “Nifty Check Box” which you can see demonstrated in the video below. It’s based on a command button. You can change the command button image, having one image for the true, and one for false, or if you prefer, the yes/no response you want from the simulated check box.

Nifty Check Box – Setup Videos

Nifty Check Box – Over View 1

Video 1 (4:32)

Run through of the “Nifty Check Box”
Explanation of how a normal Check Box works.
How a normal Checkbox links to the table.
I Demo the Boolean values used in a checkbox the -1 and 0.
You cannot link a Command Button to the underlying data.
I show how the option group frame is actually linked to the underlying data.
I mentioned that I’ve got a solution which you can see in the next video! – Nifty Check Box – Over View 2

Full Product Details and Download

Nifty Check Box – Over View 2

Video 2 (7:48)

I thought What’s the problem with the standard MS Access Check Box? And how can I solve it? The problem is, the Check Box needs to be bigger.
I realised it would also be nice if you could use your own images for the Check Boxes.
Well, I’ve come up with a method which allows you to use your own images! And here it is.
I replaced the Microsoft Check Box with a Command Button, a Command Button with an image on it. When you click on the Button, it changes the image from an empty unchecked checkbox to a checked checkbox.

Nifty Check Box – Setup 3

Video 3 (4:58)

I thought What’s the problem with the standard MS Access Check Box? And how can I solve it? The problem is, the Check Box needs to be bigger.
I realised it would also be nice if you could use your own images for the Check Boxes.
Well, I’ve come up with a method which allows you to use your own images! And here it is.
I replaced the Microsoft Check Box with a Command Button, a Command Button with an image on it. When you click on the Button, it changes the image from an empty unchecked checkbox to a checked checkbox.

Nifty Check Box – Adding Icons – 4

Video 4 (5:41)

I thought What’s the problem with the standard MS Access Check Box? And how can I solve it? The problem is, the Check Box needs to be bigger.
I realised it would also be nice if you could use your own images for the Check Boxes.
Well, I’ve come up with a method which allows you to use your own images! And here it is.
I replaced the Microsoft Check Box with a Command Button, a Command Button with an image on it. When you click on the Button, it changes the image from an empty unchecked checkbox to a checked checkbox.

… …



TEST123






Nifty Search Form – Nifty Access Reproduction


Nifty Search Form

This Advanced but simple to use Search Form is unbelievably easy to set-up. Just create a query and a subform. Following the comprehensive Video Instructions you can integrate the Search Form into your own database. The Nifty Search Form is one of my “Nifty Access Drop in ‘Nifty Components'” – use it to elevate yourself to “Power User Level” in your organisation!

Video 1 (1:03)

Demonstrates the search form’s features, specifically the option to search for text formatting characters at the beginning, middle, and end.

Video 2 (8:30)

Shows how to change the form to display products or customers, including steps and potential pitfalls.

Video 3 (3:58)

Explains how to search another field (e.g., customer reference). Notes that the form is designed only for text searches, not numbers or dates.

Video 4 (4:12)

Provides a quick setup demonstration of the “Nifty Search Form” from scratch, with minimal narration except for mouse clicks.

Video 5 (00:57)

Demonstrates solving a search problem from Access World Forums using the Nifty Search Form. References a forum thread and includes a YouTube video answer.

Video 6 (2:42)

Examines the code behind the Search Form, focusing on modifications for exact matches and null values. Intended for users who want to alter the code.

Video 7 (4:12)

Continues the code discussion from Video 6, covering updates for exact matches and null values in response to a customer request.



Multilingual Filtering with MS Access

Multilingual Filtering with MS Access

I want to take you through the process I use to turn simple ideas into market-ready products. As an MS Access programmer, I often find myself Creating code in response to questions on forums. These answers are usually tailored to the question, which means the Code might need a bit of tweaking to work elsewhere. I refine these specific solutions into generic products that anyone can plug into their database and use.

In this blog, I’ll dive into how I created a product that lets you filter MS Access data.

The Art of Filtering in MS Access

The Art of Filtering in MS Access

Video 1 (2.29)

The filtering capabilities in MS Access are somewhat similar to filtering in Excel. For this example, let’s Look at the Northwind database, focusing on the products table. The original question came from someone who speaks Spanish, so you’ll notice it’s partly bilingual — an Interesting happenstance that allows for the introduction of what I believe is a unique technique for multi-language support without altering the underlying code.

This is the heading

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Video 1 (2.29)

Nifty Access YouTube Thumb Nail

More - Heading HERE:-

… …

More Useful Stuff HERE:-

Facebook
LinkedIn
Twitter

Nifty Date Picker – With Year Selector

Nifty Date Picker – With Year Selector

Using a relatively unknown feature of a combobox, I have added a year selector to the Nifty Date Picker. It would be fairly simple to add a list of years into the combobox as a value list, but you would be stuck with a hard coded range of years. If you had an application where you were entering dates in the distant past or future, then it would be restrictive.

Overtime the value list of dates would become outdated and need to be updated to make it relevant again. Many years ago I came across the “Call Back Function” the example I saw was used to to display a list of years, exactly as I have duplicated here in my “Nifty Date Picker” I lost this example, and it only recently since seeing a YouTube by Crystal Long that I thought I should look at it again.

In Video 1 Below, I demonstrate both the “Year Picker” and the “Month Picker” both of which are based on “Call Back Functions”

In a future video I will explain the callback function how it works.

Nifty Date Picker – With Year Selector

Nifty Date Picker – With Year Selector

Video 1 (03:33)

This YouTube is a quick look at an implementation of the combobox Callback Function in action.

Video 1 (03:33)

Nifty Access YouTube Thumb Nail

… …

More Useful Stuff HERE:-

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.