PC Review


Reply
Thread Tools Rate Thread

create a blank report

 
 
iccsi
Guest
Posts: n/a
 
      15th Sep 2011
I need print a blank report.
All MS Access report print with data.
Are there any way to print blank report format only?

Your help is greate appreciated,


 
Reply With Quote
 
 
 
 
Access Developer
Guest
Posts: n/a
 
      16th Sep 2011
How much space do you want to allow where the data would normally be
displayed? Do you want to display all the Label controls that are defined?
What are you trying to accomplish with a "blank report format"? What is the
Record Source of your Report, a Table or a Query (and if the latter, pls.
describe).

(A) If you want enough space to show all the data (which seems unlikely),
you could set the Visible property of each Control that displays data to
"No" and run the Report, or

(B) If you want to show just the blank Report for a single record, do as in
(A) above, and create a TOP 1 Query for the Record Source of the Report to
extract just one Record.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"iccsi" <(E-Mail Removed)> wrote in message
news:d8b5268d-a785-4e44-8348-(E-Mail Removed)...
>I need print a blank report.
> All MS Access report print with data.
> Are there any way to print blank report format only?
>
> Your help is greate appreciated,
>
>



 
Reply With Quote
 
 
 
 
iccsi
Guest
Posts: n/a
 
      18th Sep 2011
Thanks for helping,
I just wanted to print blank form for demo purpose to show our
department what our report format looks like, because the data are
confidential, so I just want to print blank form,
Thanks again,




On Sep 16, 5:10*pm, "Access Developer" <accde...@gmail.com> wrote:
> How much space do you want to allow where the data would normally be
> displayed? *Do you want to display all the Label controls that are defined?
> What are you trying to accomplish with a "blank report format"? *What is the
> Record Source of your Report, a Table or a Query (and if the latter, pls.
> describe).
>
> (A) If you want enough space to show all the data (which seems unlikely),
> you could set the Visible property of each Control that displays data to
> "No" and run the Report, or
>
> (B) If you want to show just the blank Report for a single record, do as in
> (A) above, and create a TOP 1 Query for the Record Source of the Report to
> extract just one Record.
>
> --
> *Larry Linson, Microsoft Office Access MVP
> *Co-author: "Microsoft Access Small Business Solutions", published by Wiley
> *Access newsgroup support is alive and well in USENET
> comp.databases.ms-access
>
> "iccsi" <inu...@gmail.com> wrote in message
>
> news:d8b5268d-a785-4e44-8348-(E-Mail Removed)...
>
>
>
> >I need print a blank report.
> > All MS Access report print with data.
> > Are there any way to print blank report format only?

>
> > Your help is greate appreciated,- Hide quoted text -

>
> - Show quoted text -


 
Reply With Quote
 
Access Developer
Guest
Posts: n/a
 
      18th Sep 2011
I suggest you create one record of sample, not actual data, and print the
sample report using that sample data... that will give them a better idea
of how the report will actually look.

I recommend that you split your user interface and data, and use a separate
database of test data for development.

You'll find information on splitting the front end and back end at MVP Tony
Toews' site and former MVP (now on the Access team at Microsoft) Jeff
Conrad's site, both listed along with other useful references at
http://sp.ntpcug.org/accesssig/.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

"iccsi" <(E-Mail Removed)> wrote in message
news:2e0bbd28-fb2e-497c-b7a3-(E-Mail Removed)...
Thanks for helping,
I just wanted to print blank form for demo purpose to show our
department what our report format looks like, because the data are
confidential, so I just want to print blank form,
Thanks again,




On Sep 16, 5:10 pm, "Access Developer" <accde...@gmail.com> wrote:
> How much space do you want to allow where the data would normally be
> displayed? Do you want to display all the Label controls that are defined?
> What are you trying to accomplish with a "blank report format"? What is
> the
> Record Source of your Report, a Table or a Query (and if the latter, pls.
> describe).
>
> (A) If you want enough space to show all the data (which seems unlikely),
> you could set the Visible property of each Control that displays data to
> "No" and run the Report, or
>
> (B) If you want to show just the blank Report for a single record, do as
> in
> (A) above, and create a TOP 1 Query for the Record Source of the Report to
> extract just one Record.
>
> --
> Larry Linson, Microsoft Office Access MVP
> Co-author: "Microsoft Access Small Business Solutions", published by Wiley
> Access newsgroup support is alive and well in USENET
> comp.databases.ms-access
>
> "iccsi" <inu...@gmail.com> wrote in message
>
> news:d8b5268d-a785-4e44-8348-(E-Mail Removed)...
>
>
>
> >I need print a blank report.
> > All MS Access report print with data.
> > Are there any way to print blank report format only?

>
> > Your help is greate appreciated,- Hide quoted text -

>
> - Show quoted text -



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create duplicate report? (Copy of report, not report of dup iynque Microsoft Access Reports 1 5th Jun 2009 08:54 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... amorrison2006@googlemail.com Microsoft Excel Programming 2 7th Jun 2007 09:27 PM
blank line in a query for blank lines in a report Sandi Microsoft Access Queries 4 4th Jan 2006 09:12 PM
Blank Sender, Blank Subject, Blank Body =?Utf-8?B?c2luMTQ3MA==?= Microsoft Outlook Discussion 2 4th Nov 2005 02:02 PM
Create blank report =?Utf-8?B?Tmljaw==?= Microsoft Access Reports 2 30th May 2005 03:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:52 PM.