Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / ActiveX Controls / October 2003

Tip: Looking for answers? Try searching our database.

Common Dialog

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Baker - 01 Oct 2003 17:06 GMT
When attempting to add the Common Dialog Control to a form in Access2K, I
get an error message stating that the control is not regietered. It gives no
further data. How do I register it? I have found a file in
C:\WIndows\System32 called Comdlg32.ocx (or something like that). But it
doesn't seem to help to select it when I try to register. What do I need to
do to be able to use this control?

Thanks!
MAB
Tony Toews - 01 Oct 2003 22:31 GMT
>When attempting to add the Common Dialog Control to a form in Access2K, I
>get an error message stating that the control is not regietered. It gives no
>further data. How do I register it? I have found a file in
>C:\WIndows\System32 called Comdlg32.ocx (or something like that). But it
>doesn't seem to help to select it when I try to register. What do I need to
>do to be able to use this control?

Use the API call instead.  See the API section at the Access Web at
www.mvps.org/access.

Tony
--
Tony Toews, Microsoft Access MVP
  Please respond only in the newsgroups so that others can
read the entire thread of messages.
  Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Douglas J. Steele - 01 Oct 2003 22:33 GMT
My advise is not to use the control at all: it's far too prone to versioning
problems.

Instead, call the APIs directly. See
http://www.mvps.org/access/api/api0001.htm for sample code.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele

> When attempting to add the Common Dialog Control to a form in Access2K, I
> get an error message stating that the control is not regietered. It gives no
[quoted text clipped - 5 lines]
> Thanks!
> MAB
Mike Baker - 02 Oct 2003 16:23 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.