need to link files (.tff images) to MS Access Database

[Guest]

I have a MS Access database that I would like to "link" scanned images (.tff
files) to.
The file names of the scanned images are the same as those in my "Account
No" field. I would like the user to have the option of showing the image by
double clicking an icon or a button labeled "Scanned Image".
Any help would be appreciated.

 

[Guest]

hi,
i am assuming that you have a form with a record showing
and you want to see an immage associated with the record.
you will need to put an image control on your form.
you use the image controls picture property to dispay the
immage by entering the file path to the image in the
picture proterty.
Rather than link to the scanned immages(.tffs), i would
add a column to my table and enter the file path to the
immage for each record.
then on your button you could use the following code:
sub getpic()
Me.Image1.Picture = DLookup
("[filepath]", "yourtable", "[recordID] ='" & Me.txtbox1
& "'")
end sub
where
filepath is the filepath field in yourtable
recordID is the record's ID field in yourtable
me.txtbox1 is the textbox on the form that displays the
recoredID.
tested. it works
I might suggest that you just go ahead and populate the
image when i get the record