open attachments

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that stores many attachments to one entity. The attachments
are simply hyperlinks of files located on our server.

What I'd like to do is generate a report that automatically opens
attachments in their associated programs. For example, a .pdf file would open
in Acrobat and a .bmp file would open in MSPaint.

Is this possible?
 
A report is a bunch of data on a printed (or viewed) page. How would you
open items automatically on the report in their programs? That statement
does not really make sense.

If you run a report and it includes fifty of these hyperlinks, you want
fifty other applications to open? If so, what would this have to do with a
report? I could see having a FORM open to a specific record and
automatically open a separate document or spreadsheet (although I have never
needed such functionality) but I can't understand why you'd want a report to
do it for all the items on the report.
 
My apologies for not being clear. I'd like to know if it's possible to open a
report and somehow code things so that the attachments to open into their
associated programs.

The question of 50 attachments never occurred to me because I will rarely -
if ever - have more than 5.
 
You still have not answered my question. You want new Windows to open with
the items on it? Is the user going to read the report, or use the open
windows? When I run a report, I either view it or print it. I don't
understand why you'd also use all the computer resources to open a bunch of
applications every time you run a report. If the user needs to open an item
in WORD for example, add a button or a link in a form and let them open the
ONE item there.

Maybe someone else will have some other opinions, or know how to do this.
 
JohnLute said:
My apologies for not being clear. I'd like to know if it's possible
to open a report and somehow code things so that the attachments to
open into their associated programs.

The question of 50 attachments never occurred to me because I will
rarely - if ever - have more than 5.
Click to expand...

A previewed report in Access is just pixels on the screen. You cannot make
anything happen when you "click" on the image. You can do what you're
describing with a form.
 
JohnLute said:
I have a table that stores many attachments to one entity. The attachments
are simply hyperlinks of files located on our server.

What I'd like to do is generate a report that automatically opens
attachments in their associated programs. For example, a .pdf file would open
in Acrobat and a .bmp file would open in MSPaint.

Is this possible?
Click to expand...
 
Back
Top