Search results

When a new record is entered a value gets stored and the id generated. before that the value is null. in this code when the action is record deleted it highlights all the values del in delvalues if i want the same when the action is new record and want to show the new records how to do it...

Thank you for your response. I have used a query to display the value something that never occured to me. I had one more thing that i need to deal with. When we add a new record the uniqid uniqID feild gets saved and displayed in the log if i require the new value to be stored how can i acheive...

Thanks i got that part. I guess what i was trying to ask was is there any way i maybe can Concatenate the uniqID with the value it referes to in the argument. So that at all times i can track if it is company than the company name, if it is contact the contact name where the changes are being...

I am not sure if i can continue this post or use new one. I used the audit trail mentioned and it worked. the routine passes the uniqID_feild and uniqID as parameters. is there anyway i can get the value of the id instead of a number For eg. say in my contacts table i have contactID...

I have been getting a lot of input and i have played around a lot of options but i am getting no where. I have tried a different approach where i have an sql query as the forms row source and filter the subform. The filter form works for all the combo What i want to do is just have a single...

Thanks Bob for your prompt reply This is the code i have now The filtered results are not correct. For a single company employee the data is filtered but for more than one employee i am not getting the right data. Eg. when for a company A emp C & D When i click on company A i have C&...

After hours of playing around i have the form filtering but not completely. I have 2 unbound cascading combo boxes company name employee name when select company name and click on employee name combo box only those employee who are working in the company is highlighted which is ok in...

I have changed my query that feeds the list box with this. SELECT tblvariables.ID, tblvariables.variabletxt FROM tblvariables WHERE (((tblvariables.ID) Like "*" & [forms]![FRM_SearchMulti]![listsearch] & "*")); on all my combo onchange event i have added this code Private Sub...

Hello John, I have followed this example and do have a form by the name Formmulti with the qrySearchAll in the database attached. But they are looking for a more structured 3 layers deep search string that can filter results. I have been working with different combinations. I think with the...

Can anyone help me in the right direction. I have created 2 filter forms but i am required to build a more complex filter form for the entire database. I have created a form with Field,operator,value, logic I am trying to create a 3 level filter option. Narrowing down the search to the...

Thanks again Rick Well the bliss of being a learner you always feel like a door knob. I got the result i need thanks once again.

The index is reading correctly but how to refer to "first Name" etc i am getting a run time error 2465 thanks for your time

I have found the problem in in the criteria of the feild1 i am searching i have Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*" to filter feilds 2, 3 i have copied this code in the "OR" i copied this code in a cascading sequence like field 1 - in criteria feild 2- in OR feild 3 -...

sorry about that i will try to repost I used the following steps to create the search field I have a query called Qry_SearchAll in the criteria of the feild1 i am searching i have Like "*" & [forms]![FRM_SearchMulti]![SrchText] & "*" to filter feilds 2, 3 i have copied this code in...

Dynamically search multiple fields I have got this code and used it to create a search filter. It works but for the first item. How can i create a loop to work for all the items on the list box. 'Create a string (text) variable Dim vSearchString As String'Populate the string variable...

Thanks to this forum i have been able to create 3 combo boxes that work to filter some values in my form. I have 3 -4 combo boxes like cboname,cbostate,cbocompany etc. My next attempt is to have a list box which has row source bound to a query. I have some variables Firstname State...

Thanks again to everyone who helped out with this. I used a combination of Bob and Ricks code and it woked out well. I appreciate all your help, patience and time.

This code works like a charm. Thanks to Bob , Rick and everyone who helped me with this problem. The code works perfectly for company. I need to clear the combo control before going to the next combo because the value is still stored and the records remain filtered for the first selection...

The following code gave me the results i need but now i need to work with 3 combo boxes and use the OR option how can i make it work. I use the company id and removed the or from the query. Private Sub cmdApplyFilter_Click() Dim strWHERE As String If Len(Me.cbocompany) > 0 Then...

Private Sub cmdApplyFilter_Click() Dim strWHERE As String If Len(Me.cbocompany & "") > 0 Then strWHERE =" [CompanyID] = " & '& Chr(34)& Me.cbocompany & Chr(34) & " Or "" End If Me.contactsubform.Form.Filter = strWHERE Me.contactsubform.Form.FilterOn = True...