On May 10, 9:45*am, newtoaccess wrote:
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/a...

"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- Hide quoted text -

- Show quoted text -

Nevermind......I figured it out.

John