WindowToBitmap is a
database containing a class to allow you to capture and save the entire contents
of the Relationship window to a disk based Bitmap file. This is roughly a 4800
x 4800 pixel window. The Bitmap is saved as a 16 color BMP in order to reduce
A2K Version Here:
A97 Verison Here: A97WindowToBitmap
A2K version ONLY, added support to allow the user to save the Query
Design View window to disk.
Added support for File Dialog window
Sets Relationship window background to WHITE prior to saving
Cleaned code a bit
WARNING -> BETA .08
This current version leaves a 11 MB Bitmap file in your system Temp folder
every time you run the function. The filename is SLCxxx.bmp
Here is an
explanation of how to Print the resulting Bitmap from MS Paint to the exact
output size you desire.
Before you print the bitmap from Paint, I would suggest you go to
the Image->Attributes menu. Change the Width and Height of the bitmap in
inches to match the amount of output pages you want to fill. For this
example, to make it simple, we will set the Page Setup to 1 one inch
margin all around on a standard 8.5 x 11 inch page. This leaves us
effectively with 6.5" on the X axis and 9" on the Y axis.
On my system, with a display resolution of 120DPI the Relationship
window comes in at 4800 * 4800 Pixels. When loaded into MS Paint, the
Image Attributes in inches will show this as 40 inches by 40 inches. If
you have your system set to Large Fonts you will be at 96DPI and the
numbers will reflect this.
X = 4800pixels / 120pixels per inch = 40 inches
Y = 4800pixels / 120pixels per inch = 40 inches
X = 40 inches / 6.5 inches per page wide = 6.15 pages
Y = 40 inches / 9 inches per page wide = 4.44 pages
6.15 pages * 4.44 pages = ROUNDED UP TO FULL PAGE
7 * 5 = 35 Full Pages.
If you do a Print Preview in Paint you will see that yes, there are 35
pages to the full ouput.
Obviously you do not want to print out at 120DPI. Select a multiple of
the paper size you are going to be outputting at or print it all on one
page of the largest size your printer supports. Just plug the number in
the formula/logic above to calc the total output pages that will be
required. You are effectively employing a Print To Fit logic for your
finished output. I would say anything below 300 DPI is a waste of paper.
Depends how good your eye sight is!<grin>
Access Code, Tips and Tricks
May 23, 2004
Rich Text ActiveX control.
Mar 15, 2005 Product Update
the MouseWheel DLL subclassing solution. Turns On/Off the MouseWheel with
one line of code. No DLL registration required. Now supports Logitech mice!