Search results

Words are some requirements. The goal of this textbox is to be red if the word is true (=1) In the conditionnal formatting of this textbox I add the rule : If Field value is equal to 1 textbox is coloured in red. Now in the control source of this texbox, I used this code : =Iif([BLUP]=1 or...

sorry it's not 37 other values but just 3 others and all of these are characters. Could you help me?

Hi, I have this following problem: I want to pogram a textbox. In the expression builder of the properties sheet's control source I've programmed this following code: =IIf([word1] Or [word2]=1,1,0) It works. But I have to add 37 other "words" and I can not. I tried: =IIf([word1]...

I just try it and it always flashes but slowly!

Hi, I have a problem when I use the RGB's function. Indeed I used it in the three following parts "On format", "on paint", "on print". However the form's sheet flashes when I launch the program and I don't know why. The Code is : Private Sub Detail_Format(Cancel As Integer, FormatCount...

I have to retrieve the definition of the flags. I defined all the flags in a code sheet. I added one texbox for one flags in the design view of this sheet. For exemple: Now I erase the listbox of the blueprint's requirement. When I launch the program, he says to me blueprint aren't defined...

I had to define some flags in a report sheet (the code). When I launched the program, he said to me that he can't retrieve flag's definition. So in the design view, I had to add one texbox for one flag. ( just to retrieve their definition, I hid them). It's work, but it's not so conventional...

Hi, I'm a french student so pardon my english! In a report VBA sheet I used flag like that : 'set flag textbox as value of table and catch null value by Nz flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0) flagblup = Nz(DLookup("[BLUP]", "Temp_Bom"...

Someone told me to use the RGB function. Do you know how?? Thanks

the error is "items are not found in this collection"

Hi everybody, I'm a begginer and I need your help... The following search operation have to search some operation in the database, but there is a bug and I don't know why... Could somebody help me?? Thanks a lot.

Hi, I'm a french student so pardon my english! In a report VBA sheet I used flag like that : 'set flag textbox as value of table and catch null value by Nz flagconp = Nz(DLookup("[CONP]", "Temp_Bom", "[Temp2ID]=" & Report_Main_Report.idn), 0) flagblup = Nz(DLookup("[BLUP]", "Temp_Bom"...

I don't know why it doesn't work I'm a beginner and I have to program a very complicated db. (Sorry I can't post the db here even if I would like ) May be I have to use "on format" with "On paint" or "on print". What do you think about that?

:) Thanks to help me but your code doesnn't work and I don't know why!!!

Hi, I'm a french student so pardon my english. The conditionnal formatting is a good thing, but someone told me that the "on format" and "on paint" functions are better. I used the conditionnal formatting with the foolowing rules : ([flagblup]=1 And [Requirement]="Blueprints") Or...