Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Expert One-on-One Access Application Development
This is the forum to discuss the Wrox book Expert One-on-One Microsoft Access Application Development by Helen Feddema; ISBN: 9780764559044
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Expert One-on-One Access Application Development section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old June 2nd, 2004, 11:44 AM
Registered User
 
Join Date: Jun 2004
Location: Birmingham, Alabama, .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default missing .ocx file for DesignSchemes

  I am thrilled to have Ms. Feddama's text. It came yesterday and with that intelligence I polished and finalized my design, (which, I hope will allow my life as a general contractor become something more than the footnote it's been), however,
  The cool DesignSchemes add-in won't yet work because my set-up has no comdlg32.ocx file. I wonder if including some other lib file would work, or what? It looks like the .lbd file is a lock of some sort. Forgive my naivete, I have been away from coding since '94.
  Meantime, I'll skip to Ch.3 for expert attention for the subject's _NotInList event-so-crash feature.
  Glad to have this book,

Jim Shores
Homewood, Alabama
Reply With Quote
  #2 (permalink)  
Old June 2nd, 2004, 07:09 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is probably the result of your Office version. Older versions of Office (97 and 2000) had a set of ActiveX controls (including this one) in the Developer edition (only). For XP and 2003, the situation isn't as clear, but apparently it comes with the Professional version of Office XP, because I have this control on my Office XP boot partition.

It should be in the Windows\System32 folder, if you have it.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
Reply With Quote
  #3 (permalink)  
Old June 2nd, 2004, 08:54 PM
Registered User
 
Join Date: Jun 2004
Location: Birmingham, Alabama, .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

  Thanks for answering. I got a "Basic Office" edition with the PC and bought Access2003 outright, all ontop of XP Home, so I reckon I'll have to do with out that activeX control and just standardize my forms later on. Again, I am glad to have your elegant instructions.

Jim Shores
Homewood, Alabama
Reply With Quote
  #4 (permalink)  
Old June 5th, 2004, 12:14 PM
Authorized User
 
Join Date: May 2004
Location: , NH, USA.
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have that file, comdlg32.ocx,(5/7/99)in my C:\Windows\System\ folder on a WIN98SE that had Office97 Developers version installed at one time, and has Office 2000 Premium installed now.

Try using Find Files starting from the root of your hard drive and looking through sub folders. It may already be somewhere on your system even though you don't see it in your setup file listing. For example, that file is also distributed with Visio.

And here is a Microsoft article that advises using comdlg32.dll instead, which you may already have: http://support.microsoft.com/default...b;en-us;153929
I have not tried this, just providing it as a possible alternative for
you to consider.

And one more Microsoft article for when this file is actually there, but the system thinks that it is missing:
http://support.microsoft.com/default...b;en-us;257918
Reply With Quote
  #5 (permalink)  
Old June 11th, 2004, 10:27 PM
Registered User
 
Join Date: Jun 2004
Location: Birmingham, Alabama, .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well now, thanks Bob Hansen. I reckon I'd have to pick apart Ms. Feddama's add-in code to get the .dll (I have) to work.

Jim Shores
Homewood, Alabama
Reply With Quote
  #6 (permalink)  
Old July 3rd, 2004, 08:10 AM
Authorized User
 
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Don't feel too bad about not getting the DesignSchemes add-in to work. Have you read my post on the LNC Rename add-in? I don't think it works right either, but I haven't been able to get any response to my post.

On the surface this add-in looks like a very neat app, but based on my testing the add-in appears to change the name of the control on the form but does not change any references to the name of the control in the VBA code.

Terry Waltz
Reply With Quote
  #7 (permalink)  
Old July 8th, 2004, 06:50 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, Rename Current Control (and Rename All Controls for a form or report) just changes the control names on the form (or report). If you use the object renaming menu selection (Rename Database Objects), that does go through the VBA code and change all the references to the renamed objects. If you need to do the same for a renamed control, you can use FAR (Find and Replace, included in the zip file) directly for this purpose -- just run FAR, enter the original name and new name of the control, and search in any objects that might have a reference to it.

I didn't put this feature into my addin because it can be done fairly easily with FAR -- but actually, it might be a good idea for a future enhancement. Generally, I rename new controls ASAP, before any code references them, so this is likely to be a problem only when you are first applying a naming convention to a database that didn't have one.


Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding .ocx file created in VB 6.0 into Infopath g_b_mk VB.NET 2002/2003 Basics 1 December 5th, 2007 02:52 AM
need a specific .OCX file louki VB.NET 2002/2003 Basics 0 June 4th, 2006 05:36 AM
install ocx file ParadiseIsle Beginning VB 6 5 December 2nd, 2005 05:57 AM
Creating .ocx file in .net roy VS.NET 2002/2003 2 April 12th, 2005 07:58 AM
MSFLXGRD.OCX and MSDATGRD.OCX Clive Astley Access 1 July 25th, 2003 08:47 AM



All times are GMT -4. The time now is 09:08 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.