CODE TO PRINT REPORT HEADING ON EVERY PAGE

[Brianus]

Hello intellects,
Please, what's the appropriate VB code to print my report heading on every papge when printing?
Thanks all for your anticipated help.
BM.

 

[Andrzejek]

And you are using Crystal Reports, Word, Excel, ... ?


Have fun.

---- Andy

 

[Brianus]

some of the reports will be coming from MS Access tables and some from excel.
Thanks.
BM.

 

[Andrzejek]

.... and the Report itself will be displayed in ..... what?

Have fun.

---- Andy

 

[Brianus]

The report will be generated thru VB (By clicking on a command button on a VB form)
Thanks.

 

[Andrzejek]

OK, you are in VB, you click on a command button, data is comming from Access and/or from Excel, and the report is going to a XXX document.

Fill XXX:
a. MS Word.
b. Crystal Report
c. MS Excel
d. Data Report (part of VB)
e. Notepad - text info
f. Other

Have fun.

---- Andy

 

[johnwm]

Are you using the Printer object direct from VB? If so you get a new page with

Printer.Newpage

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[PeterWallace]

if useing the Datareport in vb ....
fill out Page Heading


Printer object

use a Linecounter when you print a line

If Linecounter => No Of Lines Per Page
Printer.newpage
call subroutine to print Standard Heading