Hi Carolyn,
I'm going to cross post this to microsoft.public.access. You can pick
it up there and we can drop out of ActiveXControl.
If your users will normally be opening several Word documents, one after
another then Automation may be the best way to go. If they'll be opening
just one Word document at a time or per session then Shell () may be the way
to go.
Come to think of it, please write a paragraph or two describing what
your application is all about: its purpose, your intended audience/users,
etc. That should keep me and others who might take an interest from going
too far astray.
Automation is the name that Microsoft gave to the process in which a
client/server relationship is established between two applications that use
VBA. Usually that's two MS Office applications but there are 3rd party
applications that can also play one or the other client/server roles. Given
what you can do with Automation, the Help coverage seems terse but it went
as far as it could go without getting into application examples. In our
case, Access would be the client and Word would be the server.
Shell() is a function that can open a different program and give it the
focus.
I believe that Shell will do the job for you.
The following is an excerpt (that I've further hacked a bit) from some
help that Doug Steele posted that solved someone's Shell() problem.
>-----Altered Message-----
'You need to ensure that you've got quotes around the file names in the
string you pass to 'Shell:
Dim strAppName as string
Dim strAppendFile as string
Dim strCmdText as string
strAppName = "C:\Program Files\YourMSOffice\Office\Winword.exe"
' the above is the fully qualified path to the executable file, in
quotes.
strAppendFile = "C:\Parent Folder\Child Folder\Document.doc"
strCmdText = Chr$(34) & strAppName & Chr$(34) & " " & Chr$(34) &
strAppendFile & Chr$(34)
Call Shell(CmdText, 1)
> end of altered Message-----
The above code should go into the OnClick event of the command button
onto which you've stuck your Word icon. Be sure to surround the code with
your error handling code. Also, you need to supply or alter the code to get
the right document pathname into strAppend. Change the variable names to
suit your style.

Signature
-Larry-
--
> Hi Larry,
>
[quoted text clipped - 103 lines]
> >
> >.