By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,204 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,204 IT Pros & Developers. It's quick & easy.

Getting the path of Word document in MS Access

P: n/a
Good day,

I created a form where one of its controls stores the hyperlink to a
Word document.

The form has a command button that opens the folder where the Word
documents are kept using a RunMacro command. What I want to do is to
get the path to the document and stored it in the control as a
hyperlink.

I am open to a better way to accomplish this, any suggestions?

Thank you.
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
md******@excite.com (M. Garcia) wrote in message news:<10**************************@posting.google. com>...
Good day,

I created a form where one of its controls stores the hyperlink to a
Word document.

The form has a command button that opens the folder where the Word
documents are kept using a RunMacro command. What I want to do is to
get the path to the document and stored it in the control as a
hyperlink.

I am open to a better way to accomplish this, any suggestions?

Thank you.

How about using Ken Getz's OpenFile API
http://www.mvps.org/access/api/api0001.htm

and then just write the value to a variable and then dump it into your
text field. The user will get the standard Open File dialog, which you
can filter for any file type you want.
Nov 13 '05 #2

P: n/a
pi********@hotmail.com (Pieter Linden) wrote in message news:<bf*************************@posting.google.c om>...
md******@excite.com (M. Garcia) wrote in message news:<10**************************@posting.google. com>...
Good day,

I created a form where one of its controls stores the hyperlink to a
Word document.

The form has a command button that opens the folder where the Word
documents are kept using a RunMacro command. What I want to do is to
get the path to the document and stored it in the control as a
hyperlink.

I am open to a better way to accomplish this, any suggestions?

Thank you.

How about using Ken Getz's OpenFile API
http://www.mvps.org/access/api/api0001.htm

and then just write the value to a variable and then dump it into your
text field. The user will get the standard Open File dialog, which you
can filter for any file type you want.

-------------------------------------------------------------------------------
I'm getting an error using this ahtXXX() function.
Do I need to activate a reference from the reference library? In what
part of the code I should save the path to the text field?

Thanks.
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.