Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-12-2020, 12:07 PM   #1
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 505
Thanks: 323
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Print report in an Excel Format

Hello, can I print a Ms Access 2003 report in an Excel Format?

Thank you.
Crystal

access2010 is offline   Reply With Quote
Old 01-12-2020, 12:16 PM   #2
plog
Banishment Pending
 
Join Date: May 2011
Posts: 9,495
Thanks: 12
Thanked 2,305 Times in 2,256 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: Print report in an Excel Format

Layout it out that way in the report:

Field1Name | Field2Name | Field3Name | ...
___________________________________
Field1Value | Field2alue | Field3Value | ...
___________________________________
Field1Value | Field2alue | Field3Value | ...
___________________________________
Field1Value | Field2alue | Field3Value | ...
...
plog is offline   Reply With Quote
The Following User Says Thank You to plog For This Useful Post:
access2010 (01-12-2020)
Old 01-12-2020, 12:42 PM   #3
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 11,961
Thanks: 120
Thanked 3,331 Times in 3,005 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Print report in an Excel Format

Display the data in datasheet format which looks similar to an Excel worksheet.

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Colin (Mendip Data Systems)
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Spam, spam, spam, spam, spam, spam, spam (Terry Jones - RIP)
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
access2010 (01-12-2020)
Old 01-12-2020, 01:00 PM   #4
theDBguy
Iím here to help
 
theDBguy's Avatar
 
Join Date: Oct 2018
Location: SunnySandyEggo
Posts: 7,280
Thanks: 63
Thanked 1,683 Times in 1,638 Posts
theDBguy has a spectacular aura about theDBguy has a spectacular aura about
Re: Print report in an Excel Format

Hi Crystal. In case you don't want to modify the report or create a new one, you could consider exporting the report into Excel and then print it from there. Just a thought...
__________________
Just my 2 cents...

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
theDBguy is offline   Reply With Quote
The Following User Says Thank You to theDBguy For This Useful Post:
access2010 (01-12-2020)
Old 01-12-2020, 02:32 PM   #5
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 505
Thanks: 323
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Print report in an Excel Format

isladogs, isladogs and theDBguy

Thank you for your suggestions which we will try.

In the past Many, Many, Many +, years we could supply the Government With Paper Reports, but now we have been requested to send them the same reports previously sent in an Electronic format and preferable in Excel.

Do we have to be careful about the creation of these new Excel Reports as we prefer to create them perfectly the first time.

Any magic words of wisdom for this new venture?

Thank you,
Crystal
access2010 is offline   Reply With Quote
Old 01-13-2020, 03:30 PM   #6
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,390
Thanks: 15
Thanked 1,623 Times in 1,541 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Print report in an Excel Format

The "export to Excel" feature of Access is (and always has been) unsatisfactory to the point of being useless so, you just have to roll your own. If a simple list will suffice, then just use TransferSpreadsheet with column headings. If you want something fancier, you will need to use OLE automation or export to an Excel template and then use OLE to force the formatting macro to run. It really depends on whether you prefer to code the formatting in Access or in Excel. I generally use Access but since my Excel VBA is poor, I frequently export the data and open excel and turn on the macro recorder. After I have done all the formatting, I take the code generated by the macro recorder and bring it back into Access. Usually object references have to be adjusted because you are manipulating the cells from the perspective of Access rather than Excel but the changes are simple. The simplest solution, if the client will accept it is to print the report as a pdf. That retains all the formatting and doesn't require any coding.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
access2010 (01-14-2020)
Old 01-13-2020, 09:38 PM   #7
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 505
Thanks: 323
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Print report in an Excel Format

Pat Hartman (2020_Jan_14)
We will start working on your suggestion.

Thank you.
Nicole.

access2010 is offline   Reply With Quote
Old 01-14-2020, 02:21 PM   #8
sxschech
Newly Registered User
 
Join Date: Mar 2010
Posts: 631
Thanks: 31
Thanked 112 Times in 101 Posts
sxschech is on a distinguished road
Re: Print report in an Excel Format

If using vba, for excel export, another option is to use a query or sql statement and then copyfromrecordset. This will paste all the data at once into excel and you can specify the start location - such as B5 rather than A1.

Example below tells it to be pasted into row 3 col 1.
Code:
.Cells(3, 1).CopyFromRecordset rs
sxschech is offline   Reply With Quote
Old 01-14-2020, 02:27 PM   #9
June7
AWF VIP
 
June7's Avatar
 
Join Date: Mar 2014
Location: The Great Land
Posts: 2,625
Thanks: 1
Thanked 630 Times in 623 Posts
June7 will become famous soon enough June7 will become famous soon enough
Re: Print report in an Excel Format

Very simple report might export to Excel nicely but exporting query might be simpler.

Review http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm
__________________
Attach File Manager is below Advanced editor window, click Go Advanced below Quick Reply window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
June7 is offline   Reply With Quote
Old 01-14-2020, 06:04 PM   #10
access2010
Newly Registered User
 
Join Date: Dec 2009
Posts: 505
Thanks: 323
Thanked 0 Times in 0 Posts
access2010 is on a distinguished road
Re: Print report in an Excel Format

sxschech and June7

Thank you both for your suggestions which we are experimenting with.

Nicole

access2010 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Format & Print Code doesn't fire report papic1972 Reports 2 06-05-2013 04:24 PM
Print a Report in a Calendar Format JesseH Reports 2 04-06-2011 05:50 AM
Print report in pdf format Paul200968 Reports 5 04-26-2007 04:53 AM
Report Format/Print Problems lskuff Reports 0 11-16-2003 05:04 PM
How to print current record in report format Mansoor Ahmad Forms 7 03-13-2003 06:25 AM




All times are GMT -8. The time now is 02:45 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World