At the moment I'm using a report which contains an indicator to show
if a Service group of the company isn't working well or is working
perfectly. This indicator is a "*" which looks like a traffic light.

Example:
When a Service groep does hit the target, the indicator will lit up
using the following Control Source:
=IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*")

But now, I would like the use a real bitmap, trafficlight bitmaps, to
show in stead of the indicators. So when I'm using these bitmaps in
the reports, on green (target made) the green light bitmap must
appear. How do I do this. The "*" indicator just doesn't use the same
code. I've already made a table with the traffic lights: good (Bitmap
object)
not good (Bitmap object)

So how could I use this in a report: something like in de control
source: if good then bitmap green?

At the moment I'm using a report which contains an indicator to show if a Service group of the company isn't working well or is working perfectly. This indicator is a "*" which looks like a traffic light.

Example: When a Service groep does hit the target, the indicator will lit up using the following Control Source: =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*")

But now, I would like the use a real bitmap, trafficlight bitmaps, to show in stead of the indicators. So when I'm using these bitmaps in the reports, on green (target made) the green light bitmap must appear. How do I do this. The "*" indicator just doesn't use the same code. I've already made a table with the traffic lights: good (Bitmap object) not good (Bitmap object)

So how could I use this in a report: something like in de control source: if good then bitmap green?

But how could I make this visible. For example, I've put the bitmap in
c:/access/test1.bmp, test2.bmp, test3.bmp...How can I import them in
to the
report and make it visible? it's not like
=IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*")
And "*" is the one which lits up when the
target is reached. But which line tot you have to use if those stars
are
bitmaps?

At the moment I'm using a report which contains an indicator to show if a Service group of the company isn't working well or is working perfectly. This indicator is a "*" which looks like a traffic light.

Example: When a Service groep does hit the target, the indicator will lit up using the following Control Source: =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*")

But now, I would like the use a real bitmap, trafficlight bitmaps, to show in stead of the indicators. So when I'm using these bitmaps in the reports, on green (target made) the green light bitmap must appear. How do I do this. The "*" indicator just doesn't use the same code. I've already made a table with the traffic lights: good (Bitmap object) not good (Bitmap object)

So how could I use this in a report: something like in de control source: if good then bitmap green?

Using the toolbox, create 3 images. Access will prompt you for which images
to use, so select the 3 traffic lights. Yoy may need to set the properties
to zoom.
Make all 3 images exactly the same size, and superimpose them over each
other. ( You may want to do this at the end so that you can see what is
happening)

But how could I make this visible. For example, I've put the bitmap in c:/access/test1.bmp, test2.bmp, test3.bmp...How can I import them in to the report and make it visible? it's not like =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*") And "*" is the one which lits up when the target is reached. But which line tot you have to use if those stars are bitmaps?

> At the moment I'm using a report which contains an indicator to show > if a Service group of the company isn't working well or is working > perfectly. This indicator is a "*" which looks like a traffic light. > > Example: > When a Service groep does hit the target, the indicator will lit up > using the following Control Source: > =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*") > > But now, I would like the use a real bitmap, trafficlight bitmaps, to > show in stead of the indicators. So when I'm using these bitmaps in > the reports, on green (target made) the green light bitmap must > appear. How do I do this. The "*" indicator just doesn't use the same > code. I've already made a table with the traffic lights: good (Bitmap > object) > not good (Bitmap object) > > So how could I use this in a report: something like in de control > source: if good then bitmap green?

Using the toolbox, create 3 images. Access will prompt you for which images to use, so select the 3 traffic lights. Yoy may need to set the properties to zoom. Make all 3 images exactly the same size, and superimpose them over each other. ( You may want to do this at the end so that you can see what is happening)

But how could I make this visible. For example, I've put the bitmap in c:/access/test1.bmp, test2.bmp, test3.bmp...How can I import them in to the report and make it visible? it's not like =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*") And "*" is the one which lits up when the target is reached. But which line tot you have to use if those stars are bitmaps?

Have all the bitmaps superimposed on top of each other as images, and just play around with the visible properties of each image

HTH

Phil "Erwin" <07*****@student.hro.nl> wrote in message news:98**************************@posting.google.c om... > At the moment I'm using a report which contains an indicator to show > if a Service group of the company isn't working well or is working > perfectly. This indicator is a "*" which looks like a traffic light. > > Example: > When a Service groep does hit the target, the indicator will lit up > using the following Control Source: > =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*") > > But now, I would like the use a real bitmap, trafficlight bitmaps, to > show in stead of the indicators. So when I'm using these bitmaps in > the reports, on green (target made) the green light bitmap must > appear. How do I do this. The "*" indicator just doesn't use the same > code. I've already made a table with the traffic lights: good (Bitmap > object) > not good (Bitmap object) > > So how could I use this in a report: something like in de control > source: if good then bitmap green?

Using the toolbox, create 3 images. Access will prompt you for which images to use, so select the 3 traffic lights. Yoy may need to set the properties to zoom. Make all 3 images exactly the same size, and superimpose them over each other. ( You may want to do this at the end so that you can see what is happening)

> But how could I make this visible. For example, I've put the bitmap in > c:/access/test1.bmp, test2.bmp, test3.bmp...How can I import them in > to the > report and make it visible? it's not like > =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*") > And "*" is the one which lits up when the > target is reached. But which line tot you have to use if those stars > are > bitmaps? > > =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"c:/access/test1.bmp")'--> > isn't the option. > > But how do I make these bitmaps visible when a target is reached? > > > > > "Phil Stanton" <di********@stantonfamily.co.uk> wrote in message > news:<41*********************@mercury.nildram.net> ... >> Have all the bitmaps superimposed on top of each other as images, and >> just >> play around with the visible properties of each image >> >> HTH >> >> Phil >> "Erwin" <07*****@student.hro.nl> wrote in message >> news:98**************************@posting.google.c om... >> > At the moment I'm using a report which contains an indicator to show >> > if a Service group of the company isn't working well or is working >> > perfectly. This indicator is a "*" which looks like a traffic light. >> > >> > Example: >> > When a Service groep does hit the target, the indicator will lit up >> > using the following Control Source: >> > =IIf([tot-betrouwbaarheid]>0,8*10*[weegfactor-betrouwbaarheid];"*") >> > >> > But now, I would like the use a real bitmap, trafficlight bitmaps, >> > to >> > show in stead of the indicators. So when I'm using these bitmaps in >> > the reports, on green (target made) the green light bitmap must >> > appear. How do I do this. The "*" indicator just doesn't use the >> > same >> > code. I've already made a table with the traffic lights: good >> > (Bitmap >> > object) >> > not good (Bitmap object) >> > >> > So how could I use this in a report: something like in de control >> > source: if good then bitmap green?