Recent content by eword

I worked it out. If you use Access 2010, when you add a new action in design view select ImportExportSpreadsheet. Then fill in the fields like this: Transfer Type: Export Spreadsheet Type: Excel Workbook Table Name: tblYourDatabaseTable File Name...

Ok can somebody just provide an example of how to use the macro ImportExportSpreadsheet to save a database table from access to a new spreadsheet with a given range.

I want to be able to do this using the macro builder in access, not VB. I know u can do this otherwise my tutor would not have set it as an assignment.

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...

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...

thanks. that solved it.

still the same issue. it opens a form in a seperate window. it does not display the details on the subform. im working in access 2007. i built the subform using the auto tool.

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...