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

Split a Large MS Access Datasheet in to 3 Smaller Datasheets

Split a Large MS Access Datasheet in to 3 Smaller Datasheets You’ve got a large “VERTICAL” List of Data in datasheet form, you might prefer to have it spread out across the screen instead of constantly having to page up and down the list. In this set of videos I demonstrate two ways of implementing … Read more

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

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

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

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.