Search results

  1. C

    exporting numbers to text file

    Does anyone know why when I export Numbers (double) from a table to a text file it exports to only 2 decimal places Thanks
  2. C

    Split function

    Can someone tell me why the VB "split" function does not work for me. What reference library do you need on?
  3. C

    Choosing max number from 2 fields

    Hi, How do you use the MAX function on 2 fields in SQL to then produce the result a new field. i.e 12, 24 would go to: 12, 24, 24 << this is the max of fields 1 & 2 Cheers
  4. C

    Populating listbox with Excel worksheet names

    Hi, I am trying to populate a listbox with Excel worksheet names from a ADO connection to a spreadsheet. What property do I need bring up the worksheet index and then find out the name of that sheet. Is it somehow possible to do this or do you have to use a different approach? Thanks
  5. C

    Use ADO to check if Table exists

    Does anyone know have to check in an access database if a table already exists with ADO? Thanks
  6. C

    ADO problems in Access 97

    Hi I'm just starting out using ADO in access but I can't get the code to compile in Access 97. The first part of the code is: Option Compare Database Option Explicit Private Sub Command0_Click() Dim cnn As New ADODB.Connection Dim rst As New ADODB.Recordset Dim curdb As Database Set curdb =...
  7. C

    Refresh Combo Box based on Query

    If I had a Refresh Combo Box on a form based on query and I then changed some of the data in one of the table relating to the query how do you get the combo box to update it's values. Cheers
  8. C

    Refresh Combo Box based on Query

    If I had a Refresh Combo Box on a form based on query and I then changed some of the data in one of the table relating to the query how do you get the combo box to update it's values. Cheers
  9. C

    Number matching with SQL

    This is more relating to SQL statements in Access but its use is in a VB app. If I had 2 tables each with similar data i.e ID Num 1 1.2 2 2.5 3 0.9 4 6.7 5 8.5 is it possible to match the numbers values to the other corresponsing number values in the other table with the match...
  10. C

    Data comparison and alignment

    Hi I have a set of data that is stored in 1 table 'Grass_data'. There are multiple sets of data in the table (18 to precise) each with a x and y value (size and height). The hard part for me is that I need to make comparison of one sample against another by matching peaksize from 1 sample to...
Back
Top Bottom