Image/Document Form

[desireemm]

Helllo all I have a question on documents in databases. I have a database that I am going to show scanned legal documents on and I was wondering how might one link the scanner to the database? Then store the document in a document folder within the datase (linked to a record)?
how would i create a form that I can search and display images.
the images would be in one folder and the file name
is a field in my table. maybe string together the full path name using
the data in the field and set the Image Picture property to that.
I could save the full path in the table but the file name is also the
part nbr so I don't want to have any thing else in there. I may also
want so split the images into multiple folders some time so I want
to be able to adjust the string on the fly. is this possible??



Thank you

 

[dan-cat]

I have written something very similar to what you are after recently.

What I did was for each record have a folder path field. This field could be populated by the common dialog box. Once the folder field was updated I populated a listbox with all the file names contained within that folder. Then on clicking on the listbox the picture property of an image frame is updated with the [FolderName] field & [FileName] value from the listbox. Thus displaying the image without storing it within the db

I can email you a demo if you like.

Dan

 

[hangglide]

I have written something very similar to what you are after recently.

What I did was for each record have a folder path field. This field could be populated by the common dialog box. Once the folder field was updated I populated a listbox with all the file names contained within that folder. Then on clicking on the listbox the picture property of an image frame is updated with the [FolderName] field & [FileName] value from the listbox. Thus displaying the image without storing it within the db

I can email you a demo if you like.

Dan

I would like to see this example Dan. I need to do a simmilar thing except I have a number of word documents, photos and pdf documents associated with each record. I am looking for ideas on how to limit the listbox you are talking about to only those that would match the record.

For example:

DB Record ID Number = 20031P123W

files on disk

20031P123W.doc
20031P123W.pdf
20031P123W 01.jpg
20031P123W 02.jpg
20031P321X.doc
1000 other files (that all have the appropriate record ID number as the first 10 digits)
etc...

In the list box I only want to see the top 4 files. Eg. those that are associated with that record.

Any suggestions?

Thanks,
Leo

 

[desireemm]

Sample

Yes Dan if you could post a sample or email one to destevenson@viejas.com or desireemm@cox.net I would really appreciate it. Because as you know access will be able to hold just so much



s example Dan. I need to do a simmilar thing except I have a number of word documents, photos and pdf documents associated with each record. I am looking for ideas on how to limit the listbox you are talking about to only those that would match the record.

For example:

DB Record ID Number = 20031P123W

files on disk

20031P123W.doc
20031P123W.pdf
20031P123W 01.jpg
20031P123W 02.jpg
20031P321X.doc
1000 other files (that all have the appropriate record ID number as the first 10 digits)
etc...

In the list box I only want to see the top 4 files. Eg. those that are associated with that record.

Any suggestions?

Thanks,
Leo[/QUOTE]