Time & Date I need this “Dates” page as a general page for the top of my Dates Menu. Will add more information about dates as I find useful stuff on the internet. In the meantime, just below here is a drop down menu which gives you links to the stuff already on my website … Read more
Delete Tables There are various options for deleting tables. I will gradually build up this webpage with more options as time permits. However before you delete “ANYTHING” in your MS Access Database, make a backup first! It’s amazing even the most seasoned professionals can fall foul of this Brain Fart! Delete Tables Delete Tables Video … Read more
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
SQL Statements For Beginners You are here because you can build Queries with the Query Designer grid in MS Access, however you’ve started to realise that the Query Designer grid can’t do everything you want. A query is basically a string of text characters, often referred to as an SQL String. And that’s the key … Read more
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
Spell Checker Popup Form Nifty Spell Checker PopUp Form Nifty Spell Checker Pop-Up Form Video 1 (1:42) This video demonstrates the spell checker pop-up working Video 1 (1:42) https://www.youtube.com/watch?v=a3T8Xw9BVag … … Nifty Spell Checker – Setup Nifty Spell Checker – Setup the Pop Up! Video 2 (4:29) In this video I demonstrate how to download & install the … Read more
Show/Hide & Export to Excel What started out as an answer to a question on Expert Exchange, took on a life of its own and became a pop-up form which allows you to select the columns you want to display in a datasheet. Now, this is not at all a groundbreaking technology! It’s actually already … 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
This page relates to the first iteration of the “Simulated Option Group” which is now called the “Nifty Option Group”… The “Nifty Option Group” is the latest version, the maintained version, and can be found here:- https://www.niftyaccess.com/nifty-option-group/ “Nifty Option Group” – Is HERE – Click Me!!! Simulated Option Group The normal MS Access Option Groups … Read more
Use “Value” or Not? I’ve noticed a couple of minor glitches caused by the default of a ‘textbox’, the value; not being assigned explicitly. It’s not a big problem and I don’t think it will affect many people, possibly nobody! However I think there’s a good blog in it for someone, possibly me, when I’ve … Read more
