Nifty Help System

Nifty Help System

There are many ingenious ways to offer help to your MS Access Application user. One of the simplest ways is to store the help information in the table. But it’s not so simple because every place that you want to provide help, you will have to add the code to open the help form, and also provide the individual ID reference to the help record associated with the control/place on your form that your user will benefit from some help. It’s a nightmare to run a help system like this, and if you have several forms, switching back and to, to the table to find out which is the next available help ID number, well it gets a bit tiresome. However this here is an easy solution to the problem.

There is a YouTube video by way of explanation here:-

There’s a downloadable example database

Help System For MS Access

Help System For MS Access

Video 1 (3:25)

Here is a run through of the Help System in operation. the “Nifty Access Help System” uses an MS Access Table, an MS Access Form and utilises the “Nifty CallCalled Class Module” to extract information from the Calling Form.

Video 1 (3:25)

Nifty Access YouTube Thumb Nail
Play Video

… …

Wire Up Multipe Controls to a Function

Wire Up Multipe Controls to a Function

Video 2 (3:21)

In this video I demonstrate a useful trick where you can Call the same Function from lots of controls in your MS Access Database. The beauty of this method is you can wire up numerous controls within seconds. It’s a very useful – Nifty – MS Access technique…

Video 2 (3:21)

Nifty Access YouTube Thumb Nail
Play Video

… …

Access Help System - SETUP!

Nifty Access Help System - SETUP!

Video 3 (7:45)

A matter of “10-minutes” – that’s all it takes to setup this “Nifty Help System!” Now, you’ve got to enter in all the help information – that’s not going to take 10 minutes is it! Best of Luck!

Video 3 (7:45)

Nifty Access YouTube Thumb Nail
Play Video

… …

MS Access HELP - PopUp on MouseOver

Help System - PopUp on MouseOver

Video 4 (1:38)

FarZ recently made an excellent observation about the Nifty Access – Help System. The problem for FarZ was that he already uses the double click event for something else. He wondered if it would be possible to pop-up the help with a hotkey and and MouseOver… I searched the internet for ideas and I found these two blogs which provided some excellent information:- How to code “Mouse Over” effects for MS Access <<< And >>> Form.KeyDown event (Access) With this information I was able to to create a solution for FarZ. I have Incorporated the solution into the the Nifty Access – Help System… Which can be downloaded from Sellfy HERE:- Help System for MS Access If you prefer the free option, then the above links should give you enough information for you to be able to recreate this solution for yourself.

Video 4 (1:38)

Nifty Access YouTube Thumb Nail
Play Video

… …

Leave a comment