Search results

hi all can you help please , I have a subform with two fields [weld standard] and one [weld code] every time the subform changes i.e number of rowes I want to be able to look at value in [weld standard] and depending on value change the value in [weld code] for each row , I have tried this code...

yes this is working

yes this works also

hi theDBguy yes this part works fine

hi theDBguy, will try this later , have to go out for now , tell you later if it works

hi not getting any errors , just does not change the value in price, did not add any more OR's to statement, just tried your way first before I add any

have tried this but does not work, any ideas please :confused:

hi theDBguy, thank you for quick response , could I increase this to include more values in size and color by just adding another or?

hi all can you help please , I have three text boxes [size] [color] and [price], I want to look at the value of [size] and if It is a 2 or 4 and the value of [color] is blue or red then it will change the value of [price] to a 1, if both contain anything other than these values then [price]...

thank you isladogs for your response this link was very interesting and helpful thank you

hello all and a happy seasons greetings to all ,can you help please , I want to disable the right click option on the to customize the ribbon so users cannot access and modify the ribbon , :confused:

can you help please , i have a textbox and i want to be able to set it so it will change another textbox property the first textbox can contain set words one of these is "en xxxxxx" would like to change the ENABLED property of textbox 2 if the first text box contains the "en" part of the text...

hi JHB , this looks great but the show hide column box Is beyond my capabilities, how do you build this?

hi, i am using the following code to create the excel book Set xlApp = Excel.Application Set xlBook = xlApp.Workbooks.Add Set xlSheet = xlBook.Worksheets(1) 'With xlBook xlApp.Visible = False With xlSheet .Name = rname .Cells.Font.Name = "Calibri"...

hi all , can you help me please i have a subform that the user can select which colums to hid , for example sub form has three colums ( time ,date, and gender) if the user wishes to hid the gender column then all they have to do is right click the name of the column and click hide to get ride of...

just a thought, how would you use conditional formatting on a text box that contains the following [345/787] and only change the color of the text or numbers before the / sign

Hi mark this did not work mate, thank you, I have gone down the conditional format route and added another field yes/no to decide on the colour

hi ridders thank you for the reply, but this will only work on all texts in the the box, what i am after is to change the text color for individual text box's what i am trying to say is this , i have a text box called text1, and in it i will be putting the names of people , if for example i have...

hi all. is it possible to change the color of the text in a text box eg normal text is black but i want to change this particular text in this text box to red then by right clicking it will come up with the text color picker? i want to do this because some of the text will be exactly the same...

hi button moon, thanks for your input, I started this thread because I have produced a database that I have been told is a sellable item WITH the data, (this is the way I want to sell it ) as a complete package, I have never done this before and need the input from this forum to guide me on the...