Viewing Attachment Photo on Form

  • Thread starter Thread starter newtoaccess
  • Start date Start date
N

newtoaccess

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.
 
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







- Show quoted text -
Click to expand...



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
 
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 -
Click to expand...

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

John
 
Back
Top