link to image file

P

Peanut1

i have an Access 03 shared application. I have a field in a table for a
hyperlink. on a form based on that table, i want the user to be able to
easily insert a link to a pdf file that resides on a shared server location.
when they click in the pdf link field, i want the windows file browser box to
come up so they can just find and select the file. is there some sample code
for this someplace?
 
L

Larry Linson

Peanut1 said:
i have an Access 03 shared application. I have a field in a table for a
hyperlink. on a form based on that table, i want the user to be able to
easily insert a link to a pdf file that resides on a shared server
location.
when they click in the pdf link field, i want the windows file browser box
to
come up so they can just find and select the file. is there some sample
code
for this someplace?
Click to expand...

http://www.mvps.org/access/api/api0001.htm has code to use the Windows File
Open/Save dialog.

Larry Linson
Microsoft Access MVP
 
P

Peanut1

thank u, but thats an awful lot of code, and i suspect not all of it applies
to my situation- which part do i use? i just want the field to store the link
to the selected pdf file, not to open the pdf file.
 
L

Larry Linson

thank u, but thats an awful lot of code,
and i suspect not all of it applies
to my situation- which part do i use? i
just want the field to store the link
to the selected pdf file, not to open
the pdf file.
Click to expand...

How much code is too much to copy and paste? When I first used that code, I
copied it, pasted it into a module in my database, modeled my code to use it
on the sample given, and it worked first time out of the chute.

The Windows Common Dialog Control, accessed via that code, is to allow the
user to _select_ a file's path, name, and extension. That's what it does,
and returns that fully-qualified-path-file-and-extension to you. What you do
with the text string that is returned is up to you.

(If you'd rather use an ActiveX control, that would hide the code from you,
but wouldn't mean less code, and you'd have to find one, and you might have
to pay for it.)

Larry Linson
Microsoft Access MVP
 
P

Peanut1

ok, thank you very much i will try it


Larry Linson said:
How much code is too much to copy and paste? When I first used that code, I
copied it, pasted it into a module in my database, modeled my code to use it
on the sample given, and it worked first time out of the chute.

The Windows Common Dialog Control, accessed via that code, is to allow the
user to _select_ a file's path, name, and extension. That's what it does,
and returns that fully-qualified-path-file-and-extension to you. What you do
with the text string that is returned is up to you.

(If you'd rather use an ActiveX control, that would hide the code from you,
but wouldn't mean less code, and you'd have to find one, and you might have
to pay for it.)

Larry Linson
Microsoft Access MVP
Click to expand...
 
Top