User-friendly OLE?

[vbaDev]

Hi, all. An Access 2003 question:

I use an OLE control frame in my forms to add pictures of items. It works fine, but I don't like having to right-click and select "Insert Object" - it's not user-friendly. I would like to have a button "Add Attachment", which would open a Browse dialog box and after user makes selection will add the attachment.

the pictures need to appear on the forms/reports, so i'm exploring whether to link or embed, but once i decide that i would like to prevent the user from making that choice (which is not prevented in the standard Insert Object dialog box).

For some reason I can't find any properties/methods associated with the OLE frame, which I could manipulate programmatically.

I am pretty familiar with VBA and all other Access stuff, but never used pictures/OLE in databases before, so I might not know all the lingo, so please elaborate a bit.

any advice?

Thanks!

 

[MStCyr]

Hi, all. An Access 2003 question:

I use an OLE control frame in my forms to add pictures of items. It works fine, but I don't like having to right-click and select "Insert Object" - it's not user-friendly. I would like to have a button "Add Attachment", which would open a Browse dialog box and after user makes selection will add the attachment.

the pictures need to appear on the forms/reports, so i'm exploring whether to link or embed, but once i decide that i would like to prevent the user from making that choice (which is not prevented in the standard Insert Object dialog box).

For some reason I can't find any properties/methods associated with the OLE frame, which I could manipulate programmatically.

I am pretty familiar with VBA and all other Access stuff, but never used pictures/OLE in databases before, so I might not know all the lingo, so please elaborate a bit.

any advice?

Thanks!

Hello

You are better to link to the image ... saves on the database bloat.

I did post a sample of how to do this, several years ago in the Sample Database area at the following location:

http://www.access-programmers.co.uk/forums/showthread.php?t=108698

Best regards

Maurice