show the item rating with stars....help

[samy]

Hi all

I have a rating table with the rate ID and title. Is there a way to represent the rate as stars image like this

instead of just showing the title of it.

i tried with this code

Select Case Me.RateID
Case 1
Me.Image0.Visible = True
Me.Image1.Visible = False
Me.Image2.Visible = False
Me.Image3.Visible = False
Case 2
Me.Image0.Visible = False
Me.Image1.Visible = True
Me.Image2.Visible = False
Me.Image3.Visible = False

Case 3
Me.Image0.Visible = False
Me.Image1.Visible = False
Me.Image2.Visible = True
Me.Image3.Visible = False
Case 4
Me.Image0.Visible = False
Me.Image1.Visible = False
Me.Image2.Visible = False
Me.Image3.Visible = True
End Select

but there is somthing wrong it dosnt change ?? correct me if im wrong please

 

[KenHigg]

Where are you placing the code?

 

[samy]

ok its working now thanks ken

the mistake was in the spilling the rate id was rat loool

i fixed that and every thing is fine

 

[KenHigg]

Cool idea...

I'd like to see the thing work...

 

[samy]

hope it help

 

[KenHigg]

I be darn. Cool, thanks

 

[gmmccarthy]

I agree, very cool.

But why would 1 star be excellent and 5 be terrible.

I guess I'm just used to seeing it in the reverse.

Gary

 

[ghudson]

hope it help

Your posted sample will not display the correct number of stars when the user scrolls through the records. You need to also call the code in the forms OnCurrent event. Also, you should move the code to one sub and call that sub in each event that you need to refresh the star count based on the value of the Rating ID. I have attached my revision to your sample.

 

[samy]

ghudson
your code is what I am looking for so organized and do the work correctly thanks man

 

[ghudson]

ghudson
your code is what I am looking for so organized and do the work correctly thanks man

You are welcome!

 

[MattK23]

I was looking for something similar to this but I wanted it to work more like a web based star rating solution where you hover over the stars and it changes accordingly. Much like on some review sites. The code can probably be cleaned up but it works. Just click on the stars and it will bring up a new form where you can hover and change the stars. Click on the stars to close the form and save your change to the original form.