If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Images do not insert into database
Access 2007 Vista Business
I am trying to insert a picture into a database form. I've tried both bmp and jpeg files. the objects end up going in as in icon instead of the actual picture. it can't be for lack of graphics filters, I have photoshop, illustrator, coreldraw and previous office versions graphic filters installed. i have found that if i open the image in Paint first, i can copy and paste it into the database, but this should not have to be this way!!!! |
#2
|
|||
|
|||
Images do not insert into database
Insert the picture into an unbound object frame. Where you choose list boxes,
combo boxes, and so forth, select unbound object frame. "laurie_g" wrote: Access 2007 Vista Business I am trying to insert a picture into a database form. I've tried both bmp and jpeg files. the objects end up going in as in icon instead of the actual picture. it can't be for lack of graphics filters, I have photoshop, illustrator, coreldraw and previous office versions graphic filters installed. i have found that if i open the image in Paint first, i can copy and paste it into the database, but this should not have to be this way!!!! |
#3
|
|||
|
|||
Images do not insert into database
Sorry, no, I am adding pictures to each record in a form. I've used the
"Image" from the Controls group when designing it. Then in Form View of the form, I right click on the placeholder and select Insert Object. I browse for the image I want to add (I've tried both bmp and jpeg files), but the end result is like "imagename.bmp" instead of the actual picture. What I'm doing as a workaround is opening each image in Paint and copying and pasting... such a pain! "Golfinray" wrote: Insert the picture into an unbound object frame. Where you choose list boxes, combo boxes, and so forth, select unbound object frame. "laurie_g" wrote: Access 2007 Vista Business I am trying to insert a picture into a database form. I've tried both bmp and jpeg files. the objects end up going in as in icon instead of the actual picture. it can't be for lack of graphics filters, I have photoshop, illustrator, coreldraw and previous office versions graphic filters installed. i have found that if i open the image in Paint first, i can copy and paste it into the database, but this should not have to be this way!!!! |
#4
|
|||
|
|||
Images do not insert into database
You first posts sounded like you wanted to do a one-time embedding of a
picture into a form design. Your second post sounds very different (different picture for each record) and makes the problem much clearer. First, you have to get each picture into or associated with each record in the table. Your sure fire way to do this is to store the path and file name in a text field in the table, and then use cosd to display it in a form. There has been lot of "how to" on this in previous posts. (Using an ole type field to store the picture "in" the table works badly at least through Access 2003. Unconfirmed rumor is that it works better in 2007. ) Sincerely, Fred |
#5
|
|||
|
|||
Images do not insert into database
The end user does not have acces to the table. They are to add data as a new
record including adding an image. The instructions should be to right click on the picture field that was created in the form and choose "Insert Object". Then browse to the saved location of the image. This always worked in earlier versions of Office when PhotoEditor was still included. Since PE has been discontinued, the image problems with Access started. "Fred" wrote: You first posts sounded like you wanted to do a one-time embedding of a picture into a form design. Your second post sounds very different (different picture for each record) and makes the problem much clearer. First, you have to get each picture into or associated with each record in the table. Your sure fire way to do this is to store the path and file name in a text field in the table, and then use cosd to display it in a form. There has been lot of "how to" on this in previous posts. (Using an ole type field to store the picture "in" the table works badly at least through Access 2003. Unconfirmed rumor is that it works better in 2007. ) Sincerely, Fred |
#6
|
|||
|
|||
Images do not insert into database
Laurie,
(On a side note, I didn't mean that the user would be entering directly in the table,) It sounds like you were / are using an ole field. Your problem is another illustration of what that's not a good way to do that. The other is massive bloat, certainly at least up up through 2003. We had the problem of Microsoft breaking what we were doing by removal of PE a long time before Access 2007. |
Thread Tools | |
Display Modes | |
|
|