Ctrl+Enter in a text field

[mission2java_78]

Why not just format the report as you need it in the spreadsheet? I do this all the time. I just leave the data on the report with basically no formatting, or space between your controls on the report. If you also need a formatted report, just make two, one with the formats for printing, and one without for exporting into excel.

Ya right...if only life was that simple on the user end...
The point of this is the original thread by gblack was to have
the preformatted done for the end user. See end users arent as smart as you...some dont know excel..others dont want to do any additional work..therefore the way around this would be programmatically.

Jon

 

[JimAhl]

Sorry, I guess I missed the original gist of the thread. I guess there is no easy way to get it done.

If only users were more like us!!! ha ha

 

[MeeksNikiyaM]

I am having the same problem now. I saw the SQL statement that was posted, but where would I use that (in Excel or Access).

My problem is I have a report that needs to be sent as an Excel attachment in an email. I have the report already made in Access and I have calculated fields and a filter on the report as well.

I am a newbie to these kind of problems, so can somebody help me figure out how to get my information into Excel

Thanks for your help in advance!

 

[MeeksNikiyaM]

And where is this Excel object model? I didn't know there was a way to export the report into Excel. Will someone please email me a copy of the code to allow me to do this? Thanks,

meeksnikiyam@uams.edu

 

[gblack]

Thanks

Looks good Thanks Pat...I'll try it.
Gary