Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Certain Help Topics not available in VBA

    For some reason I just can't locate help in Access VBA
    (VERSION 2000 Developer SR1) for certain topics, eg when I look up "OpenRecordset" or hit F1 while on OpenRecordset in code. I get an error message saying that this function is no longer functioning properly and would I like to repair it by inserting original CDs. But doing the latter does not change anything. The particular topics that don't have help associated with them seem to be mainly DAO topics. Now I'm sure they USED TO WORK when I was running everything on Windows98 but they stopped when I switched to Windows2000.
    I was using the same version of Office on both operating systems. Can anyone suggest what can be done? I have yet to find a substitute elsewhere for these missing help files that gives as clear and succinct information.[img]/w3timages/icons/clever.gif[/img]

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Certain Help Topics not available in VBA

    It sounds like your Help installation is incomplete or damaged. Have you tried reinstalling Windows and making sure all the relevant help files are selected for installation? The DAO functions are included in the normal help for Access, since DAO is the object model Access 2000 itself uses, even though the default object model for data is ADO.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Certain Help Topics not available in VBA

    Thanks Charlotte for your ideas. I think you may be right but I don't know whether I can re-install Windows 2000 over the existing installation without it wanting to format the partition, which would not be desirable. I seem to recall it differs from Win 98 in this fact. In the meantime I have found some alternative help (of sorts) in the MSDN library but it is not as straightforward to use.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Certain Help Topics not available in VBA

    ...alternatively, check your O2K installation to (re)install the help functions (grabbing at straws here0.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Certain Help Topics not available in VBA

    No, no! It's the Office help that needs reinstalling. Not the Windows help.
    Charlotte

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Certain Help Topics not available in VBA

    Oh, right, well I did de-install then re-install the Office Help files but with no apparent difference. Also, I do think this is some sort of (perhaps intentional?) bug with or effect of Windows 2000 as I have now checked another computer which had a separate installation of Win 2000 and Office 2000 and EXACTLY the same help topics are missing as are missing on my own computer. To prove it to myself I might set up another computer with Win 98 and Office 2000 and see if the behaviour is the same. Ah, the scientific method: it's effective but it's tedious...[img]/w3timages/icons/spook.gif[/img]

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Certain Help Topics not available in VBA

    RORY WROTE IN THE VBA FORUM

    This is what you call a delayed response, but, just in case you're still

    getting blank help pages or errors when you try and look up ADO information,

    here's how I fixed it:
    Copy the files
    msjro.chm and
    ado210.chm
    from the PfilesCommonSystemADO directory on your Office installation disk

    into
    Program FilesCommon FilesSystemADO (usually on C
    as documented by Microsoft. I then additionally had to open up the registry

    and add a string value to HKLMSOFTWAREMicrosoftWindowsHTML Help
    called
    ado210.chm
    and with a value of
    C:Program FilesCommon FilesSystemADO
    and now my help files function properly!
    It's apparently because Windows2000 comes with MDAC2.5 (which doesn't

    include these help files) so when you install O2k, which comes with MDAC2.1

    (which does include the help files) the installer sees that a later version

    of MDAC is installed and doesn't bother installing any of its files.
    Hope that helps.

    DAVIDHIT REPLIED

    My reply is slightly tardy too as I have just returned from a holiday in

    France wishing I were still there...
    Your reply is the only one that has hit the nail on the head! Yes it works

    and my first suspicion that it is Windows 2000 that messed up the HTML help

    of
    Office 2000 proves to be correct. Others kindly replied with surmises and

    general answers which weren't correct but your solution is apposite and

    right to the point! Thanks!
    The wonder is that so few have stumbled on this defect
    (it is an outright error) of Win2000 not installing the full Office 2000

    help files. I personally find the Visual Basic help really useful in

    devising solutions and it was annoying me to have to leaf through textbooks

    to dredge up the answers. Now ADO (help) works fine.
    Moreover I have made a few changes to your ADO solution to come up with one

    that gets DAO 3.6 help working too (which also didn't function correctly).
    Copy the file DAO360.CHM from the Office installation disc found in this

    location:
    PfilesCommonMSSHAREDDAO
    to
    Program FilesCommon FilesMicrosoft SharedDAO
    (usually on C
    and edit the registry key dao360.chm
    (it was already there in my setup, otherwise create it)
    in
    HKLMSOFTWAREMicrosoftWindowsHTML Help
    ensuring the string value is
    C:Program FilesCommon FilesMicrosoft SharedDAO
    Reboot and BOB'S YOUR UNCLE!
    Now, are there are other sections apart from these two
    that don't work for similar reasons AND will the issue
    be all fixed up in OfficeXP?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •