Spell Check w/o Word loaded doesn't seem to work

[JWS315]

I have a user that does not have any Office products loaded. I install Access
Runtime 2003 when my software is installed and use the following code snipet
to check spelling, however I am able to enter misspelled word and the code
does not catch it. I have tested on machine that has Word installed and it
works fine.

With Forms!roadmap!txtroledesc
.SetFocus
.SelStart = 0
.SelLength = Len(.Text)
End With

DoCmd.RunCommand acCmdSpelling

Has anyone run into this problem and has a possible work around?

Jerry

 

[Douglas J. Steele]

You'll have to find another spell checker, I'm afraid. The Runtime license
does not include a license for the Proofing tools.

 

[JWS315]

Doug,
Thanks for the quick response - Arrugh! Not what I wanted to hear but I am
not surprised. Do you have any recommendations that will work in the
envirnoment mentioned?

Jerry

 

[Douglas J. Steele]

Sorry, I'm afraid I don't know the names of any (although I'm sure there are
some).

 

[JWS315]

I tried installing a trial version of Office 2007 which has Word included
thinking that it would then allow me to use spell check, however it doesn't
seem to help. I changed DoCmd.RunCommand acCmdSpelling to DoCmd.RunCommand
(269) but no luck. I did notice in object browser that when you look up
acCmdSpelling that it references Access libarary which would lead me to think
that it should work.

I do have references to Office 11 Word library, not sure if that needs to be
changed/removed?

Thanks for any help!
Jerry

 

[Douglas J. Steele]

Why do you have the reference to Word? That'll guarantee that your
application won't work at all when installed on machines that don't have
Word installed.

If you install the "regular" version of Access, the proofing tools come
along for free, and no other reference should be required. It's just
installing the runtime version where there's an issue, because the runtime
doesn't install the proofing tools. I'm not sure that you can use the
proofing tools from a newer version of Office (for that matter, I'm not sure
you can use the proofing tools from an older version of Office either)

 

[JWS315]

I use automation to create Word documents from Access data for users that
have Word installed. I think I have had users with Word 2002 installed and
Access 2003 Runtime where spel check worked, not sure I have run into the
opposite where users have a later version of Word.

So the proofing tools are installed as part of an Office installation and
can not be installed seperately?

I guess I will need to look into other spell checkers that can be referenced
by Access Runtime.

Thanks for the help!
Jerry

 

[Douglas J. Steele]

AFAIK, the Proofing tools from Microsoft can only be installed as part of
Office.

Note that if you've got a reference set to Word, your application is not
going to work for users who don't have that same version of Word installed.
(And I mean really won't work, as opposed to just the part about creating
Word documents!) Consider using Late Binding so that you can remove the
references. Tony Toews has an introduction to the topic at
http://www.granite.ab.ca/access/latebinding.htm

 

[JWS315]

Thanks for the heads up on the Late Binding, most of everything I do is
similiar to Tony's example Dim wdapp as Object so I probably don't need the
references any more.

Thanks for all your help and insights!
Jerry