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

Spell Checker Popup Form

Spell Checker Popup Form Spell Checker Popup Form In answering the question in this Thread,  http://www.access-programmers.co.uk/forums/showthread.php?p=767936 missinglinq demonstrated an excellent way of spell checking a text box (text and memo field) text entries. I realised that a Class Module I was developing would probably be put to good use in solving this problem as well! … Read moreSpell Checker Popup Form

Sticky Form Builder

Sticky Form Builder A “Sticky Form” is a Form that stays put! How many times have you opened up a pop-up form and had to move it to one side because it’s covering up exactly what you want to look at! It’s bloody annoying! I was pretty sure it was possible to make a Form … Read moreSticky Form Builder

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

Nifty Date Picker

Nifty Date Picker There are some excellent date pickers available on the internet. So why should you use mine? First of all I’ve included details of my thought processes when I constructed it, including where I went wrong! This in itself will prove useful for anyone who wants to build stuff in MS Access. It … Read moreNifty Date Picker

Subform – Time Management Matrix Example

Time Management Matrix This example demonstrates how you can can use “Instances” of a Form multiple times. You place the copies on the main form as “Sub-Forms” It’s an interesting way of programming, and with this technique you can quickly develop Forms with exceptional properties and uses with very little coding… Subform Example Subform Example … Read moreSubform – Time Management Matrix Example

Subform Record Duplicator

Subform Record Duplicator Nifty Access – “Subform Record Replicator” allows you to provide your user with the facility to quickly add sets of duplicate records in a subform. All they need do is specify the number of Records they want to add, select a record to copy, and hey presto you’ve got a load of … Read moreSubform Record Duplicator

Control Records Displayed in a Subform

Control Records Displayed in Subform Control Records Displayed in a Subform Video 1 (5:18) Klingest Asked — What I want to do is, that when you select a record in the subform showing “tblCalculation”, the related values from “tblSubCalculation” shall be displayed in the other subform.  How can I do that? In this video I answer … Read moreControl Records Displayed in a Subform