423,818 Members | 2,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,818 IT Pros & Developers. It's quick & easy.

OLE bound photographs

P: 24
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
Aug 15 '06 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Aug 16 '06 #2

P: 24
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
Aug 16 '06 #3

ADezii
Expert 5K+
P: 8,586
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
Aug 17 '06 #4

P: 24
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
Aug 17 '06 #5

ADezii
Expert 5K+
P: 8,586
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.Echo False 'Turn OFF Screen Updating
If IsNull(Me![txtFieldPicture]) Then
Me![txtFieldPicture].Visible = False
Me![imgFieldInventory].SizeMode = acOLESizeStretch
Me![imgFieldInventory].Picture = fGetDBPath & "Graphics\Inventory\" & "Thumbs Down.jpg"
Else
If Dir(fGetDBPath & gINVENTORY_GRAPHICS & Me!txtFieldPicture, vbNormal) <> "" Then ' <R87>
Me![txtFieldPicture].Visible = True
Me![imgFieldInventory].SizeMode = acOLESizeClip
Me![imgFieldInventory].Picture = fGetDBPath & gINVENTORY_GRAPHICS & Me!txtFieldPicture
Else
Me![txtFieldPicture].Visible = False
Me![imgFieldInventory].SizeMode = acOLESizeStretch
Me![imgFieldInventory].Picture = fGetDBPath & "Graphics\Inventory\" & "Thumbs Down.jpg"
End If
End If
Application.Echo True
Aug 17 '06 #6

P: 24
Thanks

Regards
Aug 17 '06 #7

Post your reply

Sign in to post your reply or Sign up for a free account.