Dick
Here is what I have done with scanned PDF
images.
I can have any number of letters for one specific applicant. So
I searched on applicant and then
EDI USI letterForm WHE AMCASid =
.VAMCASid
--This form has a DB Grid with all letters for
that applicant.
Defined a variable to the unique
ID of the table
Located a Bit Button with a custum EEP --title on
button "View Scanned Letter".
Now all the user has to do is click on the row in the dbgrid and
then press the bit button. R:Base will launch the PDF Reader and open the
file.
Buddy
***********Custom EEP**********
SEL
FileName INTO fFileName INDIC ivfFileName FROM Documents WHE +
DocID = .fDocID
SET VAR fFileName = ('ScannedDocs\'+.fFileName +
'.PDF')
LAUNCH &fFileName
RETURN
**********************************
Hi,
In
rereading my post, there should have been a comma after the word
"scanned".
To
be clear, we are storing the scanned images as individual files on the shared
drive. The info needed to search for a drawing is stored in Rbase. What we
want is to search for the drawing in Rbase. see the file name once we find it,
click on the file name and open the scanned image as a link. One of my staff
had done this is EXCEL, but I like Rbase much
better.
Thanks
Dick
Hi
Buddy,
What we are trying to do is tie information for large format drawings
that have been scanned into RBASE. We use RBASE for tracking of the info for
search capabilities, but once we find it I would like to click on the file
name and open the scanned image in another application. Typically each
drawing, compressed is between 2-5 megs and therefore is not suitable to be
stored in the database.
Any help will be appreciated.
Thanks
Dick
Dick
Not really sure if you would consider that a hot link as I'm
using below. When using edit using formname or print reportname the
picture appears without any other intervention. I would image you could
make a hot link by using buttons and bring up another form with the
picture defined in it. Not sure if there is any way to make a hot link on
a report.
Buddy
-----Original Message-----
From:
[email protected] on behalf of Owen, Richard
Sent:
Mon 1/17/2005 9:40 AM
To: RBG7-L Mailing List
Cc:
Subject: [RBG7-L] - RE: Images stored as
file-references
Hi,
Does having the file name make a Hot Link to the files so that
you can click on the file name in a form or report to open the
image?
Thanks
Dick Owen
Adrian
This is what I do for forms, so I would think the same
logic would work for reports.
--1st variable gets file name
--2nd variable creates file name including path
Form Variables
TEXT vJPGFile = JPGFileName IN
PictureFileNames WHE SocSecNo = ASSN
TEXT
vPicture = ('O:\DBSHARE\SA\PICTURES\'+.vJPGFile)
Locate a variable image and assign it to vPicture
Hope this helps
Buddy
-----Original Message-----
From:
[email protected] on behalf of Adrian Huessy
Sent: Mon 1/17/2005 6:48 AM
To: RBG7-L Mailing
List
Cc:
Subject: [RBG7-L] - Images stored as
file-references
To keep database small, I would like to save only
the filenames of images in
database and not
the large files themselve, but in reports, the image should
be printed.
At the moment I have a mismatch for RBG7.1 types and
objects. Could
someboddy give me a
kick?
What type do I have to use in RBG7.1 table to store
the filename?
What object do I have to use
in reports?
Best Regards
Adrian
=========================================================
The
information in this transmission is intended for official use only and
may contain information from NJM Insurance Group that is privileged,
confidential and exempt from disclosure under applicable law. It is
intended for the exclusive use of the persons or entities to which it is
addressed. If you are not an intended recipient or the employee or agent
responsible for delivering this transmission to an intended recipient,
be aware that any disclosure, dissemination, distribution or copying of
this communication, or the use of its contents, is strictly prohibited.
If you received this transmission in error, please notify the sender by
return e-mail and delete the material from any
computer.
=========================================================
=========================================================
The
information in this transmission is intended for official use only and may
contain information from NJM Insurance Group that is privileged,
confidential and exempt from disclosure under applicable law. It is intended
for the exclusive use of the persons or entities to which it is addressed.
If you are not an intended recipient or the employee or agent responsible
for delivering this transmission to an intended recipient, be aware that any
disclosure, dissemination, distribution or copying of this communication, or
the use of its contents, is strictly prohibited. If you received this
transmission in error, please notify the sender by return e-mail and delete
the material from any
computer.
=========================================================
=========================================================
The
information in this transmission is intended for official use only and may
contain information from NJM Insurance Group that is privileged, confidential
and exempt from disclosure under applicable law. It is intended for the
exclusive use of the persons or entities to which it is addressed. If you are
not an intended recipient or the employee or agent responsible for delivering
this transmission to an intended recipient, be aware that any disclosure,
dissemination, distribution or copying of this communication, or the use of
its contents, is strictly prohibited. If you received this transmission in
error, please notify the sender by return e-mail and delete the material from
any computer.
=========================================================
