On May 8, 7:29*am, "Arvin Meyer [MVP]" wrote:
Have a look at:

http://www.datastrat.com/Download/Picture2K.zip
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://www.mvps.org/access

"newtoaccess" wrote in message

...



I have a check-out type database where once an item is checked out,
the "Check Out" form pops up. *Everything works except that I want the
photo of the person that is checking the item out. *The check out form
is based on a transaction tble. * The table does not have the
"attachments" field. *The photo attachment is stored in my contact
tbl. *I have tried several things, such as queries (Transaction Tbl,
Contact Tbl) but error " The current field must match the join Key "?"
etc. *I know there is an easy fix, currently I don't have it. *I just
want to use it as a visual security reference when checking out the
item.

Any help would be greatly appreciated.- Hide quoted text -

- Show quoted text -



Thank you for your help - I probably wasn't as clear as I should have
been though. I already have all the photos attached in my database
(contacts.tbl). The problem is that when an item is checked out, the
check-out form which is based on my (Transaction.tbl) does not contain
the (contacts.tble.Attachment) field where the photos are stored. I
have attempted to use a Query but an error message appears (see
prior). The query also adds data to the contact.tbl. I only want the
(Check Out) frm to reference or preview the photo attachment without
inputting data. The transaction.tbl stores the required data. Below
is the data for the Transaction.Tbl and the Contacts.tbl – I don’t
know if it will be of use but I feel more information is needed.

Transaction.tbl Data Type

ID Auto number
Asset Number
Checked Out To Number
Checked Out Date Date
Due Date Date
Checked In Date Date
Notes Memo
Restrictions Text


Contacts.Tbl Data Type

Employee ID Auto Number
Last Name Text
First Name Text
Department Text
Attachments Attachment - “Employee Photo”
E-mail Address Text
Job Title Text
Shift Text
Phone Ext Text
Home Phone Text


Thanks,

John