Search results

  1. Y

    select unique record

    I want to select unique country names from a recordset and now my code is strSELECT = "select distinct country" The problem is that ASIA and Asia are different, but it only selects one.How can I include both of them?
  2. Y

    Copy records with empty value

    I have designed a UserForm in Excel, the aim is to copy selected records from Access to Excel. The database in Access is like: Calendar Country Type Index ... ... ... ... The problem now is there are records with empty Index value, and when I select these records, an error message comes out...
  3. Y

    Pull data from Access with SQL---Urgent

    I have designed an UserForm in Excel, the aim is to copy selected data from Access (tblIndex) to Excel. The UserForm contains a ListBox "ListCountry" and a ComboBox "ListType" to select country and type, and a ListBox named "ListCT" with two columns for selected country and type, and two TextBox...
  4. Y

    SQL- select record from Access

    I have designed an UserForm in Excel, the aim is to copy selected data from Access (tblIndex) to Excel. The form of the Access database is as following: Country Type Date Index ....... ...... ...... ...... The UserForm contains a ListBox "ListCountry" and a ComboBox "ListType" to select country...
  5. Y

    Select unique record

    Thanks in advance for your help. I have an Access database and the record is like this: Date Country Type Index 1.1 Canada A 2.1 Canada A 3.1 Canada A 4.1 Canada A 5.1 Canada A 6.1 Canada A 1.1 US A 2.1 US A 3.1 US...
  6. Y

    import date from Excel to Access?

    Hi, I want to transfer an excel spreadsheet to Access, which contains several sheets. Could anyone tell me how to refer to each sheet when using VBA? Many thanks.
Back
Top Bottom