We help IT Professionals succeed at work.

MS Access create end user help files

Skip Sleeper
Skip Sleeper asked
on
75 Views
Last Modified: 2019-02-02
Hi Experts,

I am finally completing my first Access application and am very confused about the best way to provide help files to end users.  My latest attempt is to create a small cmd button with the an embedded help icon and place it on controls.  These call a message box because which works great but I thought message box modality could be turned off and I would like these to be available as users interface certain controls.  The help file editors available online seem to be to overkill for my small db and there doesn't seem to be a built-in Access option to create these.  There are posts (on other forums but couldn't find any on EE) about using tables/forms with the controls' contextID, but I'm not clear if these work with F1 key on when the control has focus or does this involve the same tactic I'm now employing.  Any advice, direction or pointers would be greatly appreciated and I really appreciate your time--thank you!
Comment
Watch Question

crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015

Commented:
hi Skip,

attached is a zip with 4 files:

    Forms_With_Help_Examples_s4p.accdb
    SampleFormHelp.doc
    SampleFormHelp.htm
    ReadMe.txt

Forms with Help Examples
The Access 2007 database has 3 sample forms showing different ways to display Help using:

    HyperlinkAddress
    UnboundObjectFrame
    RichText

~crystal
Forms_With_Help_Examples_s4p.zip
Skip SleeperIT Manager

Author

Commented:
Hi Crystal,

Thank you for the insights and samples!  In the textbox example, would the HelpID=1 refer to a control's help context ID?  How would this typically be called (e.g. F1, icon cmd button)?  Thanks!
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015

Commented:
you're welcome, Skip.

Attached is another example. It uses an AutoKeys macro to define the F1 key to open the Help form, which is filtered for a specific topic. A tempvar is used for the HelpID. Look at the code behind the TEST form to see how the HelpID can be changed. I used command buttons to change the help topic -- but you might want to use GotFocus to set a specific topic and LostFocus to set it back to general form help.

AutoExec macro: automatically executes when application is opened. Set HelpID to 0 (for general application help)

AutoKeys macro: defines F1 key

form Open defines general help for form
form Unload sets help back to 0

I think this is easier to manage than using built-in Help

~crystal
HelpFormPopup_AutoKeys_F1_s4p.zip
Skip SleeperIT Manager

Author

Commented:
Hi Crystal,

Just to clarify, the TEST form would list all the help topics when called by F1?  And does the HelpID correspond to the helpContextID of controls or this not even used?  What do mean by "built-in" Help?  Lastly, do you think the memo fields increase DB size dramatically as an application grows?

Thanks!
Skip
Remote Training and Programming
CERTIFIED EXPERT
Top Expert 2015
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Mark EdwardsChief Technology Officer
CERTIFIED EXPERT

Commented:
For what it's worth, I don't use help files (too much work to create and maintain).  I just create a word document "users manual" that I export to .PDF and then open with a button click using FollowHyperlink() function.  Any time a modification needs to be made, just make it in your Word .docx and export to .PDF again...

Simple and it works beautifully.....
Skip SleeperIT Manager

Author

Commented:
Thank you Crystal and Mark--got a lot to think about!
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
CERTIFIED EXPERT
Top Expert 2015

Commented:
you're welcome, Skip ~ happy to help

Mark's idea to maintain Help in Word bears consideration and is a helpful comment ...  even if what you do is copy and paste into Access. It is easier to format text in Word.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions