Search results

so i can do this in a queries only? can i do it in a form too

i started using access 5 days ago :D.. so no :D

Hello, My idea is to have a field in my table that have ratings for example - 1,2,3,4,5,6,7,8,9,10. How can i make one star.jpg image to appear when I've entered rating 1, two stars to appear when I've entered rating 2, 3 stars for rating 3 and etc.... Is that even possible? If it isn't is...

How can i see the most frequently used data in a field? For example if i have years put in a field, how can i see what is the most frequently used year and also how many times it's used? It will be a plus if i can see all the years in order. Also if i have one field and in that field i have...

thank you! it worked again : )

this gives me the error : Me.textoscar <> "" Then Why do i need <> "" ? do i have to put something there?

yes, I've written the name of the text box where i have to and i have put the code on current but it still gives me an error. Private Sub Form_Current() Me.oscarPic.Visible = Nz(Me.bestpictureoscer, False) Me.oscarmonkey.Visible = Nz(Me.dropbox, False) Me.Image189.Visible = Nz(Me.oscar1, False)...

should i write it in the form_current, where i have written the codes for the check boxes? should i write something between <> "" ? I wrote it in the form current and it gives me syntax error and it shows me this text from the code in yellow Me.YourTextBox <> "" Then

hello how can i make a picture appear when I've entered data in a text box. I tried the code for a check box but it didn't work. Me.Image190.Visible = Nz(Me.checkbox, False)

thank you! I put ImageText.Visible=True in the image properties and i put the other code in a frame of the first picture. because i wanted the text box to disappear when my mouse isn't on the picture.And it worked! I have another question. if i have 10 check boxes which show a picture if...

Hello, how can i make text appear when i hover over a picture? Can i make it appear under the picture? And can i make different text to appear in the different records of the form although it will be the same picture? Thank you again in advance : )

It worked!!!!! thank you again for your help and with your patience for my ignorance! I will try to lower it :)

this is the error it shows me the expression On Current you entered as the event property setting produced the following error: Ambiguous name detected": Form_Current I guess I'm missing again something : | the check box name is - dropbox the new picture name is oscarmonkey and the code i...

thank you again ! If i wanna add another picture connected to a different check box field in the table should i just copy paste the code with the changed names? i tried that and it didn't work for both pictures then

congratulations for the success of the US soccer \football\ team in the world cup!!!

thank you again for your help :)

Hello again, can u help me with an if for my form. im trying to show a picture if a check box is checked. I tried to put this code If bestpictureoscer Then oscarPic.Visible = True Else oscarPic = False End If in the form properties in on current and after update but it doesn't work. I'm sorry...

does anyone have any suggestions ?

can you open it?

i want the little star picture in the form to appear when the check box is checked and not appear when the check box isn't checked.