Storing images in Access?

[webeauty]

I am trying to use Access to keep a directory of a group of people. I want to print out a sorted report of these people with their pictures next to their names and hand them out periodically. What is the best way to store pictures of these people in Access? Does it do this? If not, what is the best way to go about this? Is there a better software for this?
Thank you!

 

[bri822]

I can not say that I have had too much experience in this area, but what I would try would be this...

Try stroing all your pictures in a certain directory on your computer. Store the location path to the corresponding photo in the table. Then, when you open up a record, have your "photo" field source point to the file.

I am not sure if that will solve your problem, but if nothing else it is just a different way to think about it

 

[The_Doc_Man]

Other threads on this forum have reported problems in terms of database size when storing actual pictures in the database. You would do better to link to the file through its name.

 

[ElsVanMiert]

You can store the photos, but

you need a special wizard, here is a link with some alternatives: www.unsoftwareag.com/togwa.htm
I use this system since more than one year, integrated it in 4 applications and I am very happy with it.

 

[Nero]

Create a new table called ImageTable.
In the table create a text field called ImagePath.
On your form create an unbound Image frame and call it ImageFrame.
On the OnCurrent event for your form paste this code

On Error Resume Next
If Not IsNull(Me![ImagePath]) Then
Me![ImageFrame].OLETypeAllowed = 1
Me![ImageFrame].SourceDoc = Me![ImagePath]
Me![ImageFrame].Action = 0
End If

There are different ways in which you can insert the path name into the table for your current record. I have been using the common dialog control but not without problems
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=32964
Hope this helps you.

 

[webeauty]

I followed your directions exactly and it didn't work. When you say, unbound image...is that the unbound object tool or just the insert imate tool? The code does not seem to be doing anything.
Any ideas? Thanks.

 

[Nero]

Sorry my last post was a bit vague.

I have been trying to attach a simple example for the past hour but this bloody pc keeps playing up.
I will try again from home later.

Sorry.

 

[webeauty]

Thanks for the help, but I got it!!

Thank you for your willingness to help. I actually found an example in another forum and pulled it off beautifully. I do, however need to figure out how to make a BROWSE button in my form so they can pick a file and it will put the filepath in the field for them. Any ideas? Thanks again.

 

[Nero]

I have been using the Microsoft Common Dialog Control.
This works fine once you get past the .ocx registering.
If your application is being used in house then that is not too bad but if it is for an external project then you are not going to be able to fiddle about registering controls.
Pat Hartman made a good suggestion in the above link to a problem I was having yesterday.
If you want any further help post back and I will help if I can.