Prevent Duplicates

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 Prevent Duplicates

Insert Into SQL Statement

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 Insert Into SQL Statement

Move Info from One Table to Another

Move Info from One Table to Another A brief summary summary of the “OP’s” (Original Posters) question HERE. The question prompted me to create this set videos. The 6 videos here demonstrate how to extract a particular Row…. …. …. ….. ……. …… …….. ……. ……. …. ….. …… Selecting a checkbox in a datasheet … Read more Move Info from One Table to Another

Transcript – Combo Alpha List

Video Transcript Transcript of the Videos HERE Video 1 Transcript – (Start) 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” … Read more Transcript – Combo Alpha List

Screenshots – Combo Alpha List

 1. Double Click on the Combo to call up the “Combo Alpha List” Form 2. The Combo “Alpha List Form” Opens 3. Pressing the “Command Button” also calls the Form 4. Form Called 5. Buttons without Records are “Greyed Out” 6. Same on the Numbers Tab 7. The Normal 26 Characters of the Alphabet are … Read more Screenshots – Combo Alpha List

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 Box Alpha List

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 Sellfy 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 “Sort Orders”, however if … Read more Combo Filter < All> or Some

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 Northwind Problem and Solution