VB and VBA Users Source Code: Re: Print the contents of an MS FlexGrid
[
Home
|
Contents
|
Search
|
Reply
|
Previous
|
Next
]
VB/VBA Source Code
Re: Print the contents of an MS FlexGrid
By:
T.Sirmen
Email (spam proof):
Email the originator of this post
Date:
Friday, January 16, 2004
Hits:
1009
Category:
Database/SQL/ADO
Article:
Encountered many people asking how to print full content of MS(H)FlexGrid all around, and I'm one of them. Tried the *great* code you provided, replacing all the MSFlexGrid links with MSHFlexGrid, and a MSHFlexGrid on the form of course. Hear are the results: It prints ok only if the first rec (ie. age 21 for your test code) is the top-most row on your screen. Otherwise: - it starts the first page of the printing with whatever the topmost row of the screen is. - goes to the end. but the rows before the topmost go lost. For example, if you start with the 3rd row (ie. age 23), from 3rd to the end are printed ok, but the first 2 rows never printed. - If you started at row 49 is the topmost of the screen, 1st printed page starts with row 49, 2nd continues and ends with 170, but 3rd page can never be send to printer succesfully. Some hang-up occures. - If you started at row 50 or beyond, first page(s) prints similarly (starting at the topmost row), but the remaining pages come only with the header row (row to repeat). Since nothing to print after the 170th row. But still extra pages (only with headers row) print. Yet, no hang-up. Moving the screen automatically to the first row before the printing process may be a walkaround. But this is not the good solution of course. There may be something missing with the code it self. Dont know whether you, or somebody else experienced this before me, and solved it out. If you know the reason and the solution please let me know. (t_sirmen@yahoo.com) If not solved yet, you may post my notes (this mail) to the public, to share the ideas. Take care
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
