jpegs in Access XP (yet again)

[imetu78]

Hi, i am having no end of problems getting any images (.bmp, .jpg, .png, .tiff) to display either linked or embedded, in bound or unbound controls to work in my student verson of Access XP. That is office XP, on Windows XP sp2.

I know you guys are getting really sick of reading about this problem. But i am at a new level of Newbie. that is the infantile version of newbie. I have searched google and other forums for "images/pictures/jpegs in Access Xp" and have waded through hundreds of pages and help articles relating to this topic. i have even downloaded some example database solutions to this problem, i have followed The_Doc_man advice in various different threads and to no evail. I have spent roughly about 30 hours sifting through information that i just cannot get it to work.

I have uninstalled Office, and reinstalled my version trying to include all graphics filters, but during the install, where you select additional components, it seems that they are installed by default. I install everything just to make sure that i get everything and it still does not work. I dont know if this is just my newbie-ness showing through, or if i really do need to take a degree in IT just to get my simple database to store a few images per record. I would really appreciate if some one could point me to some
"uber-newbie" tutorials on this topic as i have also sifted through textbooks to find the answer, and have found that they dont even go into it at all.

Any help for this frustrated uber newbie would be great and the more step by step detail, not assuming that i am already seasoned in database design, would be even more greatly appreciated. thank you in advance for maybe taking the time to respond to this S.O.S

 

[shadow9449]

Hi, Imetu

What is your exact problem?

Have you opened the form in design view, and selected Insert > Picture, and then selected the image you want to insert?

SHADOW

 

[imetu78]

Hi, Imetu

What is your exact problem?

Have you opened the form in design view, and selected Insert > Picture, and then selected the image you want to insert?

SHADOW

Hi SHADOW.

What i am trying to do is create a db that has two tables. One to store the details of Customers and the other to store details of items for each customer. The second table will have a form that i will enter lots of items for each customer and each item will have details and a photograph. Like an inventory. But each item will have a different picture. so with each item i want to link or embed (if it is easier, i can put up with the performce problems once the it gets large).

So the main problem is getting the photographs to show up in either the unbound control or the bound control. I dont have the detailed step by step instructions on how to achieve this and the other instructions / tutorials on how to do this are vague (assuming a certain amount or previous knowledge).

please if you can point me in the right (cheap)! direction to any help i would appreciate your advice.

I could insert a picture in design view, but i dont want to have to insert 100's or 1000's of pics that way.

thank you
imetu78

 

[shadow9449]

Step 1: Add a field in your table describing the path to the image associated with the item

Step 2: Add an image to your form (any image will do). Let's call it "Image".

Step 3: Put the path on your form in a textbox bound to the table. Let's call it "txtPath"

Step4: In the Form_Current method of your form, simply say: me.Image.Picture = me.txtPath

Does that help?

SHADOW

 

[imetu78]

Step 1: Add a field in your table describing the path to the image associated with the item

Step 2: Add an image to your form (any image will do). Let's call it "Image".

Step 3: Put the path on your form in a textbox bound to the table. Let's call it "txtPath"

Step4: In the OnCurrent method of your form, simply say: me.Image.Picture = me.txtPath

Does that help?

SHADOW

Hi shadow. thank you so much for your help. that worked a treat. i really appreciate your help and for being patient with me.

take care

imetu78

 

[shadow9449]

Hi shadow. thank you so much for your help. that worked a treat. i really appreciate your help and for being patient with me.

take care

imetu78

You're welcome. And it didn't even take 30 hours

SHADOW

 

[The_Doc_Man]

Looks like Shadow gave you the answer you needed. I would have answered but I've been doing some security code and that tends to absorb my time.

Now, if you wanted to get fancy-schmancy, search the forum for how to select a file using the File Open control or method. Pat Hartman has posted that more than once. It looks ugly but it's just some code you set up to trigger a call to an external routine.

Then it would be a matter of putting a file name slot in your table and having your form define a control to activate the "File Open" and browse for the file name. Once you have the file name, store it in the table. On the Form_Current event, just re-load that file name to the .Picture slot as Shadow suggested. I always like LINKED rather than EMBEDDED 'cause linked is cheaper in space and not noticeably slower in terms of performance - unless the picture is networked and the database isn't.

 

[shadow9449]

On the Form_Current event, just re-load that file name to the .Picture slot as Shadow suggested.

I wrote OnCurrent, but in the code window it does say Form_Current. I changed my post to avoid confusion.

Thanks, Doc

SHADOW