Adding Photos to employee database

[sladetroityer]

How can I add Photos to each employee's profile? Is there like a a feature that allows attachements to records within a table?

Please help

 

[missinglinq]

This is one of those questions where the version of Access being used is germane.

Linq ;0)>

 

[sladetroityer]

Thanks,

It's the attachment control........ Just figured it out.

I created an attachment field in the employee table, added the attachement and used attachment control to add the photo to the form.

Work's great

 

[missinglinq]

...It's the attachment control...

That means you're using either 2007 or 2010. That's what I meant about it being version-dependent; this Control was not available prior to 2007.

While you can accomplish your task in this manner, in these versions, the next question to ask would be 'is this the most appropriate method,' which really depends on how many Records you're talking about. Using a non-split db or a split db with an Access Front End/Back End, your file size is limited to 2 Gigabytes, which could be problematical.

Pre-2007 this was worked around by storing the path to the image file, rather than the image file itself, in Access. This method is still employed post-2007 in apps where the size limit is being neared.

Linq ;0)>

 

[sladetroityer]

I am using 2010. So how do I use the path? I could store all the photo's in a secure folder. Can you explain how to use the path as opposed to an attachment? I am NOT using a front end/back end database.

 

[missinglinq]

I believe this tutorial is still germane:

http://www.databasedev.co.uk/bound_image_form.html

 

[sladetroityer]

This worked great. Thanks

 

[missinglinq]

Glad we could help!

Linq ;0)>

 

[sladetroityer]

OK Missingling,
Now we have an issue with the photos. When using the next button to go to the next record the cutrrent picture stays the same if the next person doesn't have a photo loaded. So one person's picture shows up many times in some instances.

 

[missinglinq]

I've never had to do this sort of thing, but I believe most people dummy up a "No photo Available" image and assign it to those Records where no photo is available.

Linq ;0)>

 

[vbaInet]

OK Missingling,
Now we have an issue with the photos. When using the next button to go to the next record the cutrrent picture stays the same if the next person doesn't have a photo loaded. So one person's picture shows up many times in some instances.

Is it a Continuous form or a Single form?

If it's a Continuous form the Control Source of the image control needs to be bound to the field that holds the path to the image. If you do it in code it will repeat across all records.

 

[vbaInet]

I've never had to do this sort of thing, but I believe most people dummy up a "No photo Available" image and assign it to those Records where no photo is available.

Linq ;0)>

Or what I would do is:

1. Ensure the Allow Zero-Length String property of the field containing the path set to No.
2. Use an alternative path when there's no image, using the Nz() function. E.g.:

=Nz([ImageFieldContainingPath], [CurrentProject].[Path] & "\" & "[COLOR=Blue]NoImage.bmp[/COLOR]")

 

[sladetroityer]

I found the Allow Zero Length property but was is an NZ function? I'm not sure what to do after I set the Allow Zero Property to NO.

 

[vbaInet]

Step 2 explains it. Actually, [ImageFieldContainingPath] should have been [TextFieldContainingPath].

What is the Control Source of the image control at the moment?

 

[sladetroityer]

strImagePath is the control source

 

[vbaInet]

And strImagePath is a field in the table?

 

[sladetroityer]

It is a field in the Image path table.

 

[vbaInet]

What fields does your Image Path table contain? And which one relates to the table bound to your form?

 

[sladetroityer]

The image path table has the path of the image and the employee's ID number which is linked to the employee table by that employee ID

 

[vbaInet]

So using the code I gave you, it would look like this:

=Nz([strImagePath], "[COLOR=Red]C:\sladetroityer\NoImage.bmp[/COLOR]")

where the red bit is the path to an alternative image when no image exists.