OLE bound photographs

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • PhilBowen
    New Member
    • Aug 2006
    • 24

    OLE bound photographs

    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
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Have you tried using an unbound object frame?

    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

    Comment

    • PhilBowen
      New Member
      • Aug 2006
      • 24

      #3
      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

      Comment

      • ADezii
        Recognized Expert Expert
        • Apr 2006
        • 8834

        #4
        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
        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

        Comment

        • PhilBowen
          New Member
          • Aug 2006
          • 24

          #5
          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

          Comment

          • ADezii
            Recognized Expert Expert
            • Apr 2006
            • 8834

            #6
            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
            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

            Comment

            • PhilBowen
              New Member
              • Aug 2006
              • 24

              #7
              Thanks

              Regards

              Comment

              Working...