"Help" in Access VBA

[George Patrick]

I am having some problems with Access 2002 VBA Help.

I am NOT a VB programmer, but my manager tasked me with writing a program to
automate import text files into Access. When I wrote the original program I
was aided by the help system, I could click the examples link to see how a
function worked and there were hyperlinks in the text descriptions that led
to associated items. Very handy, it allowed me to get the job done with a
minimum of pain.

It is now a year layer, MS has issued multitudinous "fixes" to Win XP, and I
need to add some features to the program. I open up help and find that all
the example links are grayed-out and when I click a hyperlink I get an error
that tells me "This operation can only function within HTML help."

Has anyone seen this? I didn't manually change anything to stop HTML help,
how do I get it back?

TIA!

 

[TC]

It might help (no pun intended!) to know that the help files can
usually be opened independently. They all have .HLP or .CHM extensions.
Do a find, and look for likely-looking ones. I don't have Access on
this PC, so I can't suggest the names. You should find a help file for
Access, and another for Access VBA.

HTH,
TC

 

[PD.Lees]

George,

... I open up help and find that all the example links are grayed-out
and when I click a hyperlink I get an error that tells me "This
operation can only function within HTML help."

These are indications of a problem with the HTML Help ActiveX control
(hhctrl.ocx), which is commonly used to provide the link functionality
in help files. There is a good chance that something has broken the
registry entries for this control, probably because you've installed
one or more Windows service packs or Internet Explorer security updates
known to do this in certain circumstances.

What you might do is run MJ's Help Diagnostics, available from here:

http://helpware.net/downloads/index.htm#MJs

If this doesn't fix the problem, you could try re-registering the
ActiveX control from the command line. To do this, open a Command
Prompt window and enter the following two commands:

regsvr32 /u %windir%\system32\hhctrl.ocx
regsvr32 %windir%\system32\hhctrl.ocx

 

[George Patrick]

George,.

What you might do is run MJ's Help Diagnostics, available from here:

http://helpware.net/downloads/index.htm#MJs

Thanks, Pete. That did the trick

 

[Evan Pederson]

I had related but different problem. I kept getting a "An error has occurred
in a script on this page" message as the help pages were loading.
Re-registering hhctrl.ocx with MJ's Help Diagnostics did the trick. Thanks.