How can I open a hyperlink based on a record

[Joe]

I'm developing a database for work that is going to be used for tracking part
information. Two important aspects of each part is a quote (in WORD format)
and a picture (JPEG). I was fooling around with OLE Objects but with 500+
parts, the size of the database was growing way too rapidly with the part
pictures. So I thought I would try hyperlinks that could just direct it to
the correct files (which are already on our server). Problem is I can't
figure out how to create some type of command button or macro that will open
the matching quote file or picture based on the currently viewed record. Any
help is greatly appreciated.

 

[Joe Cilinceon]

I'm developing a database for work that is going to be used for
tracking part information. Two important aspects of each part is a
quote (in WORD format) and a picture (JPEG). I was fooling around
with OLE Objects but with 500+ parts, the size of the database was
growing way too rapidly with the part pictures. So I thought I would
try hyperlinks that could just direct it to the correct files (which
are already on our server). Problem is I can't figure out how to
create some type of command button or macro that will open the
matching quote file or picture based on the currently viewed record.
Any help is greatly appreciated.

Look at the method used in Northwind for the employee's pictures. It uses a
path to the image only.