If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combo Box not displaying properly
I have a cbo (cboID_Start) that has the row source:
SELECT capture_id FROM dtGPSDataNew WHERE capture_id = 178 ORDER BY date_gps Capture_id is identified when the user selects it from a previous cbo (cbocapture_ID), and this simple code links them: Me.cboGPS_ID_start.RowSource = "SELECT capture_id FROM " & _" dtGPSDataNew WHERE capture_id = " & _ Me.cbocapture_id & _ " ORDER BY date_gps" After the user selects a value in cbocapture_id, and then goes to the cboID_Start box to select the data he/she wants, only the first column of 3 is visible. All records seem to be there, but only the bound (1st) column shows any data. The column widths are set adequately and I have tried to put that in the code too, just to make sure. cboID_start.ColumnWidths = "1cm;1.6cm;1.6cm" This doesn't seem to happen if the cbocapture_id box is empty (i.e. all columns show up with all data). But, as soon as the code runs, it affects the column views. I'm sure it's simple (obviously I don't do a tonne of this) and I'm missing something obvious. Help very much appreciated! Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Report Engine, Part 4 http://www.eggheadcafe.com/tutorials...ne-part-4.aspx |
#2
|
|||
|
|||
Combo Box not displaying properly
The SQL needs to include the other two column names.
SELECT capture_id, NameCol2, NameCol3 FROM dtGPSDataNew WHERE capture_id = 178 ORDER BY date_gps; This SQL statement has criteria to olny select capture_id = 178, so how can you really use it? -- Build a little, test a little. "Lori Robinson" wrote: I have a cbo (cboID_Start) that has the row source: SELECT capture_id FROM dtGPSDataNew WHERE capture_id = 178 ORDER BY date_gps Capture_id is identified when the user selects it from a previous cbo (cbocapture_ID), and this simple code links them: Me.cboGPS_ID_start.RowSource = "SELECT capture_id FROM " & _" dtGPSDataNew WHERE capture_id = " & _ Me.cbocapture_id & _ " ORDER BY date_gps" After the user selects a value in cbocapture_id, and then goes to the cboID_Start box to select the data he/she wants, only the first column of 3 is visible. All records seem to be there, but only the bound (1st) column shows any data. The column widths are set adequately and I have tried to put that in the code too, just to make sure. cboID_start.ColumnWidths = "1cm;1.6cm;1.6cm" This doesn't seem to happen if the cbocapture_id box is empty (i.e. all columns show up with all data). But, as soon as the code runs, it affects the column views. I'm sure it's simple (obviously I don't do a tonne of this) and I'm missing something obvious. Help very much appreciated! Submitted via EggHeadCafe - Software Developer Portal of Choice WPF Report Engine, Part 4 http://www.eggheadcafe.com/tutorials...ne-part-4.aspx . |
#3
|
|||
|
|||
It works - thanks!
Fabulous! See? - so easy, but I just didn't know where to put that information! Thanks a lot.
Also, I guess I shouldn't have included the row source information because that's defined in the VB code anyway, and it's dependent on what I put in the first combo box (I had 178 in the first box when I copied the row source information). Anyway, your solution is perfect - thanks so much ... slowly, slowly learning! KARL DEWEY wrote: The SQL needs to include the other two column names. 22-Apr-10 The SQL needs to include the other two column names. SELECT capture_id, NameCol2, NameCol3 FROM dtGPSDataNew WHERE capture_id = 178 ORDER BY date_gps; This SQL statement has criteria to olny select capture_id = 178, so how can you really use it? -- Build a little, test a little. "Lori Robinson" wrote: Previous Posts In This Thread: Submitted via EggHeadCafe - Software Developer Portal of Choice Excel 2007 Filter Tool http://www.eggheadcafe.com/tutorials...lter-tool.aspx |
Thread Tools | |
Display Modes | |
|
|