Search results

Hello Guys, Here is my code: Dim rs As ADODB.Recordset Set rs = New ADODB.Recordset Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection rs.ActiveConnection = cnn rs.LockType = adLockReadOnly rs.CursorType = adOpenDynamic Dim strSQL As String 'Define Query and Run it 'CASE 1: For...

Hello, I need to build a form which contains groups of combo boxes. Each group contains two or more (cascading) combo boxes which take in data from a single table . Now I need to build the queries in such a way that the user can select different choices from different "groups of comboboxes"...

I have the foll click() for a combo box Private Sub cmbFilter_Option_1_Click() Dim widthmenu, listoptions listoptions = Array("tirewidth", "aspectratio", "rimradius", "LoadIndex", "SpeedSymbol") list1 = listoptions(0) list2 = listoptions(1) List3 = listoptions(2) list4 = listoptions(3) list5...

well, I am using lstFilter on the same form, Dim listarrary, list1 ... .... If Me.lstFilter_Option_1 = "list1" Then lstFilter.AddItem(list1) It works now.

Sorry, but I did not quite understand tht. However, I tried this, but i am getting run time error for object not detected. Private Sub lstFilter_Option_1_Click() Dim listarrary, strcriteria As Variant Dim list1 As Variant listarray = Array("tirewidth", "aspectratio", "rimradius", "SS") list1...

Hey All, I have a listbox in one form: lst_filter_option1 which has several items. I would like to add each item as a filter to another listbox : lst_Filter. Now, based on the items added to lst_Filter, I would like to subsequently run a query. Also, the items in lst_filter_option1 are...

Hello, I am currently using these lines for extracting a ">" value in one combo box to "value" from another combo box.However. I would like to use only 1 query and pass the combo box options to the query I create to get my results. This is what I am using currently for >=, similarly for < and...

Sorry but I did not get you. Are you looking for the VBA code from my side?

Well, thanks for the suggestion. But I think I would have to manually add Cnt:" " for every possible cluster which can be formed. But since I have a huge database, this would not be feasible,that is if I understand your answer correctly. Do you think it is possibleto write a VBA code which...

No problem. I just posted a new one with more details. Thanks!

Hello, I need to filter some data from a huge table having many fields records. Since I am using it for an engineering application, I need to build categories or clusters of tyres which have similar properties over a wide range of Fields, but differ only in one or more.. For example, I have...

Hello Sir, I need to filter some data from a huge table having many fields records. Since I am using it for an engineering application, I need to build categories or clusters of tyres which have similar properties over a wide range of Fields, but differ only in one or so. What would be the...

Ahh,,,why didn't I think of that..Thanks again..

Ok. I have found a crude solution by just displaying the ET no, as the first Field in the Query. So I am okay with that. Thanks!

Well, the column count was set to 1. Now when I changed the value to say 5, I am able to display Column(0) through Column(5). So I got t the point. As for normalizing the table, I will look into it. Is there any way to show only 1 out of 100 fields in the listbox ? Thanks!

Hello, I could not understand how to use the filter. I tried the following alternative...but it worked partially... Private Sub Open_Click() \\ I am using a button control to select ETO no. and fill other fields in the form... Dim etoselect As Variant ' Set variable etoselect to the...

Hello, I got the code working almost immediately after checking out the links. Thanks! Now, I was wondering if its possible to select various fields from a table based on just one of the fields. case in point, after I have selected my ETO from a listbox, I would like to populate a lot of...

Thanks mate. I think this should help! I'll get back to you if needed..

Hello, I am using a ListBox(Combo12) which contains values of ETO from a query[ID-ETO]. I have selected the ETO field from the table [List] to populate my ListBox. The combo12 is on form named [MainForm]. Now, I have another form [Form_1] which has several textboxes including the ETO, etc. all...