Access VBA

[Guest]

hello, when i call from access a word document and i close it. it retuns a
message "An unexpected error has occurred". Anyone can tell me how i
eliminate that.
Regards
Carlos

 

[Douglas J. Steele]

What code are you using to open the document and to close it?

 

[Guest]

to open word doc i use:

Command24.HyperlinkAddress = recordsetx.Fields(0)

to close word doc i don't have any code

 

[Douglas J. Steele]

If you open the Word document normally (i.e.: not from within Access) and
close it, does it close without error?

 

[Guest]

yes. it close without error

If you open the Word document normally (i.e.: not from within Access) and
close it, does it close without error?

 

[David C. Holley]

Douglas -

So what are the advantages of using this method, as opposed to creating
an instance of Word using CreateObject, opening the file and then
displaying it? I'm assuming that 1 of the advantages is that Access will
look at the file extension and open the correct application? Are there
others?

 

[Douglas J. Steele]

Using a hyperlink lets you open the document in its registered program, and
nothing else.

Opening an instance of Word using CreateObject lets you use automation on
the document.

Which is better depends on what you're doing.

 

[Douglas J. Steele]

Do other documents have this same problem if you open them from within
Access and then close them?

 

[Douglas J. Steele]

Just realized this isn't strictly true.

If you open the document using the hyperlink, you can always get a reference
to that instance of Word using GetObject, and then use automation that way.

 

[Alex Dybenko]

Hi Carlos,
I would recommend you to use shellexecute API instead of FollowHyperlink
method:
http://maug.pointltd.com/access/Queries/TipDetail.asp?TipID=5