Report in datasheet view

pablavo · Jul 1, 2008

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 · Jul 2, 2008

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 · Jul 7, 2008

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 · Jul 7, 2008

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.

Report in datasheet view

pablavo

Registered User.

Pat Hartman

Super Moderator

pablavo

Registered User.

Pat Hartman

Super Moderator

Similar threads

Users who are viewing this thread