Access report preview and print only the first page
in [General]
|
From: jmslab01 on 22 May 2010 05:57 Hello, I'm using 2 buttons for reporting counted values from a tableform. The counted values are the results of all records and the report now shows as much pages as there are records. On each page the same data is reported. Problem now is that when the user push on printreport then...... he got a lot of (the same)pages. Till now I solve it to say.... only print the first page. Is there an option that the report shows only page 1 of 1, so the user can only print this one. Below the macro linked to 2 buttons for the same report. ---------------------- 'Based on the filter: DoCmd.OpenReport "RExxx", acPreview, , Me.Filter Reports!RExxx.OrderBy = Me.OrderBy Reports!RExxx.OrderByOn = True ---------------------- 'Based on all records: DocName = "RExxx" DoCmd.OpenReport DocName, A_PREVIEW ---------------------- help me out please,.... regards, Johan.
From: Duane Hookom on 22 May 2010 13:18 Isn't the actual problem with the report that prints the same records/values over and over? I would try to fix this so you wouldn't have to worry about too many pages printing with your macro. You might want to provide more information about your report's record source and what you mean by "tableform" and "counted values are the results of all records". Are there subreports? -- Duane Hookom Microsoft Access MVP "jmslab01" wrote: > Hello, > > I'm using 2 buttons for reporting counted values from a tableform. > The counted values are the results of all records and the report now > shows as much pages as there are records. > On each page the same data is reported. > > Problem now is that when the user push on printreport then...... he > got a lot of (the same)pages. > Till now I solve it to say.... only print the first page. > > Is there an option that the report shows only page 1 of 1, so the user > can only print this one. > > Below the macro linked to 2 buttons for the same report. > ---------------------- > 'Based on the filter: > DoCmd.OpenReport "RExxx", acPreview, , Me.Filter > Reports!RExxx.OrderBy = Me.OrderBy > Reports!RExxx.OrderByOn = True > ---------------------- > 'Based on all records: > DocName = "RExxx" > DoCmd.OpenReport DocName, A_PREVIEW > ---------------------- > > help me out please,.... > > regards, > Johan. > . >
From: Larry Linson on 22 May 2010 13:22 A start on the information we need to help you would include "what is the data, how is it arranged, and what does 'counted values' and 'tableform' mean?" When you say "user push on printreport", do you mean the user clicks on a Control on a Form? If you only want to report a Sum, or a Count, you can use a Totals Query to obtain those, and use that Totals Query as the Record Source of the Report. Create the Query with the Query Builder including the Field you want to Sum or Count, then click View | Totals to create a totals Query -- choose the proper option beneath the Fields in the Totals Query. -- 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 "jmslab01" <jmslab01(a)xs4all.nl> wrote in message news:5cbbd5ea-a2ed-49af-be5e-26426d60935c(a)j27g2000vbp.googlegroups.com... > Hello, > > I'm using 2 buttons for reporting counted values from a tableform. > The counted values are the results of all records and the report now > shows as much pages as there are records. > On each page the same data is reported. > > Problem now is that when the user push on printreport then...... he > got a lot of (the same)pages. > Till now I solve it to say.... only print the first page. > > Is there an option that the report shows only page 1 of 1, so the user > can only print this one. > > Below the macro linked to 2 buttons for the same report. > ---------------------- > 'Based on the filter: > DoCmd.OpenReport "RExxx", acPreview, , Me.Filter > Reports!RExxx.OrderBy = Me.OrderBy > Reports!RExxx.OrderByOn = True > ---------------------- > 'Based on all records: > DocName = "RExxx" > DoCmd.OpenReport DocName, A_PREVIEW > ---------------------- > > help me out please,.... > > regards, > Johan.
|
Pages: 1 Prev: Fehler b Auswerten einer Funktion, eines Ereignisses oder eines Ma Next: Snel geld verdienen |