Lebans Holdings 1999 Ltd.

 Home ] Up ] Feedback ] Contents ] Search ] What's New ] Files & Tips ] 

Image FAQ

RETIRED! September 2009

I have officially retired from all things Access. Please do not send Email requesting support as I will not respond.


Keep all of your questions to the Newsgroups where everyone will benefit!



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 file size.

A2K Version Here: A2KWindowToBitmap

A97 Verison Here:  A97WindowToBitmap



Version 1.2

For the A2K version ONLY, added support to allow the user to save the Query Design View window to disk.

Version 1.1

Added support for File Dialog window

Sets Relationship window background to WHITE prior to saving 

Cleaned code a bit



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>

Good luck.

Stephen Lebans
Access Code, Tips and Tricks


May 23, 2004 Product Update
Rich Text ActiveX control. Version 1.8

Click Here!


Mar 15, 2005 Product Update
MouseHook  Replaces the MouseWheel DLL subclassing solution. Turns On/Off the MouseWheel with one line of code. No DLL registration required. Now supports Logitech mice!

Click Here! 



Back ] Home ] Up ] Next ] 
Stephen Lebans Copyright 2009

Last Modified : 09/11/09 12:03 AM