A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #1  
Old January 21st, 2009, 07:57 AM posted to microsoft.public.access.gettingstarted
Panthernet
external usenet poster
 
Posts: 1
Default How do i attache scanned documents to the database. eg. Memos

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.
  #2  
Old January 21st, 2009, 10:27 AM posted to microsoft.public.access.gettingstarted
troy23
external usenet poster
 
Posts: 55
Default How do i attache scanned documents to the database. eg. Memos

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


On 21 Jan, 06:57, Panthernet
wrote:
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.


  #3  
Old January 21st, 2009, 06:28 PM posted to microsoft.public.access.gettingstarted
Steve[_57_]
external usenet poster
 
Posts: 598
Default How do i attache scanned documents to the database. eg. Memos

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



"Panthernet" wrote in message
...
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.



  #4  
Old January 22nd, 2009, 07:32 PM posted to microsoft.public.access.gettingstarted
Ken Sheridan
external usenet poster
 
Posts: 3,433
Default How do i attache scanned documents to the database. eg. Memos

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/...apps&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:

kenwsheridanatyahoodotcodotuk

Ken Sheridan
Stafford, England

"Panthernet" wrote:

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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:20 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.