Where did it go? ? ?

  • Thread starter Thread starter Wayne Cusack
  • Start date Start date
W

Wayne Cusack

I am using MS Office 2000 Professional. I have been
doing a lot of programming in VBA for document templates,
forms and databases. Recently my hard drive died and I
had to reinstall on a new drive. Since then I do not
seem to have full functionality in VBA. Some commands
that I have used before just don't seem to work, and when
I try to view certain key words in the Help file there is
no explanation available. For example, if I search the
VBA Help file in MS Access for "openrecordset", all I get
is the "Welcome to Visual Basic" screen. When I run the
search for that keyword in the Help file I get a results
list that includes several other keywords - when I click
on many of them I get the same screen. The problem seems
to include references to ADO features, but does not
appear to be restricted to that. If anyone can give me a
clue as to how to recover the full VBA functionality I
will be eternally grateful.
 
When you reinstalled Office, did you do a custom install, or did you
accept the default settings? In order to have Help for VBA, you have
to do a custom install and specify that you want this. "Partial"
installs frequently seem to give the problems you describe. I find it
easiest, nowadays, to install Office with everything set to "Run from
hard disk" - it takes up a bit more space, but saves messing about.


I am using MS Office 2000 Professional. I have been
doing a lot of programming in VBA for document templates,
forms and databases. Recently my hard drive died and I
had to reinstall on a new drive. Since then I do not
seem to have full functionality in VBA. Some commands
that I have used before just don't seem to work, and when
I try to view certain key words in the Help file there is
no explanation available. For example, if I search the
VBA Help file in MS Access for "openrecordset", all I get
is the "Welcome to Visual Basic" screen. When I run the
search for that keyword in the Help file I get a results
list that includes several other keywords - when I click
on many of them I get the same screen. The problem seems
to include references to ADO features, but does not
appear to be restricted to that. If anyone can give me a
clue as to how to recover the full VBA functionality I
will be eternally grateful.
Click to expand...

Please respond to the Newsgroup, so that others may benefit from the exchange.
Peter R. Fletcher
 
I'm not sure - it's not the first time I have had to re-
install but it's the first time I have had this problem.
I normally do a custom install, but it's possible that I
didn't do it this time. I'll unload and re-install to
see if that solves the problem.

Thanks.
 
Back
Top