Thank you for the suggestions. I will try both of them to see which way works best for my application. I sure am glad that these forums exist!
--- In [email protected], "George Oro" <[EMAIL PROTECTED]> wrote: > 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] On > 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+mana gem > > > ent+software&w4=Database+software&w5=Inventory+database+software&w6=M emb > > > 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+m ana > > > gement+software&w4=Database+software&w5=Inventory+database+software&w 6=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+s oft > > > ware&w4=Database+software&w5=Inventory+database+software&w6=Membershi p+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+ma nag > > > 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+m ana > > > gement+software&w4=Database+software&w5=Inventory+database+software&w 6=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 --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
