Search results

Hey Guys, I've been trying to wrap my head around how relationships work and then once they are setup how that effects the design of forms, queries etc. I'm rather new and I know what I currently have is no where near being setup correctly (have not used any relationships etc). I was wondering...

Hi guys, I've tried a few different things which didnt seem to work, the closest that I got was looping through all the controls, but it would display the font selector for every control. I'd like to have the button to open the font selector and then once selected it applies to all captions on...

nope lost me sorry :confused: I think I have found a different cascading combo box example that will store the names instead of the numbers so will give that a try

different people same database... the combo boxs work fine all 5 working as they should on the form issue is the data that is stored in the main table are numbers instead of names the query was to try and show the names in the main table the query itself will work if you have the 5 options...

the 2nd combo box re-queries after the first box selection has been made

so easy :) thanks !!

Hey guys, No idea if this is possible or what to even search for to try and find out, been unsuccessful searching thus far... I have a database with with 100s of values for a field. What I would like to be do is specify a value via a form and the query will return all options that equal the...

THANK YOU BURRINA! :D could of little bits missing out of the last code but got it working and it works great and I'm sure I'll figure out the rest of the fields with the conditional formatting easy enough.... thanks so much! 1 last thing, (hopefully the last thing) With the last bit of code...

There is a whole bunch with a whole bunch of combinations.... I've uploaded an example with a couple of the fields, if anyone can get it to work for me I should be okay to work out the other fields myself :)

Thats what I figured, but I am totally lost in how to write it, spent hours googling and trying different bits of code but I don't know enough to get it working :banghead::banghead::banghead:

Thanks Burrina has helped quite a bit, still a little stuck through... I snapped up a quick example db and attached for you so you get a better idea of what I'm trying to do (Pretty sure you are already spot on, but always easier if you can actually see it :)) So far I have: Private Sub...

field 1 is cboCallValidation field 2 is cboName Private Sub cboCallValidation_AfterUpdate() If Me.cboCallValidation = "Normal FLS Call" OR "Communicator" Then Me.cboName.BackColor = cbRed Else Me.cboName.Visible = False End If End Sub does that look right? and how do...

P.s. I've managed to get the code you had working for the call validation field with a little bit of modification but just unsure how to make the 2nd field mandatory and have this apply to the 2nd field would i be correct in guessing it would be ElseIf statements on the after update of the call...

thanks for the quick reply burrina... Maybe I made it a bit to complicated when I was trying to explain it :) to simplify it, there are 2 combo boxes first called cboCallValidation (limited to list with 4 options Normal FLS Call, Abandonded Call, Customer Call, Communicator) this field is...

Hi guys, I am very new to VBA, I did quite a bit back in the day (20 odd years ago) and moved into a different field of work and just can't really remember any of it now that I need it again :mad: I have been searching this forum and done a whole bunch of googling trying to find an answer or...