S
sapphiresoda
Guest
I am new to Access and to this forum, but I have been reading any post I can find regarding images in Access and I realize that this issue has been posted about five hundred times. However, I have been unable to solve my problem and would like to know if anyone could help me...
I am working on a database for my job, and for each record in a form I would like to display a corresponding picture. (The pictures are colored dots representing the status of a particular project). This, I have managed to do by creating the OLE object field and inserting each picture individually, ect. However this takes too long and I understand that I can link to images paths in a table to preven the database from becoming a monster size-wise...what I would really like to do is create a button that will say "Change Image" or something to that effect, that once clicked will allow the user to select the name of the bitmap from a dialog box and change the image. I have downloaded ImageSample2000 and tried to copy and paste the code to no avail. I have also tried copying and pasting the code from the Northwinds Employee form, also with no success. Either my button won't do anything or when clicked will give me an error message.
My problem seems to be that I am not copying and pasting code correctly - I don't know anything about code, don't know which event procedures I may be missing or where to put them - I know this is a tall order but if anyone might have any advice regarding adopting code from one database for use in your own, I would greatly appreciate it. My job depends on it!
I am working on a database for my job, and for each record in a form I would like to display a corresponding picture. (The pictures are colored dots representing the status of a particular project). This, I have managed to do by creating the OLE object field and inserting each picture individually, ect. However this takes too long and I understand that I can link to images paths in a table to preven the database from becoming a monster size-wise...what I would really like to do is create a button that will say "Change Image" or something to that effect, that once clicked will allow the user to select the name of the bitmap from a dialog box and change the image. I have downloaded ImageSample2000 and tried to copy and paste the code to no avail. I have also tried copying and pasting the code from the Northwinds Employee form, also with no success. Either my button won't do anything or when clicked will give me an error message.
My problem seems to be that I am not copying and pasting code correctly - I don't know anything about code, don't know which event procedures I may be missing or where to put them - I know this is a tall order but if anyone might have any advice regarding adopting code from one database for use in your own, I would greatly appreciate it. My job depends on it!
