Connecting Tech Pros Worldwide Forums | Help | Site Map

Opening MS Word File from Access Form

Tony Schoeffler
Guest
 
Posts: n/a
#1: Nov 12 '05
I have an Access application where it would desirable to open a word
file directly from an Access Form. I have been able to open the Word
application, but I have not been able to have it open with the desired
file. Any help or sample code would be appreciated.


Dean Covey
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Opening MS Word File from Access Form


In your table, create a field for hyperlinks. Populate that field
accordingly and make it available on the approriate form.

--
Dean Covey
www.coveyaccounting.com

MS-Office Certified:
http://www.microsoft.com/learning/mc...st/default.asp

"Tony Schoeffler" <Hugh.A.Schoeffler@lerc.nasa.gov> wrote in message
news:c5p61s$pje$1@sulawesi-fi.lerc.nasa.gov...[color=blue]
> I have an Access application where it would desirable to open a word
> file directly from an Access Form. I have been able to open the Word
> application, but I have not been able to have it open with the desired
> file. Any help or sample code would be appreciated.
>[/color]


Mike Preston
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Opening MS Word File from Access Form


On Fri, 16 Apr 2004 20:44:28 GMT, Hugh.A.Schoeffler@lerc.nasa.gov
(Tony Schoeffler) wrote:
[color=blue]
>I have an Access application where it would desirable to open a word
>file directly from an Access Form. I have been able to open the Word
>application, but I have not been able to have it open with the desired
>file. Any help or sample code would be appreciated.[/color]

Post the code you have used to open Word. Usually, all you need to do
is add to the documents collection of the Word object. For example,
if you used:

Dim objWord as object
Set objWord = CreateObject("Word.Application")
objWord.visible = True
objWord.documents.open "c:\mydirectory\myworddocument.doc"

mike

Closed Thread