Tupacmoche
Registered User.
- Local time
- Today, 13:30
- Joined
- Apr 28, 2008
- Messages
- 291
Hi Report Masters,
I have an Access report with a long text/Memo field column that keeps getting cut off. After doing research I found out that reports that are exported using the Database Tools -> Export ->Excel get truncated since the only export to older versions of Excel. This is true and clear as the only chooses are older versions. Is there any way around this? Some patch or something that will give access to the most current version of Excel? I also learned that if I run a query and export it I will be able to export to the latest version of Excel. I added a button to run the existing query as follows:
DoCmd.OutputTo acOutputQuery, "qry_Financial_Data", acFormatXLSX, , True
While this runs it does no filtering as when the report is selected from the menu. My question is does DoCmd.OutuptTo accept parameters to filter which report to run and any other filters that may be needed?
I have an Access report with a long text/Memo field column that keeps getting cut off. After doing research I found out that reports that are exported using the Database Tools -> Export ->Excel get truncated since the only export to older versions of Excel. This is true and clear as the only chooses are older versions. Is there any way around this? Some patch or something that will give access to the most current version of Excel? I also learned that if I run a query and export it I will be able to export to the latest version of Excel. I added a button to run the existing query as follows:
DoCmd.OutputTo acOutputQuery, "qry_Financial_Data", acFormatXLSX, , True
While this runs it does no filtering as when the report is selected from the menu. My question is does DoCmd.OutuptTo accept parameters to filter which report to run and any other filters that may be needed?