Search results

Dears: i have created a form that contain a search textbox, once user update then it will filter the form. i have applied the below code but it apply the filter on both form and subform . so can you please advise me how to correct to filter form only. Private Sub FindCode_AfterUpdate() On...

its not filtering, please find the attached file, if you can take a look and help me. thanks

thanks alot that work, but need to add a check list to filter along with date filter. how to add them to the code. If IsNull(Me.Foc_Entery) Then my_ck = " [Focus entry] like '*'" Else my_ck = " [Focus entry]= " & Me.Foc_Entery & "" End If If IsNull(Me.Floor_entry) Then my_ck1 = " [Floor...

what if i dont want to filter in between, as i want to filter after update each filed separately. Mean i fuser updated "Date_From" then filter the form. same things to do with "Date_To"

Dears; I have a sub form that contain Date Filter filed ( Date_From and Date_To). so i tried to filter the form with below code and work fine. but i clear the filter by clicking on button, got error message " The Search key was not found in any record" so how to avoid this error. Private...

can you upload again , thanks

thanks alot., i tried this but has some issue, when i select from drop list sometime hang and close the application, also when i add any number. but i want Date Filter field to be blank ( as user can select).

I have uploaded the file as , i want also to filter the sub form based on Date filter filed to get value between date. thanks alot really appreciate your help.

Hi I have a Subfor " Table2" as it have 2 date filter field [ Date_From] and [Date_To]. the subform has Date filed [Date_]. so i want to filter the form between the 2 dates after updates. how to modify this code to apply it filter date. Private Sub filterThisForm2() Dim S1, S2 On Error...

can you please explain how to apply this on report.

i tried but got this error , as in attached file .

Can yli apply this on report.

hi the balance present in " Stock_Count" , so i need sum of IN and out . find attached picture

Dears; I have created Inventory form "Table1" has a sub form "Table2" so the date filter filed ( From ) (to) present in table1 . i want to filter the subform "Date_" after updating date filter filed to get record between selected dates. so can you advise how to do it. thanks

"Stock_L"" = is dr0p list has (in & out) yes I need the sum of record only when stock_L = "in" and sum of record if stock_L = "out" the value present in field " Stock_Count"

Dears; i have created inventory report with filed (in and Out) in one column as i want to get the vale of record has In and record has Out. when i tried this =Sum([Balance]) it will sum all record. as the filter field is "Stock_L" so how to do in the report .

Can you share the link of the example dstabase

But can I l make a drop list for In and out. So the user will first select frop drop list. Then add the value in one field. If selected out then value will be negative but if in then positive. Is there any way to do this.

OK what is the best option. Can you guide me.

please find attached file.