Help

Tieval

Still Clueless
Local time
Today, 22:59
Joined
Jun 26, 2015
Messages
475
Help - Literally

Can anybody advise best ideas for creating user help in an access database, I just want to be able to offer help at any time and can obviously put buttons everywhere which pop-up individual forms with all the details in them but there must be a better way.
 
Last edited:
'a better way' really depends on how your front end works in the first place and is down to your imagination.

Suggestions include using a popup form, a label, a text control, a hyperlink or a subform. Or you might open a word or text document, with or without navigation to the appropriate point in the document or open the web browser to open a specific html file.

You could put a help table together with a memo field to enter your help text plus a field to indicate which form the help applies to and base your popup on that table. Or you could store the help text in a html, word or .csv file, either one file per form, or one file per app with navigation to form

And don't forget the control controltiptext and validationtext properties can be used and written in a way to help the user

I'm sure there are other ideas out there
 
Last edited:
Hi CJ,

Many thanks for this, I was thinking of going all the way and using a .chm file but was wondering if anybody can explain how to associate one with it.

What I would like to do is allow a user to press F1 at any time and get useful help rather than the standard access help.

I have googled all this and can't claim to be any clearer on how to integrate it into Access 2013 or 2016.
 
Thanks again, I have a .chm file and can use it happily independent of access.

Does anybody know how to call one as I have searched google and found loads of different options but am not sure what will work on Windows 10 using Access 2013 or 2016.

It seems that whatever I do I end up with the standard access help file.
 
so the HTMLHelp API in the link I provided doesn't work?

Suggest you list what you tried that doesn't work
 
Hi CJ,

In a word, no.

To start with it is a 32bit function and I am using 64bit so I am going to have to think some more, that is the first line so I may have a bit to do. This is why I was asking if anybody knew more about this sort of thing as I can see this was designed for 97 and is 32 bit before I even start.
 
you just change

Private Declare Function...

to

Private Declare ptrSafe Function....

and Long to LongPtr if required - to determine which longs to change understand what that particular api does/requires in parameters

LongPtr will convert to Long for 32bit and LongLong for 64bit. Again, google to find out more.

good luck with your project but don't think I can provide any more help
 
No problem, many thanks for the help.

Will publish back if I get something fully functional but I do want to work it step-by-step, I hate pasting other people's code without fully understanding it.
 
Depending on HOW MUCH help you want, it is tedious, but the TOOLTIP property can be helpful in this context. You only get one sentence, but it might often be enough for your forms.
 
Here is a help system designed within MS-Access. http://www.projectperfect.com.au/microsoft-access-sample-8.htm

I was able to modify it to work off of combo boxes as well as from a button and they would be context sensitive based on what was in the combobox or in the case of the button a form would pop up with a combo box there for user to choose which help to bring up.
 
Thanks for this, but I am a little confused. I can see a way to generate like the example as forms that pop-up, I can also see ways to generate things in VBA but both these methods are labour intensive.

Looking at an access form in 2013 you have options to set "Help File" and "Help Context ID" for the form and can therefore use a .chm file (the help file) and open it at the details for that form (the help context ID). I can therefore generate a full help file for the application and theoretically open this file at any time on the relevant information.

The only thing that doesn't seem to be documented anywhere is how to call it.
 
The only thing that doesn't seem to be documented anywhere is how to call it.
have you tried hitting the F1 key which is the standard key for help?
 
Tried that, it just loads standard help whatever you do.
 
Many thanks again, Minty but this is very useful for Excel.

I guess the real issue here is that I am trying to save time.

There are hundreds of ways to do this using a set of forms, control tips or VBA loaded information.

What I would like is to take a user manual saved as a chm file and each form just to reference the chm file and the relevant section in it.

Normally I try to be conservative with my dreams and accept that certain things just cannot happen but in this case I can see that access is designed to do it but for some reason won't.
 
There is such a thing as having a word document with bookmarks for your various topics and then having each form have a help button that can call a routine to open a Word document in read-only mode and tell it, once opened, to do a .GoToBookmark (and of course, name the bookmark.) Don't need a .HLP or other file type.

The old style of help operation with separately compiled .HLP or .HLB files hasn't been supported very will in a while, perhaps precisely because bookmarking can be so useful.

Just as a thought to consider how far you could take this, you can define certain controls to accept a right-click as a help call. That would allow you have help topics down to individual control levels, and these right-click event routines could each have their own individual bookmarks in the Word document if you wanted to take it that far.

In such calls, it might be a single line for each click event, where the line is to call some common subroutine with a single text argument that is the named bookmark. You would have to look up manipulation of word application objects to:

1. Create the word app object
2. Using the object, open the help document in read-only mode
3. With the open document, do a "Go To Bookmark" for the supplied text
4. You might have to play with some windows calls to force the document to the top (bring it to the front)
5. When your user is done reading, they can close that window, which closes the file but doesn't close the Word App Object
6. Just be sure to remember to close the Word App Object when you close your Access application.
 

Users who are viewing this thread

Back
Top Bottom