If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Viewing Attachment Photo on Form
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. |
#2
|
|||
|
|||
Viewing Attachment Photo on Form
Have a look at:
http://www.datastrat.com/Download/Picture2K.zip -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://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. |
#3
|
|||
|
|||
Viewing Attachment Photo on Form
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 |
#4
|
|||
|
|||
Viewing Attachment Photo on Form
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 |
Thread Tools | |
Display Modes | |
|
|