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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|