find all

[Guest]

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...

 

[Guest]

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]

 

[Guest]

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]

 

[Guest]

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]

 

[Guest]

assuming you're probably correct, could i point a command button on the ezpz
switchboard to a form which opens with the combo box i'm descring on it. once
the choice of Patient Number's made, could the user then close the said form
and have subsequent fomr that the user's interested in editing filter on the
value in the table bound to the form the user uses to choose his Patient to
be worked?

-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??!!!

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]