When I convert my access 07 database into runtime then try out on another computer without access everything runs fine except the Ole object "right click to insert object" doesn't work. Why?

I think that when you convert accdb to accdr, all shortcut menus are disabled, you can test it on the title of the form right click and no menu for like Save, Close, Form View, etc. will not appear.

So how do I permit users to add a photo in runtime?

Hi

(IMG:style_emoticons/default/welcome2UA.gif)


What format are your images/photos? If you're using Acc2007, have you tried the new Attachment field (instead of OLE Object)?

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

I want end users to be able to add a picture from their own computers into the ole object field. Each record has their own individual photo. I tried the attachment but it does not give me the desired "ease of use" for the end user. I have been trying to find a way to enable just that one feature from the design mode into the runtime mode. Any suggestions? The photos should be bitmap for most users.

This post has been edited by doodedoo: Mar 3 2012, 12:10 PM

Hi,


Sorry, I can't do any testing for you to give you an actual answer but if by "ease of use" you meant the Right-Click > Insert Object 'thing,' then I don't see the big difference with that and the Right Click > Manage Attachment that you get with an Attachment field. Also, you get less "database bloat" with an Attachment field as compared to using an OLE Object field.

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

I'll give that another try. Will the photo stay in that record and visiible?

As far as I know, yes. But I don't use Attachment fields so, you'll have to test it and let us know.

Good luck!

They do stay with the record but as you go to other records the photos flicker like it is going through each one put in the database.

Hi,

Are you able to post a zip copy of your db with test data?

The database is 4.0 MB and this forum will not allow more than 2. Tried to send a zipped file and it won't allow. What do I need to do now?

Hi,

If you can't pare your file down to just the essentials so we can see the problem, maybe I can create a demo for you. Just give me some time...

That is the blank database, 4.0 MB. No records filled in. Is there some other way to send?

Hi,

If you can't live with the flicker, maybe another option for you is to place a command button on your form for the user to add/insert the OLE Object. For example, try using this in the button's Click event:

Me.OLEobjectFieldName.SetFocus
DoCmd.RunCommand acCmdInsertObject

Just my 2 cents... (IMG:style_emoticons/default/2cents.gif)

You might try using the "Access Imagine" control (http://access.bukrek.net). This could simplify your end-users' efforts to insert photos. One advantage of this control is that, if you choose to embed a jpeg photo in the record, it's stored in its native binary format rather than as a much larger bitmap. Or, you can link to a file version of the photo, and can create a thumbnail in passing.

Went with "attachment". Not so difficult as I first thought. Works fine now. Thanks