Rabu, 02 Mei 2012

RE: [MS_AccessPros] Re: Report to Excel

 

Robin-

After you do the export, you need to open the workbook in Excel, increase the
Row Height, then save it. The code in Excel looks something like:

objSheet.Cells.Select
objSheet.Selection.RowHeight = 80 ' or some number tall enough to display
all the "rows" in the cells
objWkbk.Save

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

------------------------------------

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Thursday, May 03, 2012 1:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Re: Report to Excel

 
The problem starts before the report.

This is my version of your SQL:

SELECT [NameOfClub] & Chr(13) & Chr(10) & [Postal] & Chr(13) &
Chr(10) & [Meets] & Chr(13) & Chr(10) & [PlaceMeet] & Chr(13) &
Chr(10) & [Chartered] & Chr(13) & Chr(10) & [SponsoredBy] & Chr(13) &
Chr(10) & [EmailAddress] AS Entry
FROM qClubs;

I have loaded a screen capture here:

<http://www.rotary9790.org.au/test/test.asp>http://www.rotary9790.org.au/test/te
st.asp

Robin

At 3/05/2012 09:01 AM, you wrote:
>What exactly is your SQL? Are you sure the rest of it isn't just
>hidden below? It can be hard to see a multi-line result directly in
>the query. Try basing a report on that query and either make sure
>the textbox is long enough to show it or that the Can Grow property
>is Yes. I tested that and it produced the expected result, but if
>you just looked at the query you'd only see the first field unless
>you made the rows taller.
>
>Paul
>
>
>--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
><robinski@...> wrote:
> >
> >
> > Thanks Paul,
> >
> > Does not work for me. It shows only the first field in the result.
> >
> > Robin
> >
> > At 2/05/2012 09:19 AM, you wrote:
> > >I'd probably use automation, but a simpler method would be to export
> > >a query that had a single field:
> > >
> > >NameOfClub & Chr(13) & Chr(10) & Postal & Chr(13) & Chr(10) & etc
> > >
> > >Untested, but that should create a single field with the data
> fields vertical.
> > >
> > >Paul
> > >
> > >--- In MS_Access_Professionals@yahoogroups.com, Robin Chapple
> > ><robinski@> wrote:
> > > >
> > > > I have a club report with this SQL:
> > > >
> > > > SELECT qClubs.NameOfClub, qClubs.Postal, qClubs.Meets,
> > > > qClubs.PlaceMeet, qClubs.Chartered, qClubs.SponsoredBy,
> qClubs.EmailAddress
> > > > FROM qClubs;
> > > >
> > > > I have made a report where the data shows as:
> > > >
> > > > NameOfClub
> > > > Postal
> > > > Meets
> > > > PalceMeet
> > > > CharteredBy
> > > > EmailAddress.
> > > >
> > > > I need an XLS version in that format.
> > > >
> > > > If I use 'Export' the data shows in the format:
> > > >
> > > > NameOfClub, Postal, Meets, PalceMeet, CharteredBy, EmailAddress.
> > > >
> > > > How do I arrive at an Excel output in the vertical list format?
> > > >
> > > > Many Thanks,
> > > >
> > > > Robin Chapple
> > > >
> > >
> > >
> > >
> > >
> > >------------------------------------
> > >
> > >Yahoo! Groups Links
> > >
> > >
> > >
> >
>
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar