To be honest, the code on that page is a bit intimidating. I'm not sure how
to adapt it to just bring up the print dialog box, which is all I need (user
needs to select the printer to use). Do I need it all, or just a portion of
it? Sorry to be of so many questions!
MAB
> My advise is not to use the control at all: it's far too prone to versioning
> problems.
[quoted text clipped - 17 lines]
> > Thanks!
> > MAB
Douglas J. Steele - 02 Oct 2003 23:30 GMT
Ah, the Printer dialog is a different beast. (Sorry, but the vast majority
of people using the Common Dialog control want the File Open/File Save
dialog, and I didn't think to ask)
There are a couple of suggestions at
http://www.mvps.org/access/reports/rpt0009.htm and yes, code like this can
be a tad daunting, or Tony Toews has a download (Printer switch code) at
http://www.granite.ab.ca/accsmstr.htm
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
> To be honest, the code on that page is a bit intimidating. I'm not sure how
> to adapt it to just bring up the print dialog box, which is all I need (user
[quoted text clipped - 27 lines]
> > > Thanks!
> > > MAB
Larry Daugherty - 03 Oct 2003 01:24 GMT
Mike,
It's been a while since I touched that code but as best I recall you
simply import the module into your own database. There is a routine named,
I believe, TestIt or something like that. In the VBE, place your cursor in
TestIt and press F5. That should cause it to run to the point of opening
the Dialog for you to navigate to a target directory. It will resume
execution once you've made your selection. Once you've gone through it like
that, go back and start over but this time press F8. That will step you
through every line of code. Once you've done that you can then copy and
paste the innards of the TestIt routine into the code where you're trying to
get the Common Dialogue. Modify the TestIt code to work with your existing
code. No further changes should be required.
hth

Signature
-Larry-
--
> To be honest, the code on that page is a bit intimidating. I'm not sure how
> to adapt it to just bring up the print dialog box, which is all I need (user
[quoted text clipped - 27 lines]
> > > Thanks!
> > > MAB