OK forget my earlier post about inserting PNGs into OLE fields.
(even just using OLE "Links" there's just too much filesize inflation.)
The usual trick of storing filenames for images and displaying them in an
unbound image control is now what I need to do.
But I need to do it in *Continuous* Forms.
Obviously no standard Access control will do this.
But I figure there's got to be a custom control that can be bound to a text
field of a filename, and display the image. Hopefully a cheap or free custom
control?
anybody got any ideas?
hah tia roger
|
|
0
|
|
|
|
Reply
|
Utf
|
12/22/2007 10:19:00 PM |
|
roger
try arvins sample database for using pictures in your database.
http://www.datastrat.com/DataStrat2.html
Jeanette Cunningham
(Arvin did I get it right this time?)
"roger" <roger@discussions.microsoft.com> wrote in message
news:8E29923B-8F2C-45D1-A08B-412FCD1B8D8A@microsoft.com...
> OK forget my earlier post about inserting PNGs into OLE fields.
> (even just using OLE "Links" there's just too much filesize inflation.)
>
> The usual trick of storing filenames for images and displaying them in an
> unbound image control is now what I need to do.
>
> But I need to do it in *Continuous* Forms.
>
> Obviously no standard Access control will do this.
>
> But I figure there's got to be a custom control that can be bound to a
> text
> field of a filename, and display the image. Hopefully a cheap or free
> custom
> control?
>
> anybody got any ideas?
>
> hah tia roger
|
|
0
|
|
|
|
Reply
|
Jeanette
|
12/22/2007 10:32:52 PM
|
|
That shows one image at a time, That's what I'm calling "the usual trick"
> But I need to do it in *Continuous* Forms.
"Jeanette Cunningham" wrote:
> roger
> try arvins sample database for using pictures in your database.
>
> http://www.datastrat.com/DataStrat2.html
>
> Jeanette Cunningham
>
> (Arvin did I get it right this time?)
> "roger" <roger@discussions.microsoft.com> wrote in message
> news:8E29923B-8F2C-45D1-A08B-412FCD1B8D8A@microsoft.com...
> > OK forget my earlier post about inserting PNGs into OLE fields.
> > (even just using OLE "Links" there's just too much filesize inflation.)
> >
> > The usual trick of storing filenames for images and displaying them in an
> > unbound image control is now what I need to do.
> >
> > But I need to do it in *Continuous* Forms.
> >
> > Obviously no standard Access control will do this.
> >
> > But I figure there's got to be a custom control that can be bound to a
> > text
> > field of a filename, and display the image. Hopefully a cheap or free
> > custom
> > control?
> >
> > anybody got any ideas?
> >
> > hah tia roger
>
>
>
|
|
0
|
|
|
|
Reply
|
Utf
|
12/22/2007 10:58:00 PM
|
|
roger,
sorry I can't be more helpful, I tried this myself a while age, but gave up
after a few minutes because I needed the result in half an hour.
I did wonder if I put a button on each row of the continuous form if it
would be easy to open a new form with the appropriate photo in it, but
didn't get round to trying it.
Another technique I have used sometimes is to have a separate form open that
uses Raise Events to sync the current record of the continuous form with the
separate form. As the user moves from row to row of the continuous form and
if they click in the current row, the separate form could be coded to show
the appropriate photo. I haven't tried this for photos, so can't say for
sure if it will do what you want, but it may be worth a try.
Jeanette Cunningham
"roger" <roger@discussions.microsoft.com> wrote in message
news:31AA2D05-F39B-490B-8A0A-0BF360325846@microsoft.com...
> That shows one image at a time, That's what I'm calling "the usual trick"
>> But I need to do it in *Continuous* Forms.
>
>
>
>
> "Jeanette Cunningham" wrote:
>
>> roger
>> try arvins sample database for using pictures in your database.
>>
>> http://www.datastrat.com/DataStrat2.html
>>
>> Jeanette Cunningham
>>
>> (Arvin did I get it right this time?)
>> "roger" <roger@discussions.microsoft.com> wrote in message
>> news:8E29923B-8F2C-45D1-A08B-412FCD1B8D8A@microsoft.com...
>> > OK forget my earlier post about inserting PNGs into OLE fields.
>> > (even just using OLE "Links" there's just too much filesize inflation.)
>> >
>> > The usual trick of storing filenames for images and displaying them in
>> > an
>> > unbound image control is now what I need to do.
>> >
>> > But I need to do it in *Continuous* Forms.
>> >
>> > Obviously no standard Access control will do this.
>> >
>> > But I figure there's got to be a custom control that can be bound to a
>> > text
>> > field of a filename, and display the image. Hopefully a cheap or free
>> > custom
>> > control?
>> >
>> > anybody got any ideas?
>> >
>> > hah tia roger
>>
>>
>>
|
|
0
|
|
|
|
Reply
|
Jeanette
|
12/22/2007 11:14:13 PM
|
|
Thanks, but no.
I figure there's got to be a custom control that can be bound to a
text field of a filename, and display the image.
So anybody know about any custom controls?
"Jeanette Cunningham" wrote:
> roger,
> sorry I can't be more helpful, I tried this myself a while age, but gave up
> after a few minutes because I needed the result in half an hour.
> I did wonder if I put a button on each row of the continuous form if it
> would be easy to open a new form with the appropriate photo in it, but
> didn't get round to trying it.
> Another technique I have used sometimes is to have a separate form open that
> uses Raise Events to sync the current record of the continuous form with the
> separate form. As the user moves from row to row of the continuous form and
> if they click in the current row, the separate form could be coded to show
> the appropriate photo. I haven't tried this for photos, so can't say for
> sure if it will do what you want, but it may be worth a try.
>
> Jeanette Cunningham
>
>
> "roger" <roger@discussions.microsoft.com> wrote in message
> news:31AA2D05-F39B-490B-8A0A-0BF360325846@microsoft.com...
> > That shows one image at a time, That's what I'm calling "the usual trick"
> >> But I need to do it in *Continuous* Forms.
> >
> >
> >
> >
> > "Jeanette Cunningham" wrote:
> >
> >> roger
> >> try arvins sample database for using pictures in your database.
> >>
> >> http://www.datastrat.com/DataStrat2.html
> >>
> >> Jeanette Cunningham
> >>
> >> (Arvin did I get it right this time?)
> >> "roger" <roger@discussions.microsoft.com> wrote in message
> >> news:8E29923B-8F2C-45D1-A08B-412FCD1B8D8A@microsoft.com...
> >> > OK forget my earlier post about inserting PNGs into OLE fields.
> >> > (even just using OLE "Links" there's just too much filesize inflation.)
> >> >
> >> > The usual trick of storing filenames for images and displaying them in
> >> > an
> >> > unbound image control is now what I need to do.
> >> >
> >> > But I need to do it in *Continuous* Forms.
> >> >
> >> > Obviously no standard Access control will do this.
> >> >
> >> > But I figure there's got to be a custom control that can be bound to a
> >> > text
> >> > field of a filename, and display the image. Hopefully a cheap or free
> >> > custom
> >> > control?
> >> >
> >> > anybody got any ideas?
> >> >
> >> > hah tia roger
> >>
> >>
> >>
>
>
>
|
|
0
|
|
|
|
Reply
|
Utf
|
12/22/2007 11:22:00 PM
|
|
ActiveX controls are not supported in forms set to Continuous view. You
might consider upgrading to Access2007 as it now supports external images in
forms set to Continuous view through the native Image control.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"roger" <roger@discussions.microsoft.com> wrote in message
news:47BDE5EC-A59A-456F-8D0A-D80EADC6ED87@microsoft.com...
> Thanks, but no.
> I figure there's got to be a custom control that can be bound to a
> text field of a filename, and display the image.
>
> So anybody know about any custom controls?
>
> "Jeanette Cunningham" wrote:
>
>> roger,
>> sorry I can't be more helpful, I tried this myself a while age, but gave
>> up
>> after a few minutes because I needed the result in half an hour.
>> I did wonder if I put a button on each row of the continuous form if it
>> would be easy to open a new form with the appropriate photo in it, but
>> didn't get round to trying it.
>> Another technique I have used sometimes is to have a separate form open
>> that
>> uses Raise Events to sync the current record of the continuous form with
>> the
>> separate form. As the user moves from row to row of the continuous form
>> and
>> if they click in the current row, the separate form could be coded to
>> show
>> the appropriate photo. I haven't tried this for photos, so can't say for
>> sure if it will do what you want, but it may be worth a try.
>>
>> Jeanette Cunningham
>>
>>
>> "roger" <roger@discussions.microsoft.com> wrote in message
>> news:31AA2D05-F39B-490B-8A0A-0BF360325846@microsoft.com...
>> > That shows one image at a time, That's what I'm calling "the usual
>> > trick"
>> >> But I need to do it in *Continuous* Forms.
>> >
>> >
>> >
>> >
>> > "Jeanette Cunningham" wrote:
>> >
>> >> roger
>> >> try arvins sample database for using pictures in your database.
>> >>
>> >> http://www.datastrat.com/DataStrat2.html
>> >>
>> >> Jeanette Cunningham
>> >>
>> >> (Arvin did I get it right this time?)
>> >> "roger" <roger@discussions.microsoft.com> wrote in message
>> >> news:8E29923B-8F2C-45D1-A08B-412FCD1B8D8A@microsoft.com...
>> >> > OK forget my earlier post about inserting PNGs into OLE fields.
>> >> > (even just using OLE "Links" there's just too much filesize
>> >> > inflation.)
>> >> >
>> >> > The usual trick of storing filenames for images and displaying them
>> >> > in
>> >> > an
>> >> > unbound image control is now what I need to do.
>> >> >
>> >> > But I need to do it in *Continuous* Forms.
>> >> >
>> >> > Obviously no standard Access control will do this.
>> >> >
>> >> > But I figure there's got to be a custom control that can be bound to
>> >> > a
>> >> > text
>> >> > field of a filename, and display the image. Hopefully a cheap or
>> >> > free
>> >> > custom
>> >> > control?
>> >> >
>> >> > anybody got any ideas?
>> >> >
>> >> > hah tia roger
>> >>
>> >>
>> >>
>>
>>
>>
|
|
0
|
|
|
|
Reply
|
Stephen
|
12/23/2007 4:33:04 AM
|
|
Damn, is there anything you don't know Stephen?
I'd vote for your for MOST VALUABLE MVP ever!
thanks again
"Stephen Lebans" wrote:
> ActiveX controls are not supported in forms set to Continuous view. You
> might consider upgrading to Access2007 as it now supports external images in
> forms set to Continuous view through the native Image control.
>
> --
>
> HTH
> Stephen Lebans
> http://www.lebans.com
> Access Code, Tips and Tricks
> Please respond only to the newsgroups so everyone can benefit.
>
>
> "roger" <roger@discussions.microsoft.com> wrote in message
> news:47BDE5EC-A59A-456F-8D0A-D80EADC6ED87@microsoft.com...
> > Thanks, but no.
> > I figure there's got to be a custom control that can be bound to a
> > text field of a filename, and display the image.
> >
> > So anybody know about any custom controls?
> >
> > "Jeanette Cunningham" wrote:
> >
> >> roger,
> >> sorry I can't be more helpful, I tried this myself a while age, but gave
> >> up
> >> after a few minutes because I needed the result in half an hour.
> >> I did wonder if I put a button on each row of the continuous form if it
> >> would be easy to open a new form with the appropriate photo in it, but
> >> didn't get round to trying it.
> >> Another technique I have used sometimes is to have a separate form open
> >> that
> >> uses Raise Events to sync the current record of the continuous form with
> >> the
> >> separate form. As the user moves from row to row of the continuous form
> >> and
> >> if they click in the current row, the separate form could be coded to
> >> show
> >> the appropriate photo. I haven't tried this for photos, so can't say for
> >> sure if it will do what you want, but it may be worth a try.
> >>
> >> Jeanette Cunningham
> >>
> >>
> >> "roger" <roger@discussions.microsoft.com> wrote in message
> >> news:31AA2D05-F39B-490B-8A0A-0BF360325846@microsoft.com...
> >> > That shows one image at a time, That's what I'm calling "the usual
> >> > trick"
> >> >> But I need to do it in *Continuous* Forms.
> >> >
> >> >
> >> >
> >> >
> >> > "Jeanette Cunningham" wrote:
> >> >
> >> >> roger
> >> >> try arvins sample database for using pictures in your database.
> >> >>
> >> >> http://www.datastrat.com/DataStrat2.html
> >> >>
> >> >> Jeanette Cunningham
> >> >>
> >> >> (Arvin did I get it right this time?)
> >> >> "roger" <roger@discussions.microsoft.com> wrote in message
> >> >> news:8E29923B-8F2C-45D1-A08B-412FCD1B8D8A@microsoft.com...
> >> >> > OK forget my earlier post about inserting PNGs into OLE fields.
> >> >> > (even just using OLE "Links" there's just too much filesize
> >> >> > inflation.)
> >> >> >
> >> >> > The usual trick of storing filenames for images and displaying them
> >> >> > in
> >> >> > an
> >> >> > unbound image control is now what I need to do.
> >> >> >
> >> >> > But I need to do it in *Continuous* Forms.
> >> >> >
> >> >> > Obviously no standard Access control will do this.
> >> >> >
> >> >> > But I figure there's got to be a custom control that can be bound to
> >> >> > a
> >> >> > text
> >> >> > field of a filename, and display the image. Hopefully a cheap or
> >> >> > free
> >> >> > custom
> >> >> > control?
> >> >> >
> >> >> > anybody got any ideas?
> >> >> >
> >> >> > hah tia roger
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
|
|
0
|
|
|
|
Reply
|
Utf
|
12/23/2007 11:47:00 AM
|
|
|
6 Replies
665 Views
(page loaded in 0.134 seconds)
|