Hi , all

Is posible to have cover page in access report?
What i need is this:
----------- Scenario -----------------

In form Quotation i have 2 subform(maybe i need to make with one subform) in
first subF. is only one field (combobox) from where i select
supplier(Continuous Forms)i have add button so for one order user can select
more supplier.second subf.have two field(text box) number of attachment and
tape.
---------------------------------- end --------------------
Question :
I need report where on first page is gona be all  selected supplier, on each
next page (if i select 3 supplier is gona be 3 page) just one line nead to
change
Exsample:
page 2
TO:[Name of Supplier1]
From : Nikola
Date: 26/09/02
text.................

page 3
TO:[Name of Supplier2]
From : Nikola
Date: 26/09/02
text.................
page 4
TO:[Name of Supplier3]
From : Nikola
Date: 26/09/02
text.................
Thanks
Nikola

Hi Nikola,

It sounds like you want a Table of Contents kind of layout. Access can't
do tha easily but it can be done. Take a look at Knowledge Base Article
Q210269. The basic ideas are:

1. Create a seperate table in your database that will hold records
   for a table of contents report. The table will have two fields:
   one for supplier name, and one for the page of the report that
   that suppliers information appears on.
2. Create a seperate report for your table of contents page that will
   use the new table as its record source.
3. Use the OnOpen and OnPrint events of your primary report to populate
   the table of contents table using DAO or ADO. The knowledge base
   article provides the functions and function calls using DAO.
4. Print your table of contents report after your table of contents
   table has been populated.
5. Attach your table of contents report to your detail report.

Best,

Bob

>From: "Nikola" <Nikola@B...>
>Reply-To: "Access" <access@p...>
>To: "Access" <access@p...>
>Subject: [access] cover page on report
>Date: Thu, 26 Sep 2002 10:44:52 +0300
>
>Hi , all
>
>Is posible to have cover page in access report?
>What i need is this:
>----------- Scenario -----------------
>
>In form Quotation i have 2 subform(maybe i need to make with one subform) 
>in
>first subF. is only one field (combobox) from where i select
>supplier(Continuous Forms)i have add button so for one order user can 
>select
>more supplier.second subf.have two field(text box) number of attachment and
>tape.
>---------------------------------- end --------------------
>Question :
>I need report where on first page is gona be all  selected supplier, on 
>each
>next page (if i select 3 supplier is gona be 3 page) just one line nead to
>change
>Exsample:
>page 2
>TO:[Name of Supplier1]
>From : Nikola
>Date: 26/09/02
>text.................
>
>page 3
>TO:[Name of Supplier2]
>From : Nikola
>Date: 26/09/02
>text.................
>page 4
>TO:[Name of Supplier3]
>From : Nikola
>Date: 26/09/02
>text.................
>Thanks
>Nikola
>
>
>
>




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com