Actually and surprinsingly, Excel and Word receive from an Access report
more than the records of the query. Usually, the titles, subtotals are also
printed, with most of the design of the report.

According to the user who had the problem yesterday, the problem is that
Access keeps the first disposition of the fields that the report wizzard
makes, and does not take into account the changes the user does latter. i
don't think i shall know more about this problem...

It's always hard to understand what a wizzard really does. Better not using
them :-)

Thank you

GC


  _____ 

De : [email protected] [mailto:[EMAIL PROTECTED] De la part
de John Viescas
Envoyé : mardi 23 mai 2006 16:25
À : [email protected]
Objet : RE: [ms_access] Exporting a report toward Excel or Word


Gilbert-

When you export a Report to Excel, I believe you're only exporting the
underlying Record Source, not what you have formatted in the report.  Does
the query export OK?  And how are you trying to export to Word - in RTF
format?

John Viescas, author
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
Running Microsoft Access 2000
SQL Queries for Mere Mortals
http://www.viescas.com/ <http://www.viescas.com/>
(Paris, France)
For the inside scoop on Access 2007, see:
http://blogs.msdn.com/access/ <http://blogs.msdn.com/access/>


-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Clauss Gilbert
Sent: Tuesday, May 23, 2006 3:40 PM
To: [email protected]
Subject: [ms_access] Exporting a report toward Excel or Word

Has anybody an explanation for that ?

a report, based on a query (both work fine).
But, when i want to export the report to MS-Excel or MS-Word, the result is
upside down : some columns disapear, or do not appear in the same order.

Thank you for help

Gilbert Clauss


[Non-text portions of this message have been removed]





Yahoo! Groups Links











  _____ 

YAHOO! GROUPS LINKS


     
*      Visit your group "ms_access
<http://groups.yahoo.com/group/ms_access> " on the web.
 

*      To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
 

*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


  _____ 




[Non-text portions of this message have been removed]



YAHOO! GROUPS LINKS




Reply via email to