Pictures: cut and paste

[Peter Faulhaber]

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.

 

[kingston via AccessMonster.com]

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]

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