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
|
|||
|
|||
Pictures: cut and paste
Hi all,
Users of my database must have the possibility to copy and JPG from Paint and paste it into a form. So I created a OLE object called Photo. Put it in the form. The user can now copy the picture in Paint, select the picture, copy it, and paste it in the OLE object in the form. I see the picture in the form, but to goto to the next or previous control doesn't work. Only when I delete the picture I can jump to the next and previous control. any idea? Is this the method to let users copy and paste a picture into a form? The picture must be visible. so no link or what so ever. |
#2
|
|||
|
|||
Pictures: cut and paste
What exactly do you mean when you say you created an OLE object in the form?
Did you add an image control, an unbound object, or a bound object. If you want to store pictures within Access, you'll need to create an OLE Object field in a table. If you want that field to be available in a form, you then create an object control that is bound to that field. I suspect that the OLE object is not bound to a field so it is preventing record navigation. However, storing JPG files within Access is not recommended because of the tremendous bloat in file size. Bitmaps work better. I'm not sure why you're opposed to links because the picture can still be visible in a form. The only drawbacks are that you can't paste directly into Access (although you can find a way to work around this) and you'll have to create more than one image object if you want to see more than one picture at the same time. Peter Faulhaber wrote: Hi all, Users of my database must have the possibility to copy and JPG from Paint and paste it into a form. So I created a OLE object called Photo. Put it in the form. The user can now copy the picture in Paint, select the picture, copy it, and paste it in the OLE object in the form. I see the picture in the form, but to goto to the next or previous control doesn't work. Only when I delete the picture I can jump to the next and previous control. any idea? Is this the method to let users copy and paste a picture into a form? The picture must be visible. so no link or what so ever. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200610/1 |
#3
|
|||
|
|||
Pictures: cut and paste
Hello Kingston,
Indeed I created a OLE object in a table and put it in a form. So it is a bound control. The user has several photoos coulpe of 100 (in JPG). Before pasting them in the form the user must edit the photo a little bit, but the original must be untouched. You can compare it with the form Employees in Northwind. Only difference is that I want to use JPG and not BMP "kingston via AccessMonster.com" wrote: What exactly do you mean when you say you created an OLE object in the form? Did you add an image control, an unbound object, or a bound object. If you want to store pictures within Access, you'll need to create an OLE Object field in a table. If you want that field to be available in a form, you then create an object control that is bound to that field. I suspect that the OLE object is not bound to a field so it is preventing record navigation. However, storing JPG files within Access is not recommended because of the tremendous bloat in file size. Bitmaps work better. I'm not sure why you're opposed to links because the picture can still be visible in a form. The only drawbacks are that you can't paste directly into Access (although you can find a way to work around this) and you'll have to create more than one image object if you want to see more than one picture at the same time. Peter Faulhaber wrote: Hi all, Users of my database must have the possibility to copy and JPG from Paint and paste it into a form. So I created a OLE object called Photo. Put it in the form. The user can now copy the picture in Paint, select the picture, copy it, and paste it in the OLE object in the form. I see the picture in the form, but to goto to the next or previous control doesn't work. Only when I delete the picture I can jump to the next and previous control. any idea? Is this the method to let users copy and paste a picture into a form? The picture must be visible. so no link or what so ever. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200610/1 |
Thread Tools | |
Display Modes | |
|
|