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 23rd, 2004, 07:03 AM
Authorized User
 
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default LNC Rename Controls

When I run the LNC Rename Current Control add-in in an existing database on a control that has VBA code behind it, the add-in changes the name of the control but does not change any of the references to the control in the VBA code.

For example,
If I had a command button named CloseForm which I created using the Control Wizard, VBA code would be automatically generated for the Click event of the command button called CloseForm_Click. If I run the LNC Rename Current Control add-in, the add-in will change the name of the control from CloseForm to cmdCloseForm, but the references to that control in the VBA code have not been changed. In particular, the CloseForm_Click is still named CloseForm_Click instead of renaming the procedure to cmdCloseForm_Click. As a result the command button click event will not work.

Is it possible that the LNC Rename Current Control add-in changes the name of the control but does not change the references in the VBA code? This just doen't seem right to me. If you change the name of the control, you should change the name every place that that control is referenced in the VBA code, especially in their event procedures.

Can anyone shed any light on what I am doing wrong? Do the changes in the VBA code have to be done separately using Find and Replace?

Thanks,
Terry Waltz

Terry Waltz
__________________
Terry Waltz
  #2 (permalink)  
Old July 8th, 2004, 07:20 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Your last sentence is correct. LNC rename does correct references to renamed database objects (tables, forms, etc.) but not to renamed controls. This can be done directly with FAR. However, I will consider this as a possible future enhancement to the add-in.

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 July 27th, 2004, 10:29 AM
Authorized User
 
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your confirmation.

Should I post this as an Errata? (I haven't had any confidence in the Errata procedure since I get no feedback and no Errata have been posted on the website) Or will you take it from here?

Terry Waltz
  #4 (permalink)  
Old July 29th, 2004, 05:18 PM
Authorized User
 
Join Date: May 2004
Location: Kerhonkson, NY, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

This is more of an enhancement request than errata. I might upgrade the add-in to include this feature, unless it looks like Access 2006 will (at long last!) include automatic application of a naming convention.

Helen Feddema
Kerhonkson, NY
hfeddema@hvc.rr.com
http://www.helenfeddema.com
Read Woody's Access Watch
http://www.woodyswatch.com/waw/
  #5 (permalink)  
Old July 30th, 2004, 08:23 AM
Authorized User
 
Join Date: Jun 2004
Location: Cumberland, MD, USA.
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I appreciate your response. Currently this is an errata issue ...

On p.295 you state "To make this task less burdensome, I created the LNC Rename add-in, an Access add-in that automates the process of renaming ... form and report controls, and also corrects references to them in code."

This statement in the book (and perhaps there are others that reference this same capability of the LNC Rename add-in) is not correct and should be posted as an errata.

I have found/reported (thru the Wrox errata form on the Wrox website) several errors in this book and in "Access 2003 VBA Programmer's Reference", but I never get any feedback from my errata submittal and nothing ever gets posted as an errata.

For many readers, like myself, reading these books are how we learn. We rely on books (and errata).


Terry Waltz


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile Error when running LNC Rename Add-in Dhanick Access 1 December 1st, 2008 08:55 AM
LNC Rename control Add-in error jbage BOOK: Expert One-on-One Access Application Development 7 March 22nd, 2007 08:41 AM
Where is the LNC Rename Add in? billblackett BOOK: Expert One-on-One Access Application Development 2 February 14th, 2007 02:10 PM
LNC Rename dmoffice Access VBA 6 November 16th, 2006 09:42 PM
LNC Loralee BOOK: Expert One-on-One Access Application Development 0 December 10th, 2004 12:48 AM





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