Search results

Hi Guys, I have a form, named frmResult and a listbox, lstResult. I also have a tab control called tabfirst, which has a textboxes txtrecord1, txtrecord2,..txtrecord5. I would like to multi select rows from my listbox, and have Me.lstResult.Column(1) value populate in the...

I have the following If..Else statement. Now, I would like to build the individual sections based on user criteria. I would like to know if it is possible to save thes sections as strings and add them to the if else statement. I have tried the same for Select...Where statement by building...

Hi, How to add filter control to column heads(i.e. Fields) of a listbox in a form in access, just as we have filter options in an access table or excel sheet ? Any DB examples or associated URLs would be great on this topic... Thanks,

Hi, I have the foll. querydef, which using a table Gd, which is already clustered based on a similar querydef. SELECT Gd.Count, Gd.Field2, Gd.Field3, Gd.Field13, Gd.Field15, Gd.Field15_2, Gd.Field23, Gd.Field31, Gd.Field35, Gd.Field36, Gd.Field41, Gd.Field45, Gd.Field46, Gd.Field51...

I am getting a syntax error for the If statement in the foll. code. where rs_cluster is a recordset. I am not able to figure out how to use the Between function to check for values of Field36 between a certain range shown below. Dim curF15_2, curF31, curF35, curF36, curF46, curF57, curF58...

Hello All, I have the foll code: I would like to update the "Count" Field based on value of "Field2". I am getting an error for the rs_cluster.EditMode. Please let me now if my If block makes sense or is it only a syntax errro ? Private Sub cmdCluster_Click() Dim rs_cluster As ADODB.Recordset...

Hello Guys, I have the foll statement: If (Me.cmb_firststage = "1st Stage Drum" And Me.cmb_firststage_elements = "shoulder contur or EST" And Len(Nz(cmb_firststage_elements_values, "") > 0)) Then strwhere = "WHERE (( [List].[Field11])= txtvalue);" Here...

Hello All, I am using the foll. code to populate my combo box. Private Sub cmb_firststage_Click() Dim rs_main As ADODB.Recordset Set rs_main = New ADODB.Recordset Dim cnn_main As ADODB.Connection Set cnn_main = CurrentProject.Connection rs_main.ActiveConnection = cnn_main rs_main.LockType =...

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...

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...

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, 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...