Search results

Hey no worries, it took about 1/100th of the time had I been left to my own devices! I'll have a play zaround; I get can to a point where I open the combo and half is 1-5 and the other is 1-almost certain - 5-rare! To be honest thinking about it, AMBER would be fine, and I just want it to...

Hi Guys!!!!!! OK I've done what you've said pr2-Eugin, and added VilaRestal's code, and now the boxes turn the colours I want!!!! I am eternally grateful! The finishing line is in sight, as I have just two little requests: The Numbers and the Letters have been shortened, (actually, the...

No problem, please find attached!

Thanks for all your help it is very kind to you. I've done all that but still no activity in that bleeding box! I'm wondering whether there is something more simple that i could do instead!!!!

Ok, I won't give you all the columns because there are LOADS as it is a big form but basically there is three columns called 'Consequence', 'Likelihood' and 'Grade' in a table called tblRisk. For the format of Con and Like I used the lookup wizard and both have a query each called...

Hi again! Sorry I've been away for 4 days. I've checked all the information you asked me to, and the RowSource is bound to a table that I have. So I guess this is where it is going wrong :P I've selected a table because I need the information that people select to be added to the table for...

Hi again! Sorry I've been away for 4 days. I've checked all the information you asked me to, and the RowSource is bound to a table that I have. So I guess this is where it is going wrong :P I've selected a table because I need the information that people select to be added to the table for...

Thanks for your support in all this :-) I've put this in the right section, amemded the code as instructed...still nothing :'( I feel it has something to do with the rectangle, what do you think? Thanks, as always!

Thanks Rain, I've took you're advice, and oddly (;D) enough, figured it out. Thanks!

Certainly, please find below: Private Sub Form_AfterUpdate() Select Case Consequence.Value Case 1 - Insignificant If Likelihood.Value = "A - Almost Certain" Or Likelihood.Value = "B - Likely" Then GradeBox.BackColor = 3881966 ' Yellow Else GradeBox.BackColor = 65280...

hi, Thanks again, but this isn't working :-( does the code need to specify the link between the Number (Consequence) and the letter (Likelihood) because i'm not sure it is defined in the code. Thanks!

I'm using Access 2007, and I had selected a 'Label' box from the dsign tools. I've now changed it to a rectangle. I can't see anything in the format called 'Back Style' just 'Back Colour' and there is no 'Normal' or 'Transparent' option. Still nothing happens though. It is perhaps the way I...

Certainly, I'll clarify: - I have the drop-down list of Consequence - beneath that I have the drop-down list of Likelihood - Beneath the two, I have an empty Label box, which I've named 'Grade' The idea is that when you select, for example, 1 from consequence, and A from likelihood, the...

Hi pr2-eugin Thanks for your help. I've continued this code, but one question: Do I have to specify that I want it to appear in the label box that I've put below these options? I've put the code in and nothing works... Thanks

Hi guys, Can anybody help me with creating something? In a form, I have a drop-down list called Consequence, which as five levels (1, 2, 3, 4, 5) and another drop-down list called Likelihood which also has five levels (A, B, C, D, E). I then have a label called Grade and what I want is that...

Hi Pat, I want four independent combo boxes, thank you :) I've tried the code, and I'm getting the following error: Private Sub Command88_Click() Do I need to specify the name of the GO button? Thanks

Hello Access World Forums! Thanks for hosting me, I've just signed up as this site has helped me out before :-) I need to pick your expert brains, and I apologise in advance if I've cross-posted, but my issues seems to be quite personalised so I assumed a new thread would be ok. My basic...