Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA/Access Help files are missing (2000/SR1)

    I've got 3 problems with help files:
    1) Some things list as topics but there's no info about them - e.g. Cancel Method(ADO).
    2) Some properties/methods don't show at all - e.g. Forms(1).SetRecord.
    3) An annoying Project 2k installation dialog pops up for other topics.

    Problems 1 & 2 happen on several machines in my office and at my home. I don't understand how we've installed it incorrectly. Any clues?

    Details on each item:
    1) Using the VBA editor in Access, a number of entries display as topics in the Answer Wizard and Indexes, but when I click on them, it doesn't take me to the topic. This is the case for almost everything for ADO and ADOX. For exmaple, if I type "ADO" in the answer wizard search, about 20 topics come up below. I click on any of them, like "Mode Property (ADO)", or "Name Property (ADO)"...nada.

    2) Example, SetRecord does not come up as a valid topic in , but this method can be used on a form object. Surprisingly, I don't see this one when searching VBA SetRecord on google either. Why doesn't this topic show at all? (here's an example of this method called in Form2 to move Form2 to the same record:
    Forms("Form1").SetRecord Me.Combo0.Column(0, Combo0.Value)

    3) This Win2K Pro machine has Office 2k Pro SR1 and MS Project. When I select some topics, it gives a installation dialog. It's my work machine, so I didn't install the software. Perhaps I just need to get the admin to install the help file??? It isn't prompting for an installation path I If I remember correctly though. I cannot remember a topic that causes this.

    Thanks for any help.
    jim

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: VBA/Access Help files are missing (2000/SR1)

    About question 2:

    Are you sure that SetRecord is not a user-defined procedure? What happens if you right-click on SetRecord (in the form module) and select Definition? If you are taken to a procedure in a module, it's user-defined. If the Object Browser opens, it's built-in. I've never heard of it, though (but then, I still use Access 97).

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

    Re: VBA/Access Help files are missing (2000/SR1)

    I've never heard of it either, and I use Access 2000.
    Charlotte

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

    Re: VBA/Access Help files are missing (2000/SR1)

    Jim.

    The Access/Office 200x help is extremely breakable, unfortunately. This appears in part to be a problem with the Windows installer and in part an artifact of html help, which isn't as wonderful as Microsoft seems to think. You need to get your admin to do a reinstall of Office or at least a repair. The ADO help files wouldn't have been installed by default if the installation was an upgrade or if the IT people did a standard installation. This issue has been discussed at length in several threads, notably in General Office Solutions, since it isn't peculiar to Access Help.
    Charlotte

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

    Re: VBA/Access Help files are missing (2000/SR1)

    <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15> I just picked up on that bit about the Project 2k installation dialog. That's a dead giveaway. Uninstall Project 2k and reboot your machine. Does Access help work now? This is definitely a Windows installer problem. I've seen it myself and been driven crazy by the fact that it sometimes *mostly* installs an application and the application will even run, but something isn't quite right. Sometimes uninstalling and reinstalling the thing several times over will eventually fix it. You can also download an updated Windows installer from the Microsoft site.
    Charlotte

  6. #6
    New Lounger
    Join Date
    Jun 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA/Access Help files are missing (2000/SR1)

    About SetRecord....Doh!! It is a user defined procedure. Don't I feel like a dolt! It was some code I wrote a while back and didn't remember it. Gee, why doesn't Microsoft document my user-defined procedures? :

    I also read Charlotte's replies to the other issues and I'll give the uninstall/reinstall a try.

    Thanks to both of you!

    jim

Posting Permissions

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