Easy Search Criteria

Easy Search Criteria More years ago than I care to remember, I created this Search Form. It was one of my first Adventures into MS Access VBA. Later, when I was looking for a subject which I could use as a way of introducing people into the world of VBA, it was this Search Form … Read more

Transcript – Combo Alpha List

Transcript – Combo Alpha List Video 1 Transcript You can double click the combo, or press a command button to call up the Combo Box Alpha List Form. The form automatically sorts your list of data in to alphabetic/numeric groups. These are accessed by the toggle buttons. You can press “G” and you will only … Read more

Loop Through a Set of Controls

Loop Through a Set of Controls A common requirement is to check a set of controls for a particular value or condition. Here I demonstrate two methods. The technique employed is what I call the “For Each Control in Me Controls” – it’s a technique where you interrogate each control “in/on” the Form in turn. … Read more

Screenshots – Combo Alpha List

Screenshots – Combo Alpha List One of the problems you can run into when you have a combo-box which contains a lot of records, is it can be difficult for the user to find a particular record. With the “Nifty Combo Box Organiser” you can offer your user a professional and sophisticated search function for … Read more

Combo Box Alpha List

Combo-box Alpha List Combo Box Alpha List (for MS Access) One of the problems you can run into when you have a combo-box which contains a lot of records, is it can be very difficult for the user to find a particular record. With the “Combo Box Alpha List” you can offer your user a … Read more

Combo Filter < All> or Some

Combo Filtering You can set this up yourself by following the instructions below, or you can study the example file which can be downloaded from the Nifty Digital downloads site for a few dollars.. will normally appear as the first entry in your list because the angle bracket puts it at the beginning of most … Read more

Northwind Problem and Solution

Northwind Problem and Solution If you use the Northwind database as a basis for your business application then there is a problem that you should be aware of. The sample Northwind database supplied by Microsoft provides some excellent insights in how you should program an MS Access application. However if you decide to use it … Read more

Lock, Unlock Controls

Lock, Unlock Controls A problem that crops up from time to time is the need to handle a Group of Controls differently from the rest of the Controls on a Form.Usually this is the need to Lock the Controls so that Data cannot be changed, and conversely Unlock them. However it may be the need … 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.