How do i attache scanned documents to the database. eg. Memos

[Panthernet]

I'd like to attach scanned documents to each record that i create for my
database. I have both pictures and handwritten documents. How do i attach
them to the corresponding record and ensure that the pitures will be visible
in the form as well.

 

[troy23]

Which version of Access are you using?

In Access 2007 there is an attachment data type, but in previous
versions you may need to link to the attachment with a file path.

For FREE Access ebook and videos click here
http://access-databases.com/ebook

 

[Steve]

If you are running WindowsXP, you can do the following .........

Store your scanned documents as .Tif files. Open Windows Explorer and
navigate to a .Tif file. Right click on the file and set "Open With" to
Microsoft Office Document Imaging. Now you need a field in your table to
store the complete path to your scaneed documents. Make that field
Hyperlink. Set up your form so you can click on the path field. When you
open the form and click on the path, Microsoft Office Document Imaging will
open your scanned document and you can view, edit, print, etc. the scanned
document.

Steve
(e-mail address removed)

 

[Ken Sheridan]

To display an image on a form you can add include a text field in its
underlying table in which the path to the image file s stored. On the form
include an Image control and set its Picture property to the path in the
form's Current event procedure like so:

If Not IsNull(Me.ImagePath) Then
Me.Image1.Visible = True
Me.Image1.Picture = Me.ImagePath
Else
Me.Image1.Visible = False
End If

where ImagePath is the name of the field in the table and Image1 is the name
of the image control. You can do similarly in a report by putting the same
code in the report's Detail section's print event procedure. A report
differs from a form in one respect, however; while you don't need a control
bound to the ImagePath field on the form, in a report you do need such a
control in the detail section, but you can set its Visible property to False
(No) to hide it.

You'll find a demo of a more complex means of doing this at:


http://community.netscape.com/n/pfx...libraryMessages&webtag=ws-msdevapps&tid=23913


In the demo multiple images can be attached to each record and shown on
demand by selecting from a list box. By the sound of it this might suit your
requirements better. I'm not sure how up to date the file in the library is.
I did amend it at some stage in response to a request by somebody so that a
user can select specific images per record for display in the report. If
you'd like the latest version (itself pretty old now!) mail me at:

kenwsheridan<at>yahoo<dot>co<dot>uk

Ken Sheridan
Stafford, England