Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #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
  #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/
  #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
  #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
  #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
  #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
  #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/


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





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