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
available fields are blank when trying to create a report =?Utf-8?B?R09T?= Microsoft Access Reports 1 21st Jun 2006 10:00 AM
blank line in a query for blank lines in a report Sandi Microsoft Access Queries 4 4th Jan 2006 08:12 PM
create blank report with field headings to be completed online =?Utf-8?B?Y29hbA==?= Microsoft Outlook Discussion 0 12th Oct 2005 01:46 AM
trying to create a blank police report to use on a webpage =?Utf-8?B?amNkY2ZveA==?= Microsoft Word Document Management 1 11th Jul 2005 05:57 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 12:07 PM.