Exporting to Excel from Form

[AccessDummy77]

Sorry this is probably really easy but I'm pulling a blank



In the spirit of the World Cup, I'll explain the form I created.

In a drop down list I have Ronaldo, Messi and RVP.

When I click RVP I have Text Boxes that show his information like

Club Team - Manchester United
International Team - Netherlands

etc.

How can I export the text boxes that describe the player into excel. I know how to export the back end table/query it pulls the data from for all players but don't know how to do it on an individual level.

Thanks in advance!

[ranman256]

Take the query you are using to get the data then a button to export the data:

vFile = "c:\myfolder\worldcup.xls"
 DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qsMyQry", vFile, True

[AccessDummy77]

If I do that, will it export everything from the query? In that example I would only want to export out RVP's information that is showing and not the rest of the query (like Messi's, Ronaldo's, etc)

Take the query you are using to get the data then a button to export the data:

vFile = "c:\myfolder\worldcup.xls"
 DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qsMyQry", vFile, True

[June7]

It will export all records returned by the query. Need to apply filter in query.

Or open a filtered report and export the report.