Making all fileds in a form Read only without changing the Form

[Shimon]

Hi All,
just got to know Allen Browne's website and it is just fantastic. It is
almost as great as this forum and its experts.
I was wondering if there is anyone that has experience with tweaking his
utilties.
Is there a Forum of his?

Using these search boxes, you cannot have the whole form read-only.
I read somewhere (but cannot find it now) a small function that runs through
the form and makes every control that is not a text box or combo-box read
only.
Does anybody have this or remember where it is? I think that it was on Allen
Browne's site.

I would also like to tweak the search utility, so that I don't have to
choose a field that I want to search, but instead I would like to have five
text boxes at the bottom of the form, for the five fields that i would like
to search.
Here is the link to his page http://www.allenbrowne.com/AppFindAsUType.html

Each entry to one of these text boxes should empty all other text boxes and
create a filter based on the text that I type.
I looked through his code and it is a little advanced for me to play with.
Thanks for any help.
Shimon

 

[Allen Browne]

Thanks for your comments. I don't think Allen has a forum of his own.

Not sure if this meets your first need:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html
All the bound controls on your form start out locked, until you click a
button to unlock them.

For an example of how to build a search utility with multiple options, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
The example shows how to build the filter string from just the boxes where
the user entered something. It's not too difficult to build your own filter
from that example.

The FindAsUType example is not simple to modify. Most of the complexity
comes from figuring out what fields are in the form, which ones we can
filter on (varies in different versions of Access), and what name the user
knows those fields by. The purpose of all that code is that you can just
plug it into any form without modification, so it's not really designed to
be modified.

 

[Shimon]

Thanks allot Allen,
The beauty and simplicity of the SearchAsUType is really amazing. You saved
me loads of work.
I'll try the links you sent me.
All the best and blessings from the holy land,
Shimon