Re: Search for Names in DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I think it would be easier to create a form with tabs on it. Basic
information could be on the first tab or on the form without a tab control.
You can filter by form or using the find command and then filtered. You will
only see the David's and can flip through the different ones to find the
correct person.

"Steve" wrote:

Create an unbound combobox based on a query. The query needs to have an ID
field first then all the fields you might search on. In your example you
need a first name field. The criteria of the search field needs to be set
by an unbound textbox. You enter the criteria in the textbox then open the
combobox and you will then see all Davids. You click on the one you want and
code in the AfterUpdate event (which you wrote) will take you to the record
of the David you selected.

Steve
santus@xxxxxxxx

"RyGuy" <RyGuy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9F39D029-78B8-4EA9-B9FA-0C71E49AC32C@xxxxxxxxxxxxxxxx
I hope this is the correct category for this question. I have a generic
Access DB which allows a user to input a unique number into a TextBox and
then search for this number in a Table. The code works great, I'm just
thinking of ways that I may change it to help a friend with a project.
Basically, my friend works at a hospital and he wants to start using
Access
to warehouse information for patients. IDs will probably be used for
patient
record keeping. However, I am thinking of adding a feature to look up a
patient based on name (which will be easier to remember than an ID).
Anyway,
my questions is this: is there a good sample DB out there somewhere, with
VBA
code, etc, that demos how to search for a name, such as David, and then
return all matches so the user can identify the appropriate individual?
Then, when the user selects the appropriate individual he/she see all
related
information for this specific person. I have a DB that allows a user to
search for a unique ID, and then all records are returned when the VBA
fires.
If I change the code a bit, and search by name, I can find David, and I
get
the first match, but I can't see any other person named David in my DB.

Thanks,
Ryan--



.

Relevant Pages

  • Re: Tab functionality for VBA form in Excel 2004 for mac / macinto
    ... I do have the Mac set to tab from textbox to textbox and ... computer with Excel 2008. ... One of the problems I can't fix, however, is the tab functionality of the ... I must click in each box to move the control. ...
    (microsoft.public.mac.office.excel)
  • Re: Purging window messages under a given condition!
    ... of the tab control. ... matter what control on the page I'm trying to activate. ... Did you look at the Validating event on the TextBox? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: control source to update text box
    ... procedure is still in the events tab. ... of the reference # text box. ... Also check that the control source for the textbox that receives ...
    (microsoft.public.access.formscoding)
  • TAB Index and TabStop; sequences
    ... --The last textbox unhides a command button ... After data is entered into that last textbox, pressing tab makes the cursor ... At any rate, I don't -think- the label TabIndexes are a problem, but ... ...
    (microsoft.public.vb.general.discussion)
  • Re: Master Pages and Cross-Page Form Information
    ... > David R. Longnecker ... > Management Information Services ... >> | since we're using Master page, the textboxes are cotained in the ... >> | in that textbox. ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)