Contacts Database with Photos

[Bell via AccessMonster.com]

I have a contacts database with names, addresses, phone numbers etc of people
in our group. I'm using tabs to separate the sections such as calls,
activities, dues, etc for each member. But I would like to have a photo of
the member on the page also.

How do I link a photo that I have in the images folder to the contact that I
click on in the contacts database?

Thanks,
Bell

 

[John W. Vinson]

I have a contacts database with names, addresses, phone numbers etc of people
in our group. I'm using tabs to separate the sections such as calls,
activities, dues, etc for each member. But I would like to have a photo of
the member on the page also.

How do I link a photo that I have in the images folder to the contact that I
click on in the contacts database?

You can put an Image control on the form, and have a Text field in your table
with the path and name of the picture file for that person. In the Form's
Current event, set the Picture property of the image control to this filename.

A2007 is a good deal more efficient at handling picture data than earlier
versions - you can actually store pictures in the table without instantly
bloating the database beyond all reason (though even so, pictures are big).

John W. Vinson [MVP]

 

[Bell via AccessMonster.com]

It works.......

Many thanks!

I have a contacts database with names, addresses, phone numbers etc of people
in our group. I'm using tabs to separate the sections such as calls,

[quoted text clipped - 3 lines]

How do I link a photo that I have in the images folder to the contact that I
click on in the contacts database?

You can put an Image control on the form, and have a Text field in your table
with the path and name of the picture file for that person. In the Form's
Current event, set the Picture property of the image control to this filename.

A2007 is a good deal more efficient at handling picture data than earlier
versions - you can actually store pictures in the table without instantly
bloating the database beyond all reason (though even so, pictures are big).

John W. Vinson [MVP]