report not wide enough to make required Excel spreadsheet

[Guest]

I need to make an Excel spreadsheet with 30 or more fields which come from an
Access report. The Access report I make is max. 14 inches wide based on the
paper size as though I am printing on paper, but I am just using 'Office
Links' to create the spreadsheet.

How can I make my Access report wide enough to hold all of the fields?
There is a 'user defined' paper size, but how do I define the paper size?

 

[AnandaSim]

I need to make an Excel spreadsheet with 30 or more fields which come from an
Access report. The Access report I make is max. 14 inches wide based on the
paper size as though I am printing on paper, but I am just using 'Office
Links' to create the spreadsheet.

How can I make my Access report wide enough to hold all of the fields?
There is a 'user defined' paper size, but how do I define the paper size?

Don't use an Access Report. Make an Access Query and export that to
Excel. A Report width is limited by page size - but Excel doesn't
care.

On the other hand, have you thought of making the textboxes in the
Report narrower so that they fit within whatever paper size you set?

HTH
Ananda

 

[Guest]

Ananda,

Thanks for the answer to my question.

I stumbled on an answer to using a report quite by accident. I read an
ealier post on publishing a report to Excel, and in it was this line of code
"DoCmd.OutputTo acReport, "Acess ReportName",
acFormatXLS,"Path/FileName.xls",True ". I thought that would be nifty to
click a button in Access and have an Excel spreadsheet appear. So I coded
this, clicked the button, and lo and behold, my entire report appeared in
Excel! This procedure must bypass the paper size requirement in Access.

Whaddyathink? Does this qualify me to be an MVP?

Bob

 

[Larry Linson]

Whaddyathink? Does this qualify me to be an MVP?

The MVP program is described at http://mvp.support.microsoft.com.

The answer to your question is "No." Discovering functions that exist in
the software does not qualify; in fact, discoveries or brilliant solutins do
not qualify; MVP's are selected by Microsoft for their contriubtions to the
Microsoft software user communities in a number of different areas. Those
contributions have to be more than occasional, consistent, and helpful.

Beto Wing? Would that have anything to do with one of the Beto Units?

Larry Linson
Microsoft Access MVP
(no, not the same person who worked at Beto Unit in the past)

 

[Marshall Barton]

I stumbled on an answer to using a report quite by accident. I read an
ealier post on publishing a report to Excel, and in it was this line of code
"DoCmd.OutputTo acReport, "Acess ReportName",
acFormatXLS,"Path/FileName.xls",True ". I thought that would be nifty to
click a button in Access and have an Excel spreadsheet appear. So I coded
this, clicked the button, and lo and behold, my entire report appeared in
Excel! This procedure must bypass the paper size requirement in Access.

I have heard that approach won't work in A2007. I think it
was removed because it didn't work very well in earlier
versions (mostly because a report is not a data structure).

You really should follow Ananda's advice about exporting the
report's record source query.