Rename Controls Faster and Easier

Use this Advanced Development Tool to Standardize Your Microsoft Access Database

Have you inherited an MS Access database that has no naming convention? You want to name the controls on the forms and reports in a consistent manner, and now you're faced with a daunting time-consuming task. But now you can save hours and hours of time, and have more fun doing it too.

The Change Control Names wizard features:

  • Change one control name or several at once.
  • Automatically change control prefixes, using any prefix you choose.
  • Change captions.
  • Change control sources.
  • Automatically change references in queries to the control name.
  • Automatically change the corresponding VB code in the class module that refers to the control name.
  • View the corresponding VB code to help you choose an appropriate control name.
  • Save the form or report at any time, after each change, or after several changes.
  • Easily back out the changes by closing the form or report without saving it.

The screen above highlights a combobox control that has VBA code associated with it. The screen below highlights a label control, and it shows the results of a recent change to the label caption.

This development tool provides fine granular control over your changes. Not only do you choose the forms and reports to change, but you also choose which controls to change and how to change them.

For example, suppose you want to change the control prefix for text boxes to "txt" but you want to leave the prefixes for command buttons alone. The wizard has the flexibility to change the prefix for one control or for all textboxes on the object. On the other hand, if you want to change the prefix for textboxes and command buttons, and leave the other types of controls alone, then you can put a checkmark by textboxes and command buttons while unchecking labels, comboboxes, listboxes, and the rest, and then instantly change the prefixes for the selected control types with the blink of an eye. In other words, you can change the prefixes for as few or as many controls as you wish.

Download Yours Right Now

This utility comes complete with VB code, and if you can program in Access, then you have full power to change any functionality. Download your Change Control Name wizard now. It's only $19 with a satisfaction money-back guarantee.

(Comes in an Access 2000 database which you can convert to any more recent version.)

Cool Tools for Access

Effortless results in record time! Automate tedious programming tasks (forms, queries, reports). View screen prints.

Calendar Schedule Template

Get an eagle eye view of the key dates in your database. Get the big picture in order to make better evaluations and better decisions. The calendar tool gives you a handle on your dates, because you can view at a glance all your key dates in calendar format. View or print a report by month, by week, or by day. It's a most flexible fluid way of calendaring. View screen prints.

Manage Remote Database

This wizard makes it easy to modify tables, fields, and indexes on your remote backend database, without even opening the database. View screen prints.

Image File Utility

Browse image files using MS Access image control, search by title or by description, copy to other folders. View screen prints.

Alternative Security Tool

Intuitive security wizard makes it easier to move users to and from groups. View screen prints.

About the Author
Allen Beechick is a Microsoft Access consultant. Do you need a productive consultant for your project? Send your specs and receive a free bid.

A Faster Sorting Algorithm - twice as fast as Quicksort, guaranteed

Frugal shoppers rave about the aisle-by-aisle grocery list software that simplifies day-to-day shopping chores.

Cool Tools for Access
Achieve dazzling results in record time. Automate tedious programming tasks (forms, queries, reports) with ingenious guru tools.