Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Unbound Form for a JPG

Discussion in 'Information Technology' started by Bob Barnes, Jul 28, 2006.

Tags:
  1. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    I'm using SQL statements to populate an
    Unbound Form with Unbound Controls.

    If I store in the Field "APic" the text value C:\Bob.jpg....

    Which Control do I use to display that so it links to that
    File...NOTE: The JPG Files will be referenced to a
    Server...not the C: Drive.

    TIA - Bob
     
  2. Loading...


  3. freakazeud

    freakazeud
    Expand Collapse
    Guest

    Hi,
    you would be using an image control. Add it from the toolbox in design view
    of your form...it will ask you for an image...just add one you have on your
    harddrive...then you can utilize the Picture property of this control on the
    on current and the after update event of the control which holds the full
    path to your images e.g.:

    Me!YourImageControl.Picture = Me!ControlWhichHoldsPath

    HTH
    Good luck
    --
    Oliver
    Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    http://www.oli-s.de


    "Bob Barnes" wrote:

    > I'm using SQL statements to populate an
    > Unbound Form with Unbound Controls.
    >
    > If I store in the Field "APic" the text value C:\Bob.jpg....
    >
    > Which Control do I use to display that so it links to that
    > File...NOTE: The JPG Files will be referenced to a
    > Server...not the C: Drive.
    >
    > TIA - Bob
    >
     
  4. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    Thank you...but the Unbound textbox I'm using to populate w/ "C\Bob5.jpg"
    reads as "Empty".

    Any ideas?

    TIA - Bob

    "freakazeud" wrote:

    > Hi,
    > you would be using an image control. Add it from the toolbox in design view
    > of your form...it will ask you for an image...just add one you have on your
    > harddrive...then you can utilize the Picture property of this control on the
    > on current and the after update event of the control which holds the full
    > path to your images e.g.:
    >
    > Me!YourImageControl.Picture = Me!ControlWhichHoldsPath
    >
    > HTH
    > Good luck
    > --
    > Oliver
    > Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    > http://www.oli-s.de
    >
    >
    > "Bob Barnes" wrote:
    >
    > > I'm using SQL statements to populate an
    > > Unbound Form with Unbound Controls.
    > >
    > > If I store in the Field "APic" the text value C:\Bob.jpg....
    > >
    > > Which Control do I use to display that so it links to that
    > > File...NOTE: The JPG Files will be referenced to a
    > > Server...not the C: Drive.
    > >
    > > TIA - Bob
    > >
     
  5. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    THANK you...I'm using code to populate an Unbound Textbox w/ "C:\Bob5.jpg"
    but it reads as "Empty".

    Any ideas?

    TIA - Bob

    "freakazeud" wrote:

    > Hi,
    > you would be using an image control. Add it from the toolbox in design view
    > of your form...it will ask you for an image...just add one you have on your
    > harddrive...then you can utilize the Picture property of this control on the
    > on current and the after update event of the control which holds the full
    > path to your images e.g.:
    >
    > Me!YourImageControl.Picture = Me!ControlWhichHoldsPath
    >
    > HTH
    > Good luck
    > --
    > Oliver
    > Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    > http://www.oli-s.de
    >
    >
    > "Bob Barnes" wrote:
    >
    > > I'm using SQL statements to populate an
    > > Unbound Form with Unbound Controls.
    > >
    > > If I store in the Field "APic" the text value C:\Bob.jpg....
    > >
    > > Which Control do I use to display that so it links to that
    > > File...NOTE: The JPG Files will be referenced to a
    > > Server...not the C: Drive.
    > >
    > > TIA - Bob
    > >
     
  6. Bob Barnes

    Bob Barnes
    Expand Collapse
    Guest

    MY ERROR - Mea Culpa...I left out the "!" to identify the field.

    THANK you for explaining this.

    Bob

    "Bob Barnes" wrote:

    > Thank you...but the Unbound textbox I'm using to populate w/ "C\Bob5.jpg"
    > reads as "Empty".
    >
    > Any ideas?
    >
    > TIA - Bob
    >
    > "freakazeud" wrote:
    >
    > > Hi,
    > > you would be using an image control. Add it from the toolbox in design view
    > > of your form...it will ask you for an image...just add one you have on your
    > > harddrive...then you can utilize the Picture property of this control on the
    > > on current and the after update event of the control which holds the full
    > > path to your images e.g.:
    > >
    > > Me!YourImageControl.Picture = Me!ControlWhichHoldsPath
    > >
    > > HTH
    > > Good luck
    > > --
    > > Oliver
    > > Admin Specialist & Computer Science Major @ UMD - Go Terps - :)
    > > http://www.oli-s.de
    > >
    > >
    > > "Bob Barnes" wrote:
    > >
    > > > I'm using SQL statements to populate an
    > > > Unbound Form with Unbound Controls.
    > > >
    > > > If I store in the Field "APic" the text value C:\Bob.jpg....
    > > >
    > > > Which Control do I use to display that so it links to that
    > > > File...NOTE: The JPG Files will be referenced to a
    > > > Server...not the C: Drive.
    > > >
    > > > TIA - Bob
    > > >
     

Share This Page