OLE bound photographs

Originally Posted by PhilBowen

I have created the appropriate table with the field titled "picture" and OLE. In each form. I have then create the form via a query within which I go to object, insert link and the photogaph is embedded. No probs so far.

I then click on tha navigation bar. I want to miss the next form as there is no photograph to insert. When I click again on the navigation bar to go to the 3rd form, I am informed " OLE object is empty. You can't edit a bound object frame if the field in the underlying table doesn''t contain an OLE object....Embed or link an OLE object into the bound object frame using the object command in the insert menu."

I know the underlying able doesn't have an OLE object (photograph). There isn't one to insert on the 2nd form. However, the message will not allow me to "cancel" it and each time I click on the navigation bar the message reappears.

I want to embed a photograph to relate to each separate form. Your advice would be welcome

Originally Posted by PhilBowen

Yes. However, that results in the same photograph appearing on each and every form. I also want others to be able to upload photographs onto the forms and not go into "design view".

I want a separate photgraph to appear on each form.

I have tried/ tested the Active X control (DBPIX0 2.O control) which does result in me being able to get photos on each form. This allows upload at a reduced storage.

I do have a network where I use PC and laptop. Draw back with DBPIX0 2.0 control is that it only allows me to access via one PC.

Your thoughts would be most welcome. What possible alternatives/ options are there?

Regards

Phil

Originally Posted by PhilBowen

Thanks. If you have the code that would be really useful.

In the mean time have you or any others used Active X control (DBPIX0 2.O control) or something similar