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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Jac said:
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.
Click to expand...

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
 
Jac said:
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.
Click to expand...

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.
 
thanks for your solution & will try it out later....
: )

Smartin said:
Jac said:
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.
Click to expand...

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.
Click to expand...
 
Back
Top