Search and see One Record

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

Guest

I managed to import a large excel spreadsheet for my database successfully.
How do I create a report/query that gives me a screen shot status of any
particular record. Ideally, I'd like a form where you type in the name, hit
okay, and a single record appears on screen in a nice format for veiwing. Is
this a query or report???
 
Sophia,
Two parts to this question ...
1. Easily find a particular record.
On my website (below) I have an A97 or A2003 sample file called Quick Find Combo.
It shows how to use an unbound combo on a form to quickly find a particular record in the
recordset.
2. Record found... now print report for that record.
In the query behind your report, use a key value from the OPEN form to filter the
report. Say that each form record has a unique key value like CustID. In the query
behind the report, use this criteria against the CustID field...
= Forms!frmYourFormName!CustID
Now the report will only deliver the data associated with the particular record.
 
In Database|Tables select the new table. Click the Autoform Wizard
Icon (lightning stroke) on the toolbar above the window. The wizard
will walk you through several choices, pick the one closest to what
you want. You can keep discarding the unsatisfactory tries until
you're as close as you think you're going to get with the wizard.
Open the form in design view. Before re-arranging all of the
controls, go for the feature you're interested in having. Make sure
that wizards are enabled, the button on the Toolbox showing a baton
with stars is highlighted. On the Menu bar click View and enable Form
Header & Footer. Open the header to about one inch tall. On the
toolbox click the combobox icon. Starting just under halfway across
the form, draw a rectangle 2 inches wide or more. The combobox wizard
will pop up and start asking questions. Choose the " want to go to a
particular record ..." and finish stepping through the wizard. I'd
give the combobox a name something like
cboFindWhateverItIsInYourTable.

That's it. Now you can tweak things for appearance.

HTH
 
This suggestion works great!
--
sssadie :)


Larry Daugherty said:
In Database|Tables select the new table. Click the Autoform Wizard
Icon (lightning stroke) on the toolbar above the window. The wizard
will walk you through several choices, pick the one closest to what
you want. You can keep discarding the unsatisfactory tries until
you're as close as you think you're going to get with the wizard.
Open the form in design view. Before re-arranging all of the
controls, go for the feature you're interested in having. Make sure
that wizards are enabled, the button on the Toolbox showing a baton
with stars is highlighted. On the Menu bar click View and enable Form
Header & Footer. Open the header to about one inch tall. On the
toolbox click the combobox icon. Starting just under halfway across
the form, draw a rectangle 2 inches wide or more. The combobox wizard
will pop up and start asking questions. Choose the " want to go to a
particular record ..." and finish stepping through the wizard. I'd
give the combobox a name something like
cboFindWhateverItIsInYourTable.

That's it. Now you can tweak things for appearance.

HTH
Click to expand...
 
Back
Top