Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-12-2018, 05:55 PM   #1
GrunleStan
Newly Registered User
 
Join Date: Aug 2018
Posts: 22
Thanks: 27
Thanked 1 Time in 1 Post
GrunleStan is on a distinguished road
How do you fill out a table based reports ?

I have 2 styles of reports. Both of these reports will have its summaries in a table form.

I basically have to 2 problems.
1. Best way to fill the numbers. I can do it as a form and export it out to an excel or PDF but that is not a report

2. How do I force a report in to Landscape mode ?

Thanks in Advance.
Attached Files
File Type: zip ReportSample.zip (256.4 KB, 11 views)


Last edited by GrunleStan; 09-12-2018 at 05:57 PM. Reason: forgot to add zip.. & to be polite..
GrunleStan is offline   Reply With Quote
Old 09-12-2018, 06:37 PM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,340
Thanks: 0
Thanked 737 Times in 722 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: How do you fill out a table based reports ?

Set the property to landscape in design mode.
Then print to PDF:
Docmd.output ....
Ranman256 is offline   Reply With Quote
Old 09-12-2018, 11:17 PM   #3
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,085
Thanks: 110
Thanked 2,739 Times in 2,500 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
Re: How do you fill out a table based reports ?

Set the orientation to landscape in design view using the page setup ribbon.
Save,

That's it! No need to save to XPS or PDF ... unless you want to do so.

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

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.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
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.
isladogs is offline   Reply With Quote
Reply

Tags
reports , vba code

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto-Fill Fields based on Linked Table (Access 2007) LWoods Tables 3 01-06-2015 12:42 PM
Compare/update query needed to auto fill table with categories based on a second tabl msasteel Introduce Yourself 1 11-21-2014 03:01 PM
Output Individual Reports based on the table records suw485 Reports 1 09-26-2010 07:22 AM
auto-fill based on table value ga11ardo Reports 0 11-13-2007 03:06 PM
Fill a field based on a lookup table Kashmir General 1 07-23-2002 01:31 AM




All times are GMT -8. The time now is 11:58 PM.


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 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World