View attached Image

[cutephoenixchic]

Okay, my boss gave me this killer project and I just have a brief question to see if anyone thinks I can do this.

Right now, I have a database for business card management.

I have 2 tables

1)Contact Info - Has various contact info fields
2)Business Card Table - Have 2 fields, CardID and Card (field is OLE object to attach business card to the database.

I have the CardID field in a relationship with the same field in Contact Info.

I have 2 questions:

1) I am using Access 2000, and would like to know if there is a way to allow the OLE field to be a jpg attachable field. I did not see it as an option, only .bmp Cry

2) Is there a way, that when I pull the information up in a form, it can display the attached business card that is attached to the database?

What can I do?

Thanks for any help in advance.

Shannon Ann

 

[cuttsy]

I don't tend to use OLE objects I just have a string field with the location of a jpeg. i.e. C:\Images\BusCards\mybusinesscard.jpg