OLE bound photographs

[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

[MMcCarthy]

Have you tried using an unbound object frame?

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

[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

[ADezii]

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

How about dynamically loading the Picture into an Image Control on the appropriate Form. If an image doesn't exist for a Form, don't load any, or load a Default Picture. The size of your Database will also be drastically reduced. I perform a similar function in any Inventory Database which contains images of 500+ items. The filename only is stored in a Table and the graphic is loaded from a Relative Path structure. If you're interested, I can get more specific and show you some code.

ADezii

[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

[ADezii]

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

Application.Ech o False 'Turn OFF Screen Updating
If IsNull(Me![txtFieldPicture]) Then
Me![txtFieldPicture].Visible = False
Me![imgFieldInvento ry].SizeMode = acOLESizeStretc h
Me![imgFieldInvento ry].Picture = fGetDBPath & "Graphics\Inven tory\" & "Thumbs Down.jpg"
Else
If Dir(fGetDBPath & gINVENTORY_GRAP HICS & Me!txtFieldPict ure, vbNormal) <> "" Then ' <R87>
Me![txtFieldPicture].Visible = True
Me![imgFieldInvento ry].SizeMode = acOLESizeClip
Me![imgFieldInvento ry].Picture = fGetDBPath & gINVENTORY_GRAP HICS & Me!txtFieldPict ure
Else
Me![txtFieldPicture].Visible = False
Me![imgFieldInvento ry].SizeMode = acOLESizeStretc h
Me![imgFieldInvento ry].Picture = fGetDBPath & "Graphics\Inven tory\" & "Thumbs Down.jpg"
End If
End If
Application.Ech o True

[PhilBowen]

Thanks

Regards