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
|
|||
|
|||
filter a 1-page report
I use a form to select the record for a 1-page report
using a command button. The problem is that the 1-page report prints on 2 pages, and the second page of the report always has blank data (but headders etc. filled in.) Here's the code I use to launch the report preview: Dim stDocName As String strCriteria = "[client] = " & Chr(34) & Me!Client & Chr(34) DoCmd.OpenReport "WTN Statement", acPreview, , strCriteria Does it have something to do with the preview mode? Can I specify to print only page 1 in the code? Thanks! |
#2
|
|||
|
|||
filter a 1-page report
Please cancel this question. I found a page break in my
report. Sorry! -----Original Message----- I use a form to select the record for a 1-page report using a command button. The problem is that the 1-page report prints on 2 pages, and the second page of the report always has blank data (but headders etc. filled in.) Here's the code I use to launch the report preview: Dim stDocName As String strCriteria = "[client] = " & Chr(34) & Me!Client & Chr(34) DoCmd.OpenReport "WTN Statement", acPreview, , strCriteria Does it have something to do with the preview mode? Can I specify to print only page 1 in the code? Thanks! . |
Thread Tools | |
Display Modes | |
|
|