Access VBA help files

[Malcolm]

Hi,

I have Office 2000 Premium running on Windows 2000 with
which I have been self teaching access database
programming. I recently had to get another pc, and I just
can't seem to get the installation right.

My problem is in the help files, particularly for VB (Or
at least this is what I'm trying to use). Many of the
links found when a topic is searched, with the answer
wizard or index, just go nowhere. They are common links to
properties / methods etc... that I have used before on the
other pc.

I saw somewhere (Can't remember where) that if a custom
installation is done from start that this can effect some
help files. So I just totally removed Office, did a
typical install, then added the entire cd to my pc, did
all the Office updates from Microsoft, and STILL have the
same problem.

A search of MS web sites reveal nothing. Can anyone offer
some help? Since I am learning a lot of this stuff on the
run, I rely pretty heavily on help files.


Thanks in advance.


Malcolm

 

[Pete Lees]

Malcolm,

...
My problem is in the help files, particularly for VB (Or
at least this is what I'm trying to use). Many of the
links found when a topic is searched, with the answer
wizard or index, just go nowhere. They are common links to
properties / methods etc... that I have used before on the
other pc.

This sounds like the problem described in Knowledge Base article
822989 (http://support.microsoft.com/?kbid=822989), in which case the
solution is either:

1) If you've yet to install Service Pack 4 (SP4) for Windows 2000,
apply Critical Update 811630, which is available from here:

http://support.microsoft.com/?kbid=811630

2) If you *have* installed SP4, unregister and then re-register the
HTML Help ActiveX control by running the following two commands from a
command prompt:

regsvr32 /u <drive>:\winnt\system32\hhctrl.ocx
regsvr32 <drive>:\winnt\system32\hhctrl.ocx

Some background on the problem, if I have diagnosed it correctly: the
chances are that the registry entries for the HTML Help ActiveX
control are broken. This control is used in many help files to provide
links from one topic to another. A number of the security patches and
service packs that Microsoft released last year are known to cause
this problem, including the cumulative security patches for Internet
Explorer and service pack 4 (SP4) for Windows 2000. Applying Critical
Update 811630, or unregistering and then re-registering the control in
the case of Windows 2000 SP4, should fix the broken registry entries.

 

[Malcolm]

Hi Pete,

Thanks for the response. Still no luck. I am running SP4
already, and in fact all Win 2000 / Office 2000 updates
available have been applied.

I tried the critical update for the ie help by itself, as
well as de- and re-registering the hhctrl activex control,
restarted the pc, and no luck.

As an example if I type 'recordset' into the Access vba
help index, I get a bunch of possible links. The first 4
(Source property, Delete method, Clone method and
Recordsets collection) go nowhere. The next 2 items
(Recordsets property example and Recordset Property)
works, and so on.

I appreciate the ideas so far and look forward to any
others you may have. Is there supposed to be a special
sequence for removing / reinstalling Office other than
add/remove programs? Would this help?


Regards

Malcolm