Dashboards on Continuous Forms

[roccogrand]

I would like to place several graphic images on a form in continuous form
mode. They need to be controlled with the Visible property set to values of
a field such as Score.

Is there a way to do this with continuous forms so that every section
doesn't show the same image? The images are small .gif images. I can have
the form turn them on and off but each section uses the On Current event.

Thanks.

David

 

[Albert D. Kallal]

Unfortunately on a continuous form, you can't display separate images.
(well, actually that's not true, in access 2007 you actually do have this
ability).

Your choices are thus, to either have a fixed image on the right hand side,
and as you scroll up and down the form, you then change the one the image

(my spiders sense tells me that's not what you're looking for, as that would
only display one image at a time ).

if you really must, then I think you're gonna have to move and use a third
party control, such as the VB6 listview control or perhaps even a third
party product like tlist7.

While I don't recommend using third party ActiveX controls, if you are going
to use one, I really like tlist7, and I have used it with MS access:


http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm

http://www.bennet-tec.com/btproducts/tlist/tlist.htm

 

[roccogrand]

Thanks Albert.

I have never used third-party controls in an application and I try not to do
any coding as I often tell the folks in my Access users group.

I suppose that the solution to my problem will be to make the images so
large that no one will want me to turn on continuous forms. It sure would be
super to show several small icons at a time for each record using calculated
values. Maybe I will get wild one day and buy a real dashboard program, and
link it to Access.

David