Nifty Tips

Nifty Video Tips

Using an excellent new feature of Elementor Page Builder I am now able to show you clips from my MS Access Videos.

Insert VBA Code Snippets

A useful feature of MS Access is the ability to insert VBA Code Snippets from the insert file menu option.

Basically you keep all your Code Snippets in text files in a folder on your computer, that’s it! It’s also possible to create, edit and update the files on the go, as you work, creating your VBA code. In this video I demonstrate how to do it.

Play Video

SQL Insert Statement

Formatting SQL statements can be a pain. It is often a source of errors and difficult to discover where the error is. The solution is quite simple as with any coding, “divide and conquer” in this video I show you an easy way to format your SQL statements so that you removed any chance of errors creeping in!

Play Video

Global Variables 1

Everyone will tell you you shouldn’t use global variables. There are good reasons for this but I won’t go into those. I will just show you in this video what you can do instead!

Play Video

Auto Complete with Ctrl Space

Handy tip here you can use Control (Ctrl) Space to speed up your coding! Control space calls up autocorrect autofill and enters instructions automatically…

Play Video

Bring Your Code to the Top

By bringing the latest code you are working onto the top of your module, you are quickly and easily able to pick up where you left off, after an extended absence from your project!

Play Video

Compact On Close

Compact on close is one of those things which you may or may not want! I use it a lot myself but occasionally find it can cause issues.

Play Video

Take out the Tables

You can remove most of the references to the table name when your SQL Statement is based on a single table. This trick depends on NOT just selecting the table name, but also the DOT “.” following it. You need to select the dot (.) to prevent your action removing the actual reference to the table in the FROM Clause.

Play Video

Find Form Name - In VBA Window

I can’t quite remember a particular Form Name. I don’t want to come out of the VBA window and look at the list of forms, so I use this Nifty little tip…

Play Video

Display Data from a Combo Box in a Text Box

You can display any information from a Combobox in a Textbox with this Nifty tip here. Excellent for displaying “Addresses” straight from a Combobox on your form. Makes for a very Tidy interface…

Play Video

Remove Layout View

 Get rid of Layout View! — I find layout of you particularly annoying. I like the old-fashioned way of being able to drag your controls around easily. Sometimes MS Access is just too helpful!

Play Video

Combo Boxes are numbered from 0 (Zero)

One of the gotyas when coding in VBA, and many other coding environments is that columns are often numbered from “0” up, not “1” up.

Play Video

Escape from Debug Routine

The way to escape from the debug routine is to press “Run” >>> “Reset” this shut it down.

Play Video

Ellipsis? What is it?

Ellipsis is 3 dots (…) – In MS Access it usually denotes opening another menu or information box.

Play Video

Star * as Query Criteria

Although I am generally complaining about the automatic things MS Access does which can mess up my Code, I quite like it when it helps me build the Search Criteria in a query builder grid… a* >>> becomes >>> Like “a*” —– now that’s Nifty!

Play Video

Expression Builder to Set Textbox Control Source

You can use the expression builder to put some useful code in the control source of a text box. The text box in this example displays information from a combo box

Play Video

Combo Box - Hide Columns

The combobox column width property can be used to hide any of the columns. This is useful if you want access to the information but don’t want to see it in a particular combobox.

Play Video

7874 Error - Microsoft Access cannot find the Object

I deliberately caused this error in my Beginning VBA – Video Course, and thought I would do a Nifty Tip about it.

Play Video