Search results

  1. E

    Export from access to excel worksheet

    Hi, How would I create a macro that exports data from an Access 2010 database table to a specific worksheet in an excel file. So far I have tried using ImportExportSpreadsheet with no success. Ideally what I would like the macro to do is export a table to a worksheet in an excel file and then...
  2. E

    Date Query ...

    I have a stored sql query which should return information between dates set in a table called TblReportDates. These dates are [Start Date] and [End Date]. The issue I have is that each time I run the query it prompts me for the values of [Start Date] and [End Date] rather than using what is...
  3. E

    bind recordset to subform

    Hi, I am learning microsoft access and i was trying to work out how i can display the results of a query in a subform. my code is as follows: Dim con As ADODB.Connection Dim recSet As Recordset Dim strFrmNm As String Dim sqlQuery As String Set recSet = New...
Top Bottom