If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
PROBLEM: Making form/report with a fixed no. of lines and variable no. or records
I understood.
Thank you!!! I think I didn't read with enough attention at first.Sory! "SA" wrote in message ... Chris: (HTML Deleted) Add a Group (using the sorting and grouping dialog) for the Product code and for the OrderID and be sure to set that each group has a group header. You don't need to have any data in these groups, it can all be in the headers and detail lines. Then click on the group header in design mode, bring up its properties and for the Force New Page property. Set it to before section. -- Steve Arbaugh MS Access MVP "Chris" wrote in message ... Thank you very much. I inderstood this part. But how about generating a new page for every new product code and eventualy every order ? This code must appear in the header, not in the report body. Like this (rich text-HTML): HEADER: Company .....................Order ................... Exit document Document numberDate PRODUCT CODENo. of items daymonthyear ............ ................. .......... ......... .......................... .......................... Crt. no. . The name and the characteristics of the materialAccountThe Code of the aterial Qt.Measurement unit Unit Price Total Price DebitorCreditor BODY(the values) 1.... 2.... 3.... 4. 5. 6. 7. FOOTER: Date: ........................ Department's chief signatureStock keeper signatureMaterial user's signature The beneficiary of the database, the chief of mechanical deparment wants even more repports on one A4 page, till fiting the dimension of the page (I sugested to use A5 pages with one report centered) Thank you, Chris "Steve Schapel" wrote in message ... Chris, Yes, you would have to set up a procedure to remove the blank lines and rewrite them to the table in response to changes in other data and requirements. I don't really see this is too much of a problem that you need to cater for this for each product. You will just have to work on getting the relevant Delete and Append queries set up correctly, and the procedures to run them. But in the end, you need 7 records in the table for each product, so the requirement will be, whenever there is a relevant change in the "real" data for one of the products: - a delete query to remove the "blanks" for that ProductID - obtain a count of the "real" records for that ProductID - an append query to add the required number of blanks for that ProductID -- Steve Schapel, Microsoft Access MVP Chris wrote: What if, after viewing that report I see that I forgot to add a record and I have to do it? I use a delete query to del. the "blank" lines, I add a record from the front end form and than add again "blank"lines? 2. One more BIG PROBLEM !!! I need to make this report multipage, and a new page for each new value for one of the parameters.(The database is for the stockpile, and these reports must be exit tickets for the materials from the storage. For any product -having a code- i take from the storage some materials.When that code is changed, it need to be generate a new page of the report, and any af them with 2, 3, 4 (maximum 7) lines written (as many materials are taken for that product code) and the rest of the lines, to 7, blanks. |
Thread Tools | |
Display Modes | |
|
|