Question Cant load images into database

[josephbupe]

Could someone help me, i can't load pictures into my database and i don't understand why, because i did this before.

All data is coming from one table (t_WantedPersons) with index (s_ID), and the pictures field is (PicFile)

The form is (frmDetails) with an image element named (imgPicture) and the field image path field (PicFile) behind it.

The images load in well into the table with a click on the Add Picture button, but they can't showing correctly.

Please, help.

 

[jsv2002]

Works fine On my system have you recently upgraded your OS or version of access? there have been some known issues I seem remember having the same problem a while back when running XP and access 2000.

Post what version/s you are running and OS will see if I can recreate.

Regards John

 

[josephbupe]

I thank you for the response.

Please, i am using version 2003 of MS Access and version 2002 service pack 2.

I will appreciate.

 

[wiklendt]

ok, i had a look. the images load ok into the table, like you say, but the problem is that it doesn't refresh properly when you move to a different or new record. is that what you mean?

i noticed in design view you don't have a control source for the imgPicture control. i changed this to PicFile from the available fields, and then also added the code "Me.imgPicture.Requery" to the "on Current" event of the form.

this seems to make it work now on my AC2007 system.

 

[jsv2002]

Dohh!!! sorry my mistake totally mis-read the problem thanks wiklendt