Prev: Import multiple forms, queries from another database
Next: How to update underlying file
From: johnlute on 28 Jan 2010 13:49
Add a field to your table and select "Hyperlink" as its data type.

Add a text box control to your form that has this new field as its
record source.

Insert a hyperlink into the control via the toolbar: Insert >
Hyperlink... then browse to your file that you want to link to.

> Thank you. I have one pdf for each specimen so I think it would be good if I
> just store the reference in my table.
> can some one give me an example of how I can create the hyperlink?
From: mls via AccessMonster.com on 28 Jan 2010 14:43
Thank you. It's very helpful
johnlute wrote:
>Add a field to your table and select "Hyperlink" as its data type.
>
>Add a text box control to your form that has this new field as its
>record source.
>
>Insert a hyperlink into the control via the toolbar: Insert >
>Hyperlink... then browse to your file that you want to link to.
>
>> Thank you. I have one pdf for each specimen so I think it would be good if I
>> just store the reference in my table.
>> can some one give me an example of how I can create the hyperlink?

--
Message posted via http://www.accessmonster.com

From: Jack Leach dymondjack at hot mail dot on 28 Jan 2010 16:10
just for the record, I personall avoid the hyperlink field, and instead store
just the path of the file. The hyperlink datatype has a lot of extra baggage
that goes along with it, and becomes quite troublesome when you start copying
files around with code.

I would recommend storing a regular text path instead, then you can use the
"IsHyperlink" property of a control to get it to "act" as a hyperlink, or
include the following on the click event:

Application.Hollowhyperlink Me.Controlname


hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)



"mls via AccessMonster.com" wrote:

> Thank you. I have one pdf for each specimen so I think it would be good if I
> just store the reference in my table.
> can some one give me an example of how I can create the hyperlink?
>
>
> Mark Andrews wrote:
> >Access2007 yes easy just add an attachments field, then on the form you
> >easily get all the bells and whistles to browse for and add the file. You
> >can also use code to automatically add or remove attachments in access 2007.
> >However I agree, LARGE amounts of file storage should always be done outside
> >of the database (no matter what version of Access). An attachment here or
> >there in Access2007 is just fine.
> >
> >Mark
> >RPT Software
> >http://www.rptsoftware.com
> >
> >>I am using ACCESS 2000 and checking to see if I can store .pdf file in the
> >> same table where I store my test results. If so how I can I do that?
> >>
> >> If not in ACCESS 2000 is it possible with ACCESS 2007?
> >> Thanks
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201001/1
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Import multiple forms, queries from another database
Next: How to update underlying file