Search results

  1. T

    Adding single quotes to dataset fields ready for input to table

    I'll give that a try, thanks. I used the CType method to try to convert the dataset to a string but that only worked when I drilled down to the individual dataset row items so it ended up being rather a long piece of code! Andrew
  2. T

    Adding single quotes to dataset fields ready for input to table

    Yeah, I'm looking into trying that now. I've converted my code to read... ... Dim dsCounter AsInteger Dim ImportString, FItemArray, strTemp AsString With MyDataSet400.Tables(0) For dsCounter = 0 To .Rows.Count - 1 'loop strTemp = CType(MyDataSet400.Tables(0).Rows(dsCounter), String)...
  3. T

    Adding single quotes to dataset fields ready for input to table

    Hi I have a dataset (MyDataSet400) which I use as input to a SQL table called tblDRAAS400. I use the following code to loop through the dataset to populate the table. This works fine until one of the fields in the dataset contains an single quote, i.e. “O’BRIEN”. Here’s my code: Dim...
  4. T

    DataGrid - formatting a cell based on criteria

    Hi I’ve done some searching on DataGrids but I’m having trouble finding exactly what I need. Basically, I want to test each cell in a specific column for matching criteria and if matches, then change the colour of that cell. I have found out how to test all cells but I can’t pin down a...
  5. T

    Populating combo box via list box

    Hi I have a listbox called lstTableNames, which returns a list of all of the tables in my database. When I select the table in the list box, I want a combo box to return all of the fields in the selected table. For example, if I select “company” (a table in my database) from the listbox, I...
Top Bottom