Access 2000 help files

[santashelper]

When I highlight a phrase in the visual basic editor and hit F1 a msg. comes
up stateing that the feature is not working properly would I like to repair
it. When I click yes it goes through the proces to repair it but when I try
it again after reboot it does the same thing. How can I get the help to
work? The phrase is "openrecordset" (DAO).

 

[strive4peace]

you must reference a DAO Object Library to get help from it

Tools, References, scroll to Microsoft DAO 3.6 Object Library and check it

you didn't compile your code, did you? ... <g>

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code, references, or switch versions, you should
always compile before executing.

from the menu in a VBE (module) window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

~~~

if this still doesn't get help, try using the Object Browser instead.
Look in Chapter 5 of Access Basics for more information

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace


Warm Regards,
Crystal


*
have an awesome day
*

 

[santashelper]

I have referenced the dao library and compiled my code. I have been writing
code for several years. I recently had to reload XP premium SR1 and the
updates through SP3 plus all the applacations . Ever since then the help
files do not work. Also If I try to run an open recordset statement it says
I have a wrong type.

Example:

Sub xx
dim rs as recordset

set rs= currentdb.openrecordset ("tblchili",dbopentable)
rs.close
exit sub

 

[santashelper]

Sorry I miss stated the operating system in the previous post. It should be
Windows XP Home Edition 2002 (original OEM). The Access is Microsoft Office
2000 SR1.

....................................................................................................
I have referenced the dao library and compiled my code. I have been writing
code for several years. I recently had to reload XP premium SR1 and the
updates through SP3 plus all the applacations . Ever since then the help
files do not work. Also If I try to run an open recordset statement it says
I have a wrong type.

Example:

Sub xx
dim rs as recordset

set rs= currentdb.openrecordset ("tblchili",dbopentable)
rs.close
exit su
.............................................................................................

 

[strive4peace]

Hi (what is your name?)

"dim rs as recordset"
"Also If I try to run an open recordset statement it says I have a wrong
type"

aha!

do this:

dim rs as DAO.Recordset

Recordset is a member of DAO as well as ADO -- so if both libraries are
in use, you must be more specific


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[santashelper]

Still get a type mismatch on the openrecordset. The libraries are there but
no help files. I have tried uninstallling Office 2000 Premium and
reinstalling it several times with the same results. I am wondering if it
makes a difference about installing the XP updates. I installed all of the
XP updates before I installed Office 2000 Premium.

 

[strive4peace]

Did you try getting to Help through the Object Browser?

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[santashelper]

The object browser does show me the DAO library enties. Like I stated the
libraries are there and are referenced but they do not work when executed. A
search of the C: dive for .chm files showes no DAO or ADO help filfes. There
are help files in C:\program files\Microsoft Office\Office\1033. There is no
a\ACcess folder in C:\Program files\Commonfiles.

 

[santashelper]

I copied the DAO360.chm file from the Office 2000 Premium SR1 disk to
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\1033 and the F1 key
now finds the DAO help information. Looks like the Office 2000 Premium Sr1
install is not completely installing everything even though it says it does.
Even tried going to Add/Remove programs (after deleteing the DAO360.chm from
the c drive) and changing the Access Help to run all from my computer with no
success. Why would Office not install completely?

 

[strive4peace]

Hi (what is your name?)

if you uninstalled and did a clean install then ...
that I cannot answer ...

Warm Regards,
Crystal

*
have an awesome day
*

 

[strive4peace]

if you know where the Help file is, you can double-click it to open it
directly.

Warm Regards,
Crystal



*
have an awesome day
*

 

[santashelper]

Yes but that does not get the libraraies to execute the code. Why would they
not execute?

 

[strive4peace]

Hi Steve (is that your name?)

What reference libraries do you have checked?

What happens when you compile the code? If it does not compile, that is
why code is not being executed

'~~~~~~~~~ Compile ~~~~~~~~~

Whenever you change code, references, or switch versions, you should
always compile before executing.

from the menu in a VBE (module) window: Debug, Compile

fix any errors on the yellow highlighted lines

keep compiling until nothing happens (this is good!)

~~
if you run code without compiling it, you risk corrupting your database

~~~~~ also be sure to use Option Explicit at the top of each module


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[santashelper]

I do not mean to be rude but why are you rehashing things we have already
been through. Please refer to the previous posts. My Access did work before
I reloaded XP and all the applacations. Now it seems Access is not
completely reloading everything and I do not understand why. Has Microsoft
done something in the XP updates to cause the installation of Officr 2000
Premium SR1 to not install completely even though it says it does?

 

[strive4peace]

Best of luck to you, I hope you find your answers.

Warm Regards,
Crystal


*
have an awesome day
*