Ensuring uniform control width on forms and reports

[Tony Toews [MVP]]

This utility ensures you have uniform control width on forms and reports. This
example shows the Unit Number as found in many forms and reports through out the
Granite Fleet Manager. Other examples might be part numbers, serial numbers,
license plate numbers or other fields in which you must display all the data and yet
the field might be too short or you unexpectedly had to lengthen the field.

....

This code illustrates going through the collection of forms and reports then going
through the collection of controls on each form or report. If the control matches
certain criteria, being a text, combo or list box then various properties are read
from the control and placed in a table. If a combo box or list box the field name is
extracted from each column of the Row Source query.

http://msmvps.com/blogs/access/arch...iform-control-width-on-forms-and-reports.aspx

http://www.granite.ab.ca/access/ensuringuniformcontrolwidth.htm


--
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[KC-Mass]

Hi Tony,

I looked briefly at that but see no code. My interest is in a more mundane
use of code that peruses objects of the db. I am currently working on a db
that has had hundreds of hands on it and now has about 700 objects in it.
I would like to identify the dead ends/abandoned objects which I am pretty
sure
account for better than two thirds of the total.

Any assist would be appreciated.

Kevin

 

[Brendan Reynolds]

Hi Tony,

I looked briefly at that but see no code. My interest is in a more
mundane
use of code that peruses objects of the db. I am currently working on a
db
that has had hundreds of hands on it and now has about 700 objects in it.
I would like to identify the dead ends/abandoned objects which I am pretty
sure
account for better than two thirds of the total.

Any assist would be appreciated.

The Find and Replace utility from www.rickworld.com has a cross-reference
feature that I find useful for this kind of thing. It's disabled in the
shareware version but enabled when you register.

FMS (www.fmsinc.com) provides tools that cost more, but provide more
features.

There's also Speed Ferret (www.moshannon.com).

 

[Tony Toews [MVP]]

I looked briefly at that but see no code.

There should be a reasonable amount of code behind the form.

My interest is in a more mundane
use of code that peruses objects of the db. I am currently working on a db
that has had hundreds of hands on it and now has about 700 objects in it.
I would like to identify the dead ends/abandoned objects which I am pretty
sure account for better than two thirds of the total.

My utility wouldn't be at all useful as you'd need to thoroughly
analyze the macros, if any, and the VBA code.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Tony Toews [MVP]]

I looked briefly at that but see no code. My interest is in a more mundane
use of code that peruses objects of the db. I am currently working on a db
that has had hundreds of hands on it and now has about 700 objects in it.
I would like to identify the dead ends/abandoned objects which I am pretty
sure account for better than two thirds of the total.

FMS has a tool called Total Access Analyzer which should do a very
good job. http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[KC-Mass]

Thanks Tony

FMS has a tool called Total Access Analyzer which should do a very
good job. http://www.fmsinc.com/MicrosoftAccess/BestPractices.html

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/