Report in datasheet view

[pablavo]

Hi There,

Just as the title suggests, is there a way to open a report in Datasheet (Basically a query view).

I'd just set up a query, however, I need to put underlying code into the report so that I can automate opening other objects when the report closes.

I also need it to be in the form of a query so that people can cut and paste it into Excel?

Does one of the methods do this?

Thanks

 

[Pat Hartman]

You can export to excel directly. Add that as an option to your form and use the TransferSpreadsheet method to do it. That will allow the user to either open a form or a report and that way you can make your report format however you want it.

 

[pablavo]

Thanks Pat, that's actually good to know since the cell range goes strait along a line within the excel template. I noticed the cell range can be specified with the method

Cheers

 

[Pat Hartman]

I don't think the cell range can be specified on output. Check the help entry. If you need to poke values into specific cells, you'll need to use VBA.