How to look for a specific data in a table???

[Guest]

Hi,

I have a data list in 1 of my tables and I would like to look for a specific
record in that list for example, by entering an unique field (Employee ID) in
the table; instead of using the navigation buttons in the form or select the
data using combo box.

Actually, what I want is I will have a form, for example Employee Biodata
Form where I just need to enter any of the Employee ID; then the form will
return me the correspondence employee's biodata. I have tried out with combo
box but thing will still be tidous once the list getting longer and longer
cause searching through the combo box's drop-out list for the ID is needed.

Help is needed over here; therefore, anyone out there could help???
Thanking in advanced.

 

[Carl Rapson]

Hi,

I have a data list in 1 of my tables and I would like to look for a
specific
record in that list for example, by entering an unique field (Employee ID)
in
the table; instead of using the navigation buttons in the form or select
the
data using combo box.

Actually, what I want is I will have a form, for example Employee Biodata
Form where I just need to enter any of the Employee ID; then the form
will
return me the correspondence employee's biodata. I have tried out with
combo
box but thing will still be tidous once the list getting longer and longer
cause searching through the combo box's drop-out list for the ID is
needed.

Help is needed over here; therefore, anyone out there could help???
Thanking in advanced.

Have you tried using the Filter By Form button in the menu bar? When you
click that, you can enter a value into any field on the form, then click
Apply Filter to apply the filter. Your form should then display only those
records that match what you entered. A bonus to this method is that it
requires no additional coding or controls to use; the functionality is built
in. Look in Access help for more information about Filter By Form.

Carl Rapson

 

[Smartin]

Hi,

I have a data list in 1 of my tables and I would like to look for a specific
record in that list for example, by entering an unique field (Employee ID) in
the table; instead of using the navigation buttons in the form or select the
data using combo box.

Actually, what I want is I will have a form, for example Employee Biodata
Form where I just need to enter any of the Employee ID; then the form will
return me the correspondence employee's biodata. I have tried out with combo
box but thing will still be tidous once the list getting longer and longer
cause searching through the combo box's drop-out list for the ID is needed.

Help is needed over here; therefore, anyone out there could help???
Thanking in advanced.

I've seen this done like so:

Create a query based on the employee table. Drag the Emp ID field into
the query and set the criteria as "[What employee number please? ]"
(without quotes but with [square brackets]). Save the query as qFindEmpID.

Now create a macro with Action ApplyFilter. In the Filter Name parameter
type the name of the query you just saved (qFindEmpID). Save the macro
as mFindEmpID.

Lastly drop a button on the form. Use the wizard to do Action "Run
Macro" (Miscellaneous category). Choose mFindEmpID as the macro.

Save, run, and click your new button. This sets a filter on the record
source. To get out of it click the depressed filter widget on the toolbar.

There are variations on this theme, and probably better ways.

 

[Guest]

thanks for your solution & will try it out...
: )

 

[Guest]

thanks for your solution & will try it out later....
: )

Hi,

I have a data list in 1 of my tables and I would like to look for a specific
record in that list for example, by entering an unique field (Employee ID) in
the table; instead of using the navigation buttons in the form or select the
data using combo box.

Actually, what I want is I will have a form, for example Employee Biodata
Form where I just need to enter any of the Employee ID; then the form will
return me the correspondence employee's biodata. I have tried out with combo
box but thing will still be tidous once the list getting longer and longer
cause searching through the combo box's drop-out list for the ID is needed.

Help is needed over here; therefore, anyone out there could help???
Thanking in advanced.

I've seen this done like so:

Create a query based on the employee table. Drag the Emp ID field into
the query and set the criteria as "[What employee number please? ]"
(without quotes but with [square brackets]). Save the query as qFindEmpID.

Now create a macro with Action ApplyFilter. In the Filter Name parameter
type the name of the query you just saved (qFindEmpID). Save the macro
as mFindEmpID.

Lastly drop a button on the form. Use the wizard to do Action "Run
Macro" (Miscellaneous category). Choose mFindEmpID as the macro.

Save, run, and click your new button. This sets a filter on the record
source. To get out of it click the depressed filter widget on the toolbar.

There are variations on this theme, and probably better ways.