Re: Conditional Formatting for Image box on Continuous Forms - Again

Hi Peter, again,

I'm implementing my sub-form with Attachments as a continuous form but
an interesting thing has occurred when I inserted the form into my
main form:- only the current record is displaying in the sub-form. I
think this might have something to do with linking the master fields
and child fields.

Basically, the sub-form works as a vertical scroll bar showing all the
different records in a continuous form. The main form displays a
detailed record of the current record selected in the sub-form.
However, the sub-form is now also only displaying the current record
in the continuous form ... ie: 1 picture.

Any advice?

I think this may be because I haven't set up my Access 2007 Options
properly yet. In that regard, I hope the next version of Office at
least GIVES YOU THE OPTION of using traditional menus or the ribbon.

Regards

Costa.

On Tue, 24 Apr 2007 14:47:00 +0100, Peter Hibbs
<peter.hibbs@xxxxxxxxxxxxxxxxxxxxxx> wrote:

Costa

Don't panic, it is possible.

What you need to do is have a field for each image in your table. Make
the field types OLE Object and insert then into your Continuous form.
Then you can just copy and paste your images into the relevant fields
when the form is displayed. I think the only problem with this method
is that the images are stored within the database file so if you have
a large number of large images (in KB that is) the file could be quite
large. Northwind database uses this method to show Employee images on
a form (although not a Continuous form in this case).

I suggest you try that method first. If you have a large number of
images you can also do the insert image part using some VBA code but
that is a bit more complicated.

HTH

Peter Hibbs.


On Tue, 24 Apr 2007 13:31:04 +1000, Costa Zu <get_cool@xxxxxxxxxxx>
wrote:

Hello,

This is still driving me crazy.

I am trying to create a continuous subform down the right hand side of
my main form. The subform simply contains a list of thumbnails that I
want to display in a continuous form. I used to have a tall skinny
subform that just scrolled up and down, but now my list is too long
for the maximum height.

When I created the continuous subform the image displayed in each
record defaulted to that of the current record. Advice that I've
received here does not seem to have helped. This is the advice that I
have received to date:

1.
Advice: Upgrade to 2007 because that will do what I want to do.
Action: I upgraded. Bad advice. Images are treated the same as in
2003. Ie: that doesn't work.

2.
Advice: Use MSFLXGRD.OCX and look at
http://www.lebans.com/conditionalformatting.htm
Action: Great idea! I can see the demo. I want to do something
similar to the thing with the flags. However, when I try to add the
control to my form I get the following message:

"You dont have the licence required to use this ActiveX control"

Now what do I do?

Geez! My problem is simple ... give me an Image control that works
the same way as a text box in a continuous form. i.e: displays the
image associated with the right record. Is there no one else in the
world who wants to do this? I am at a total loss and extremely
disappointed with MS and MS Access.

Can anyone help me out?

Thanks

Costa

.

Relevant Pages

  • Re: Conditional Formatting for Image box on Continuous Forms - Again
    ... Thanks for your advice. ... Regarding the Flex Grid control, I got it by installing Visual Studio ... different records in a continuous form. ... Then you can just copy and paste your images into the relevant fields ...
    (microsoft.public.access.forms)
  • Re: Conditional Formatting for Image box on Continuous Forms - Again
    ... Regarding the Flex Grid control, I got it by installing Visual Studio ... different records in a continuous form. ... Then you can just copy and paste your images into the relevant fields ... Advice that I've ...
    (microsoft.public.access.forms)
  • Re: Subform
    ... On a continuous form, the visible property of a control applies to all ... > form to diplay different images. ... > on the number the value should be set til visible=true... ...
    (microsoft.public.access.forms)
  • Re: Conditional Formatting for Image box on Continuous Forms - Again
    ... Thanks for the advice. ... because I will be needing to display a matrix of images later. ... the field types OLE Object and insert then into your Continuous form. ...
    (microsoft.public.access.forms)
  • Re: Conditional Formatting for Image box on Continuous Forms - Again
    ... the field types OLE Object and insert then into your Continuous form. ... Then you can just copy and paste your images into the relevant fields ... When I created the continuous subform the image displayed in each ... This is the advice that I ...
    (microsoft.public.access.forms)
Loading