How to add document found to hyperlink url

[Preston via AccessMonster.com]

I have a hyperlink "url" which points to where internet document files are
stored. However, I don't know the name of the actual documents until I get
to the path and then click on the document that I want.

How do I code to pick up the document name and "ADD" it to the url path so
that the next time someone clicks on the hyperlink it takes them directly to
the document and opens the document?


Any suggestions or help appreciated.

Thanks,
Preston

 

[Guest]

Check out the hyperlinks form that demonstrates how to accumulate all the
files and pile them into a hyperlinks field listbox. You can click on the
file and access the information you wish...

URL: http://www.emrupdate.com/files/folders/al_borges/entry58232.aspx

Cheers,
Al

 

[Preston via AccessMonster.com]

Hi,
I've stored a part of the path to the website in a table of 4-urls. The
combo box has 4-options. So, after update of the combo box if the selection
is turnbox, the http link from the table points to the turnbox website where
the documents are. My problem is that once I'm in the website I need to
click on one(1) document from a list of documents. Then have that document
open, and then the path which includes the document name, to store the full
path back into Access as a hyperlink in the field named txtpic.

Each time it could be a different document to attach. This is necessary so
that the next time the user clicks on the field txtpic, it will open up the
document from the full path at the website.

Can anyone help me with code to do this?

Thanks,
Preston

Check out the hyperlinks form that demonstrates how to accumulate all the
files and pile them into a hyperlinks field listbox. You can click on the
file and access the information you wish...

URL: http://www.emrupdate.com/files/folders/al_borges/entry58232.aspx

Cheers,
Al

I have a hyperlink "url" which points to where internet document files are
stored. However, I don't know the name of the actual documents until I get

[quoted text clipped - 8 lines]

Thanks,
Preston

 

[Guest]

Hi :

Check out the following entry by noneother than Dev Ashish-
(URL:
http://groups.google.com/group/micr...9cfc5d3ea5e/a7efee22d42c2f0a#a7efee22d42c2f0a)

------------------ begin -------------------

Hi Johan,

To add to Radu's post, doing this the API way would require us to use some
typelibs that provide VBA friendly Interfaces. It's much easier to just
open the URL file with VBA's OPEN and read the url manually. Look for this
section


[InternetShortcut]
URL=http://www.rinkworks.com/dialect/


Also, you can use GetPrivateProfileString and other INI file functions to
read this more easily. Ken Getz wrote just such code for Informant, you can
try to get that particular article/code at < http://www.officevba.com >.


-- Dev

------------------------ end ----------------------------

He's the author of the great read- Access Developer's Handbook as well as
has coauthored numerous other Access books. Heck, there is an FTP Utility
that he has put out; check out the discussion here on how to use it to
download files-

http://groups.google.com/groups/pro...AD9ZbAXGSSz2AvWzFhTqmeh8rhlH0Pnl47z4AZhN98BFg

http://groups.google.com/group/comp...75996838876/2d31aa8d3ca02188#2d31aa8d3ca02188

Good luck, seems tough...

Cheers,
Al

Hi,
I've stored a part of the path to the website in a table of 4-urls. The
combo box has 4-options. So, after update of the combo box if the selection
is turnbox, the http link from the table points to the turnbox website where
the documents are. My problem is that once I'm in the website I need to
click on one(1) document from a list of documents. Then have that document
open, and then the path which includes the document name, to store the full
path back into Access as a hyperlink in the field named txtpic.

Each time it could be a different document to attach. This is necessary so
that the next time the user clicks on the field txtpic, it will open up the
document from the full path at the website.

Can anyone help me with code to do this?

Thanks,
Preston

Check out the hyperlinks form that demonstrates how to accumulate all the
files and pile them into a hyperlinks field listbox. You can click on the
file and access the information you wish...

URL: http://www.emrupdate.com/files/folders/al_borges/entry58232.aspx

Cheers,
Al

I have a hyperlink "url" which points to where internet document files are
stored. However, I don't know the name of the actual documents until I get

[quoted text clipped - 8 lines]

Thanks,
Preston