hyperlink for each record

[JB]

Hello. This is probably a long shot but here goes.
Is it possible to have a field in a form that would have a hyperlink to a
Word document relating only to that particular record.?
But it would be something the user would do when entering data so would have
to be straight forward.
Thank you
Jen

 

[Larry Linson]

Hello. This is probably a long shot but here goes.

Not a "long shot" by a long shot -- "piece of cake" or "duck soup" would be
better descriptions.

Is it possible to have a field in a form that
would have a hyperlink to a Word document
relating only to that particular record.?

There are multiple ways to "link" another file -- a hyperlink field would be
one of them. Another would be to simply store the fully-qualified
path-and-file-name as text and use it as the argument for a .FollowHyperlink
(in re which, see Help).

But it would be something the user would
do when entering data so would have
to be straight forward.

Assuming you are, as I would expect, delivering a developed applicatin to
the user, the code at http://www.mvps.org/access/api/api0001.htm allows you
to use the Windows Common Dialog. There's an example of handling that API
in the imaging examples at http://accdevel.tripod.com if it seems unobvious
(I am not responsible for the ads or popups or ??? in that tripod site --
it's the price they extract for providing the free site, running ads of
their choosing).