Export filtered records
in [Form]
|
From: linda on 4 Dec 2009 15:44 Hi, I am trying to export certain records that have been filtered. When I export it to excel, save the file and then reopen the file all records are displayed in excel. I woul dlike only the records that I have filtered to export from Access to Excel. Any suggestions? Thanks Linda
From: fredg on 4 Dec 2009 18:30 On Fri, 4 Dec 2009 12:44:01 -0800, linda wrote: > Hi, > > I am trying to export certain records that have been filtered. > When I export it to excel, save the file and then reopen the file all > records are displayed in excel. I woul dlike only the records that I have > filtered to export from Access to Excel. Any suggestions? > > Thanks > Linda Exporting to Excel what? How? What version of Access? The simplest method to export filtered records is to create a query that contains just the records you want to export. Then export the query data. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QueryName", "C:\MyFolder\ASpreadsheet.xls", True -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail
From: linda on 8 Dec 2009 09:48 This is what my form does. I have an active control (excel sheet). All records are loaded on Open using a query. The user wil then use the filter feature on the excel sheet to filter out their results. From this point on, I would like the user to export the filtered info to Excel again from the active control. Once outputted to Excel, the user must save the file. However, when you go to open the saved file, all records are in the file rather than the filtered output. Linda "fredg" wrote: > On Fri, 4 Dec 2009 12:44:01 -0800, linda wrote: > > > Hi, > > > > I am trying to export certain records that have been filtered. > > When I export it to excel, save the file and then reopen the file all > > records are displayed in excel. I woul dlike only the records that I have > > filtered to export from Access to Excel. Any suggestions? > > > > Thanks > > Linda > > Exporting to Excel what? How? What version of Access? > The simplest method to export filtered records is to create a query > that contains just the records you want to export. > Then export the query data. > > DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, > "QueryName", "C:\MyFolder\ASpreadsheet.xls", True > > -- > Fred > Please respond only to this newsgroup. > I do not reply to personal e-mail > . >
|
Pages: 1 Prev: Wait Time Report Form Next: What's happened to the findfirst function in Access 2010? |