I suggest to keep the image full path in the table and if you want to view
it on the form, try this:
1) Insert an Image control then select any image.
2) e.g name the control as imgMyImage
3) Under Properties, remove the value of Picture so it will show: (none)
4) These will depends if your using bound or unbound form. This is for bound
form, put this under Form_Current() properties:
If IsNull(Me.MyImageFullPath) Then
Me.imgMyImage=Null
Else
Me.imgMyImage.Picture = Me.MyImageFullPath
End If
The porpuse of this approach is to control the size of your database,
because images eats a lot of space.
HTH..
George
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of Isidro Lim
Sent: Tuesday, September 27, 2005 3:38 AM
To: [email protected]
Subject: RE: [ms_access] A new question
hello,
sam's right... change it into OLE object... you dont
have to type the whole path of this file... because ms
access find the exact fiel name of your picture, the
reason here is to fast viewing of your pictures..
--- Sam Maroney <[EMAIL PROTECTED]> wrote:
> Change your data type to OLE Object. Then you can
> either store it
> inside the database as an embedded object (not
> recommended), or you can
> link it to an external file (this is the preferred
> way of doing it).
>
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED] On
> Behalf Of George
> Sent: Monday, September 26, 2005 2:32 PM
> To: [email protected]
> Subject: [ms_access] A new question
>
>
> I have a picture file "anyfile.jpg", the path to
> that file is recorded
> in a table "my documents\my pictures\anyfile.jpg" I
> want to
> dispaly "anyfile.jpg" on a form.
>
> Field in table is set up as a 100 character text
> box.
>
> Putting text box on form, gets only the text in this
> field. I need
> the picture to display.
>
> Any suggestions?
>
>
>
>
>
> SPONSORED LINKS
> Microsoft
>
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+access+database&w1=Micros
>
oft+access+database&w2=Database+development+software&w3=Database+managem
>
ent+software&w4=Database+software&w5=Inventory+database+software&w6=Memb
>
ership+database+software&c=6&s=190&.sig=hc7Za8QzEj1t7F8GW0yzhA>
> access
> database Database
>
<http://groups.yahoo.com/gads?t=ms&k=Database+development+software&w1=Mi
>
crosoft+access+database&w2=Database+development+software&w3=Database+man
>
agement+software&w4=Database+software&w5=Inventory+database+software&w6=
>
Membership+database+software&c=6&s=190&.sig=i5H8GCn7HzmglwpvhJg19w>
> development software Database
>
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Mic
>
rosoft+access+database&w2=Database+development+software&w3=Database+mana
>
gement+software&w4=Database+software&w5=Inventory+database+software&w6=M
>
embership+database+software&c=6&s=190&.sig=kzlRmjQuUTEFLTjkEd6-kg>
> management software
> Database
>
<http://groups.yahoo.com/gads?t=ms&k=Database+software&w1=Microsoft+acce
>
ss+database&w2=Database+development+software&w3=Database+management+soft
>
ware&w4=Database+software&w5=Inventory+database+software&w6=Membership+d
>
atabase+software&c=6&s=190&.sig=CoCmr_EubT5Xd83NiQjcpg>
> software
> Inventory
>
<http://groups.yahoo.com/gads?t=ms&k=Inventory+database+software&w1=Micr
>
osoft+access+database&w2=Database+development+software&w3=Database+manag
>
ement+software&w4=Database+software&w5=Inventory+database+software&w6=Me
>
mbership+database+software&c=6&s=190&.sig=DHnS8Uu1ImyGVg1J4k0BMw>
> database software Membership
>
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Mic
>
rosoft+access+database&w2=Database+development+software&w3=Database+mana
>
gement+software&w4=Database+software&w5=Inventory+database+software&w6=M
>
embership+database+software&c=6&s=190&.sig=uEGHlFpqbscHu8mCHe7tzg>
> database software
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group "ms_access
> <http://groups.yahoo.com/group/ms_access> " on the
> web.
>
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]>
>
>
>
> * Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
>
> [Non-text portions of this message have been
> removed]
>
>
Send instant messages to your online friends http://uk.messenger.yahoo.com
Yahoo! Groups Links
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
