HI,

I currently have an access DB set up with many records. Each record has some
associated word or excel files. I was wondering if there was anyway to link
these files to my access DB record. Can you save these files or paste them to
the record in access? Please help!!

Will a hyperlink do it for you? Access has a DataType for hyperlink.
--
KARL DEWEY
Build a little - Test a little


"Acekid09" wrote:

> HI,
>
> I currently have an access DB set up with many records. Each record has some
> associated word or excel files. I was wondering if there was anyway to link
> these files to my access DB record. Can you save these files or paste them to
> the record in access? Please help!!

"Acekid09" <(E-Mail Removed)> wrote

> I currently have an access DB set up with many records. Each record has
> some
> associated word or excel files. I was wondering if there was anyway to
> link
> these files to my access DB record. Can you save these files or paste them
> to
> the record in access? Please help!!

The sample imaging databases at http://accdevel.tripod.com illustrate three
approaches to handling images in Access, and the download includes an
article discussing considerations in choosing an approach. One of the
approaches stores the image file as a BLOB (Binary Large OBject) in an OLE
Object field -- and, the technique is not limited to image files. There is
code in the example showing how to accomplish exactly what you ask.

You've already received advice on storing the address as a hyperlink, but
another example in the referenced example shows saving the path and file
name of an external file as text. You can do a similar thing storing the
path and file name as text and using the .FollowHyperlink -- which is nicely
covered in Help.

Best of luck with your project.

Larry Linson
Microsoft Office Access MVP

Larry Linson
Microsoft Office Access MVP

Larry,

This looked really interesting and the page showed for about 5 seconds then
chaged to free screensaver offer that had a "Click Here" button. I would be
interested, but I will not Click Here on any free screensaver or icon offer.
They are mostly adware or spyware.

"Larry Linson" <(E-Mail Removed)> wrote in message
news:gf0bq5$g19$(E-Mail Removed)...
> "Acekid09" <(E-Mail Removed)> wrote
>
>> I currently have an access DB set up with many records. Each record has
>> some
>> associated word or excel files. I was wondering if there was anyway to
>> link
>> these files to my access DB record. Can you save these files or paste
>> them to
>> the record in access? Please help!!
>
> The sample imaging databases at http://accdevel.tripod.com illustrate
> three
> approaches to handling images in Access, and the download includes an
> article discussing considerations in choosing an approach. One of the
> approaches stores the image file as a BLOB (Binary Large OBject) in an OLE
> Object field -- and, the technique is not limited to image files. There
> is code in the example showing how to accomplish exactly what you ask.
>
> You've already received advice on storing the address as a hyperlink, but
> another example in the referenced example shows saving the path and file
> name of an external file as text. You can do a similar thing storing the
> path and file name as text and using the .FollowHyperlink -- which is
> nicely covered in Help.
>
> Best of luck with your project.
>
> Larry Linson
> Microsoft Office Access MVP
>
> Larry Linson
> Microsoft Office Access MVP
>

"Klatuu" <(E-Mail Removed)> wrote:

>This looked really interesting and the page showed for about 5 seconds then
>chaged to free screensaver offer that had a "Click Here" button. I would be
>interested, but I will not Click Here on any free screensaver or icon offer.
>They are mostly adware or spyware.

I just tried that here and nothing happened. Both IE and FireFox.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

I tried it with Internet Explorer and got some popups that were
immediately suppressed by my browser settings.

I tried it with Safari (on a Mac) and didn't even see the popups.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


Tony Toews [MVP] wrote:
> "Klatuu" <(E-Mail Removed)> wrote:
>
>> This looked really interesting and the page showed for about 5 seconds then
>> chaged to free screensaver offer that had a "Click Here" button. I would be
>> interested, but I will not Click Here on any free screensaver or icon offer.
>> They are mostly adware or spyware.
>
> I just tried that here and nothing happened. Both IE and FireFox.
>
> Tony

"Larry Linson" <(E-Mail Removed)> wrote:

>The sample imaging databases at http://accdevel.tripod.com

:Larry

Maybe it's about time to take up Arvin's offer for space on the Access
MVPs website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

"Klatuu" <(E-Mail Removed)> wrote

> This looked really interesting and the page
> showed for about 5 seconds then chaged to
> free screensaver offer that had a "Click Here"
> button. I would be interested, but I will not
> Click Here on any free screensaver or icon offer.
> They are mostly adware or spyware.

Tripod offers free websites of modest size, but you have to put up with
Tripod's advertising, over which you have no control. I suppose popup ads
are their latest advertising gimmick.

I hope you this does not mean that, in order to continue, you would have to
accept the download of a screensaver. I've had those samples and examples
hosted at Tripod for a number of years, but maybe, as Tony says, it is time
to move them elsewhere and avoid the popups, now.

Larry Linson
Microsoft Office Access MVP

"Larry Linson" <(E-Mail Removed)> wrote in
news:gf6105$4ig$(E-Mail Removed):

> I hope you this does not mean that, in order to continue, you
> would have to accept the download of a screensaver. I've had those
> samples and examples hosted at Tripod for a number of years, but
> maybe, as Tony says, it is time to move them elsewhere and avoid
> the popups, now.

You could certainly put them on my website if that's more convenient
for you.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/