find all

[Milica]

Hi,

Reading through many threads I haven't been able to find the answer which
troubles me for a while, so here goes: I have a simple database with 1 main
table and 2 tables linked to it. At start up there is a switchboard. Is there
a way that I can have a text box (or anything else that would serve the
purpose) on the switchboard where I could type a word to search, which would
search through all records/fields in the main table.
Alternatively, is there a way to customize 'find record' so it always has
the same criteria for searching (Look in: Form; Match: Any Part of Field;
Search: All).

Any ideas would be much appreciated...

 

[Ted]

that sounds a bit like what i'm looking for. have you discovered if you can
put a text or some other control (cmbobox?) on the main switchboard and use
it in this way.

 

[John Vinson]

that sounds a bit like what i'm looking for. have you discovered if you can
put a text or some other control (cmbobox?) on the main switchboard and use
it in this way.

Yes. You can use a criterion of

=Forms![Switchboard]![comboboxname]

or

LIKE "*" & Forms![Switchboard]![comboboxname] & "*"

to find the value anywhere within the field.

John W. Vinson[MVP]

 

[Ted]

hi john,

this is really very encouraging news, but i cannot understand why, when i
place a cmbobox on the switchboard (which, if it makes any difference was
generated using the 'switchboard wizard' of a2k's) i don't see it when i exit
from design and return to form view??!

-ted

that sounds a bit like what i'm looking for. have you discovered if you can
put a text or some other control (cmbobox?) on the main switchboard and use
it in this way.

Yes. You can use a criterion of

=Forms![Switchboard]![comboboxname]

or

LIKE "*" & Forms![Switchboard]![comboboxname] & "*"

to find the value anywhere within the field.

John W. Vinson[MVP]

 

[Ted]

hi john,

while i managed to somehow torture the switchboard into letting me make the
unbound combobox visible to the naked eye, that and use the following
Table/Query as the Rowsource, i.e.

SELECT [Registration].[Patient Number] FROM Registration;

which produces a scrollable l/u table of values, it (whatever it is) won't
let me select from the list??!!!

bugger!


-ted

that sounds a bit like what i'm looking for. have you discovered if you can
put a text or some other control (cmbobox?) on the main switchboard and use
it in this way.

Yes. You can use a criterion of

=Forms![Switchboard]![comboboxname]

or

LIKE "*" & Forms![Switchboard]![comboboxname] & "*"

to find the value anywhere within the field.

John W. Vinson[MVP]

 

[John Vinson]

hi john,

while i managed to somehow torture the switchboard into letting me make the
unbound combobox visible to the naked eye, that and use the following
Table/Query as the Rowsource, i.e.

SELECT [Registration].[Patient Number] FROM Registration;

which produces a scrollable l/u table of values, it (whatever it is) won't
let me select from the list??!!!

The Switchboard is probably not an editable form - so you can't "edit"
(select) any controls on it. I don't use the Microsoft switchboard
wizard, for several reasons, this among them; I roll my own
switchboards using a Listbox of the various options.


John W. Vinson[MVP]