photo on a form

[Eric Starn]

I am asked to create a database that has employee info. When it is finished
they want to be able to query the employee's name and bring up that info in
an easy to read form. I can do that, but they also want a photo of the
employee to appear in the form for verification.
I have no idea how the make the photo thing work or if it is even possible.

I would be great if someone can steer me in the right direction.

Eric

 

[Jeff Boyce]

Have you looked into the Northwind db that comes with Access? I believe
they have "employee photo" capabilities in that.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Fred]

With Access 2003 and older, there is only one viable way to do this.

Store the photos is a separate folder. Store the path and file name of the
picture in a text fields.

Use code to make the picture display in the form. I'm noot good enough to
give the details from memory, but I'd search previous posts.....they have it.

avvess 2007 might have another viable way, but I don't use 2007.

 

[ÍõÁÕ]

ÍõÁÕ

 

[Eric Starn]

Is the Northwind database a template or something else?
I have Version 2000 and I can not seem to find it.

Eric