Search results

well you make it look easy : ) ! thank you! its great : )

idk it just closed up and wanted to find a solution from the internet. but when i did it on the new file where i deleted some of the stuff and uploaded here it showed me 5 pics. so lets work with that

but in the file i send you which is the shorter version it shows 5 oscars when i've entered rating 3. actually it shows 5 oscars no matter what rating i put

now my access breaks down :| when i enter a value and click to another box.

i changed the value to no but then i added the other pictures and i forgot about that. sorry here its 2 am and im not thinking that good and also i dont understand much of access what do you mean to another text box? and ive entered values in the rating textbox the first 10 record have values

The oscar pictures in the middle of the form are the ones I'm talking about. i deleted most of the stuff and made it more compact. the field rating is the last one in the table

i experiment on it and its quite messy. i have a lot of fields that i don't use

yea i have 10 images and i named them imgStar1 imgStar2 imgStar3 imgStar4 imgStar5 imgStar6 imgStar7 imgStar8 imgStar9 imgStar10. i copied the code. and i change the records in my form

i did it. also i write the code in the after update from the properties of my field named rating and the picture named imgStar doesnt show no matter what rating i put

yea i made it to a number field. i put values from 1 to 10 and the picture doesn't show

i did that and the picture doesnt show no matter what i put in the rating. should the rating field be number or short text ?

Private Sub rating_AfterUpdate() Dim imgArray(1 To 10) As Byte For i = LBound(imgArray) To UBound(imgArray) Me.Controls("imgStar1" & i).Visible = (i <= rating) Next End Sub thats the code i put and when i entered rating 4 it shows me that it cant find image11...

with rating one the picture doesn't show

ou ok i putted imgStar1 and it works ok

ok i renamed the image to imgStar .... and it still doesnt work

i put the code in the after update of the rating field and instead of imgStar put the name of the first image which is Image192. Then when i put rating 1 in the field it gives me an error "run time error microsoft access cant find the field image1921" i don't know why it says image1921.. i've...

i can change the names when i have the code : ). but lets say the names of the images are image1 image2 image3 image4 etc.

In the first one i asked how can i make it show it the table it self, but then they told me it cant be made in the table but in the query, but in the links they gave me i couldn't find what i was actually looking for. That's why i posted my question in the query section.

so how can it be done with 10 star picture? What and where should i do? I'll insert 10 pictures but how can i make one appear if I've made the rating 1 and make 8 of the pictures appear if I've put rating 8 for example

Hello, My question is how can i make a query which shows the most used data in a field, i saw how i can show the biggest or smallest but i didn't see how many times is each data used in a field. My field is for years, and i wanna see each year and how many times it is used. Is this possible to...