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 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
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 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
Move Info from One Table to Another A brief summary summary of the “OP’s” (Original Posters) question HERE. I’ve done a set of YouTube videos to answer the question. The first answer demonstrates the INSERT INTO method of adding records to another table. This method is where you update the underlying table by adding a … Read more
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
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 (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 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 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
