A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Viewing Attachment Photo on Form



 
 
Thread Tools Display Modes
  #1  
Old May 7th, 2010, 07:47 PM posted to microsoft.public.access.forms
newtoaccess[_3_]
external usenet poster
 
Posts: 3
Default 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  
Old May 8th, 2010, 01:29 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old May 10th, 2010, 02:45 PM posted to microsoft.public.access.forms
newtoaccess[_3_]
external usenet poster
 
Posts: 3
Default 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  
Old May 10th, 2010, 08:01 PM posted to microsoft.public.access.forms
newtoaccess[_3_]
external usenet poster
 
Posts: 3
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.