Delete Tables

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

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

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

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

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 Product Details and Download 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 … Read more

Show-Hide-Export to Excel

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

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

Simulated Option Group

Simulated Option Group The normal MS Access Option Groups are stuck at very small size, and notoriously bland and uninteresting. This product from Nifty Access is made like my other products, an easy to “Drop In” component to enhance the Look and functionality of your Database. To use this product all you do is add … Read more

Value

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

Update Excel from MS Access

Update Excel from MS Access Update Excel from MS Access Image 1 Someone asked:- How to update Excel from MS Access? (Access World Forums)  This question reminded me that I had a couple of excellent links hidden away, a couple of links to Microsoft Support where they provide two excellent articles on how to do … Read more

Do you need a hand in the right direction?

You are in the right place.