Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
    > > >
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page