Custom Printer Dialog Box?

Hi Folks,

I would like to create a new custom printer dialog box when users go to
print out reports in the front end of my databases. The current printer
dialog box in Access makes it way to easy to print out all of the records by
accident (has happened to a few users). I would prefer a dialog box that
defaults to “print current page� and also lets you input a print range. How
difficult would this be to do? I assume you would need to create a custom
function in VBA and then link the print command to this new function. Has
anyone already created something similar to this that I could model mine
from? Any help, suggestions or ideas would be greatly appreciated. Thanks in
advance.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

Roger, you can easily create a little unbound form in Access to use as a
print dialog.

Most users grow out of the idea of printing forms very quickly, and realise
they need to set up a report laid out as desired for print. Your command
button will therefore use the OpenReport method, and will use the
WhereCondition argument to limit the print out to just one record, or to a
range of records.

For an example of how to build the WhereCondition and print a single record,
see:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html

For an example of how to build the WhereCondition to print a range of
records, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Roger Tregelles" wrote in
message
...

I would like to create a new custom printer dialog box when users go to
print out reports in the front end of my databases. The current printer
dialog box in Access makes it way to easy to print out all of the records
by
accident (has happened to a few users). I would prefer a dialog box that
defaults to "print current page" and also lets you input a print range.
How
difficult would this be to do? I assume you would need to create a custom
function in VBA and then link the print command to this new function. Has
anyone already created something similar to this that I could model mine
from? Any help, suggestions or ideas would be greatly appreciated. Thanks
in
advance.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

Allen,

That works perfectly! I love it, great solution! Thank you so much for your
help and assistance with this problem.

Could you recommend any good Access books to help me develop my skills
further? Thanks again, I really do appreciate it.



Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

There's heaps of books on the market, and it kinda depends what you need.

One I'm using to teach Access is "Microsoft Access 2003 Inside Out" by John
Viescas (Microsoft Press, 2005). It's straight forward enough that you can
get into it with a basic knowledge of Access, and it takes you well along
the journey.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Roger Tregelles" wrote in message
...

That works perfectly! I love it, great solution! Thank you so much for
your
help and assistance with this problem.

Could you recommend any good Access books to help me develop my skills
further? Thanks again, I really do appreciate it.



Roger Tregelles
Quality Assurance Engineer
Respironics Inc.

Allen,

Thanks for the book recommendation. I actually have another book already by
John Viescas entitled "Building Access Applications" which comes with 4
complete databases he created and which he takes you through the process of
creation step by step. It's very well done. I'm going to look into getting
this other book too. Thanks again for your help, and your excellent Web
site. Keep up the great work, I really do appreciate it. Take care.

Roger Tregelles
Quality Assurance Engineer
Respironics Inc.