Search results

Is working! Thank You very much!

Hi, I have a query named “PSAET” with those fields and values: I need to add a new calculated field named “ETAD” which will accumulate the ETD field and the result should be like this: To do this, I created a new query and if I have only one batch, my formula is working fine: ETAD...

Hi, How can I add a small table into a new thread to show the values? Thank you

Hi, Is working!!! Thank you very much! Have a nice day!

Hi, I have a form where I need a conditional formatting on a field [TT]. So if I use a basic way to do it (condition 1), the expression is [CAV]-[TTA]>0 is working fine and the back color become green as I need. I can't use that way, because this is an indicator which I don't want to show all...

Hi I have a form where I need to verify if two specific fields [Field1] AND [Field2] are filtered. In the other words I need a code something like: If me.field1 AND me.field2 are filtered Then Msgbox "Filter is On" Else Msgbox "Filter is Off" End If Can you help please? Thank You!

Thank You MajP, For now I use the other solution using a query, but I'll test your function. This could be very usefully to filter using multiple fields (more then two)

Thank you Pbaldy. I know this can be done using a query with the conditions Like "*" & [Forms]![Customers]![cbo_State] & "*" for State and Like "*" & [Forms]![Customers]![cbo_Status] & "*" My question is if there is a way to be done using me.filter...

the second filter show empty results...

Thank you Ranman256, but I get an error when I use your code: "State= ' " & Me.cbo_State & " ' AND Status= ' " & Me.cbo_Status & " ' " The verification for the first filter it was applied is ok using: If Me.FilterOn = True Then ...

Hi, I have a form where I need to apply two filters one at the time, using two cbo box: cbo_State for the field State and cbo_Status for the field Status. I tried this, but doesn't work: For State: Private Sub cbo_State_AfterUpdate() If Me.FilterOn = True Then Me.Filter = "State= " &...

Thank you, You right! Using another query, is working.

Hi, I have a query named BBT with those fields: Qty, S_Time, M_Time, Planned_Date I need to calculate in a new field AT: DSum("[TT]","BBT", [Planned_Date]<=#" & [Planned_Date] & "#") but for some reasons doesn't work. The field TT is a calculated field too; TT: [S_Time]+ (Qty]*[M_Time] Can...

Thank You!

I know that I can use a dedicated search software as "Copernic" which will index all the files and then is fast to use it, but I have to install it on each machine. That why I'm lucking for a better way to do it.....

Hi, Thank You, but the folder where are all the files is on the LAN. The second reason is because I need to integrate this search tool with another Access application and this way will be more friendlily for all the users.

Hi, I’m not a programmer, but I did a lot of research and I don’t found what I need. I hope that You can help me! This is what I need: I have more pdf searchable, all located in the same folder location. (Ex: C:\Temp) From an Access form, I like to find all the pdf files located in...

Thank You Isskint, Using a layout, I don't need to resize the others fields, because all the remeaning active fields will automatically align, keaping their original size.

To simplify let say that I want to hide column B when I open the form which normally show all 5 columns (A,B,C,D,E) So for the column B, I have the label_B and field_B and to hide this column I tried this on load event: [label_B].Visible = False [Field_B].Visible = False This will hide...

Hi, I have a table "Preference" where I can select (Yes or No) the desired columns to be display in a form "Presentation" where are A, B, C, D and E columns. What I need: If for example in the table Preference the column selected are A, C and D, then the form will show only those three columns...