VBA Help Doesn't Work

Help for VBA doesn't work correctly in my group (on several PCs).  For instance looking up help for:
 
  tabledef

Products the following list in the Select topic area (BUT MOST  ARE NOT SELECTABLE)???:
CreateTableDef Method    
TableDefs Collection    
Attributes Property      
DataUpdatable Property  
                         
CreateField Method      
Type Property            
ValidationRule Property  
                         
CreateRelation Method    
OpenRecordset Method    
ValidationText Property  
                         
OrdinalPosition Property
Delete Method            
Name Property            
FillCache Method        
                         
CreateProperty Method    
ReplicaFilter Property  
Index Property          
                         
Indexes Collection      
KeepLocal Property      
Connect Property        
                         
So, I can't get any help on these items when I click on them.  For some reason, the links don't work.                        
                         
Another example:
Hyperlinks in the text of the help that does come up, brings up a script error dialog box
schmir1Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

bdbrownCommented:
What version Access?
Try re-install?
0
AtropaCommented:
Remove then Re-install office and make sure you select all options to run your computer.  This should take care of the problem.
0
jobrienctCommented:
you really should only have to reinstall the vba help, i dont think its a corruption issue, some help files just werent installed i believe. had to do this myself a few weeks ago.

John
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

serbachCommented:
schmir1,

This happened to me. I got around the problem by copying some of the Help files to additional locations. For example, Office 2000 has compiled HTML help files in Program Files\Common Files\Microsoft Shared\Office10\1033 that include ADO210.CHM and MSJRO.CHM. I just copied them all into the Program Files\Microsoft Office\Office 2000\Office\1033 folder. Help worked right away after that.

By the way, my setup includes 3 different versions of Office in the Microsoft Office folder. You need to find the proper location for the 1033 folder on your system.

Sincerely,

Steve Erbach
Scientific Marketing
Neenah, WI
0
schmir1Author Commented:
Access's 2000 help absolutely refuses to work properly.  And the previous version's (Access97) help worked so well.  Maybe I should try Access 2002.  Anyone use that?

I uninstalled then re-installed all of MS Office Profession with no improvement.  I copy help files around until I was blue in the face, no help.

I give up.

Anyone know of any good VBA for Access Web on-line help or a book with CD?
0
schmir1Author Commented:
Was searching the web for a book and come up with a posting about my same problem.  Apparently there are a lot of people with my exact problem.

According to the solution, I am missing the file dao360.htm.   Anyone know where I can find it?  I have the complete set of Office CDs (~10) but I don't know which disk it is one or if it is compressed.
0
serbachCommented:
schmir1,

I'm sorry that copying help files to a unified location doesn't seem to be working for you. I have Access 97, 2000, and XP on my system. Before I got XP I'd had problems with Access 2000 help.

I see from my previous reply that I referred to Office10. That's Office 2002/XP which you don't have (yet). I did a search of my C: drive for all .CHM files and found them in places like:

C:\Program Files\Microsoft Office\Office2000\Office\1033
C:\Program Files\Common Files\System\ado
C:\Program Files\Common Files\Microsoft Shared\DAO
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\1033
C:\WINNT\Help

Don't give up on the location thing. I might have steered you slightly wrong with my reference to Office10, but I believe the concept to be sound.

Sincerely,

Steve Erbach
Scientific Marketing
Neenah, WI
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
serbachCommented:
Schmir1,

>> According to the solution, I am missing the file dao360.htm.   Anyone know where I can find it?  I have the complete set of Office CDs (~10) but I don't know which disk it is one or if it is compressed. <<

Hmmm, the only DAO360 help file I know of is DAO360.CHM, not .HTM.

You might try searching the registry for DAO360 and see if it's listed as HTM or CHM.

Sincerely,

Steve Erbach
Scientific Marketing
Neenah, WI
0
schmir1Author Commented:
I found it on my CD 1 (DAO.CHM not DAO.HTM).  Sorry serbach, I was really messed up.  I'm better now.

Here is a posting that I found (How he doesn't mind me posting it here):

I have found a solution by my selves.

I do not know why, but it seems that during the installation of MS Office2000 some compiled html help file are not installed! So for solving this problem:

1) for the DAO problem: just copy the files 'DAO360.CHM', 'DAO360.AW' and 'DAOREAD.TXT' from your Office CD1 (CDROM-DRIVE:\PFILES\COMMON\MSSHARED) to the directory on your Hard Disk (C:\Program Files\Common Files\Microsoft Shared\DAO).

2) for ADO problem: just copy the file 'ADO210.CHM' from your Office CD1 (CDROM-DRIVE:\PFILES\COMMON\SYSTEM\ADO) to the directory on your Hard Disk (C:\Program Files\Common Files\System\Ado).

Start MS Access again and try.

Maybe, because Win2000 has already a newer version of some dll's (f.i. the dao360.dll), the installation program thought that everything (f.i. DAO) is already installed and decided not to install the needed files. I don't know if its a problem of Windows2000 (installer) or Office2000.
So, if there are other libraries missing, try finding the help file manually.

Success.

Best Regards,

Ing. Kris Van Dijck
Belgium



0
jobrienctCommented:
like i said, you simply needed to reinstall help, and select all files in that part of the tree. i really dont think you need to go copying the files manually if you simply reinstall help and make sure that all parts are included it will install them and it will work, this was my exact experience 2 weeks ago.

John
0
schmir1Author Commented:
John,

That didn't work for me.  I reinstalled everything twice and it did no good.  Nor would it ever work because of a bug in Microsoft's installation.  

From the above message from Dijck:
-----------
Win2000 has already a newer version of some dll's (f.i. the dao360.dll), the installation program thought that everything (f.i. DAO) is already installed and decided not to install the needed files.
----------------

I did have a newer dao360.dll and I didn't have the help file (dao360.chm was missing because the installation program didn't copy it) in that directory.  So I needed to manually copy the help files to this directory and then DAO help work.  Simply as that once you know what to do.
0
jobrienctCommented:
I see. Not sure if that was my issue exactly, but I didnt reinstall everything, just the help, and i think there was some initially deselected files, Once i selected all of them it worked fine. I thought that process might have worked for you rather then just re-installing all and letting it "decide" what to leave out. in any case, you got it fixed - thats a good thing :)

John
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.