Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Search Function

Discussion in 'Information Technology' started by Kieron White, Jul 28, 2006.

  1. Kieron White

    Kieron White
    Expand Collapse
    Guest

    I have created a database which will hold about 1000 or more records which
    will consist of 8 to 10 digits per record. I am having difficulty in creating
    a function within a form which will allow me to carry out a search on these
    records.

    What I had in mind was a function which will allow the user to carry out a
    seach on these records. However, the user might not know all of the digits.
    They might only know 2, 3 or perhaps 7 of these digits and once they have
    been entered I am looking for a list of possible results. Most probably by
    using a continous form.

    Firstly, is it possible to do something like this?

    Secondly, if this is possible, how does one go about designing and
    developing something hopefully as powerful as this.

    Thanks In Advance,
    Kieron White
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Indian American Couple Donates For Sikh, Punjabi Culture Research In US Breaking News Aug 19, 2016
    Soul Search By Swarn Singh Bains Book Reviews & Editorials May 25, 2016
    Harpal Singh Kumar Cancer Researcher Knighted By Queen Elizabeth II Sikh Personalities Jan 5, 2016
    Movies Ashdoc's Movie Review---dozakh In Search Of Heaven ( 2015 ) Theatre, Movies & Cinema Apr 6, 2015
    Research Shows NFL Quarterbacks Play Better With Beards Business, Lifestyle & Leisure Nov 23, 2014

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Create a textbox named search & enter the numbers + * or ? as wildcard(s)
    examples:
    123*78*
    1237?89*

    In the afterupdate_event of the field put:

    Private Sub Search_AfterUpdate()
    Me.Filter = "TheNumberfield Like '" & Me!Search & "'"
    Me.FilterOn = True
    End Sub

    HTH

    Pieter


    "Kieron White" <KieronWhite@discussions.microsoft.com> wrote in message
    news:12B39473-E8A4-400C-B572-4AFBE8B33B98@microsoft.com...
    >I have created a database which will hold about 1000 or more records which
    > will consist of 8 to 10 digits per record. I am having difficulty in
    > creating
    > a function within a form which will allow me to carry out a search on
    > these
    > records.
    >
    > What I had in mind was a function which will allow the user to carry out a
    > seach on these records. However, the user might not know all of the
    > digits.
    > They might only know 2, 3 or perhaps 7 of these digits and once they have
    > been entered I am looking for a list of possible results. Most probably by
    > using a continous form.
    >
    > Firstly, is it possible to do something like this?
    >
    > Secondly, if this is possible, how does one go about designing and
    > developing something hopefully as powerful as this.
    >
    > Thanks In Advance,
    > Kieron White
     
  4. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Kieron,

    I have a sample tutorial that I can send to you. If you are interested, send
    me a private e-mail message with a valid reply-to address. My e-mail address
    is available at the bottom of the contributor's page indicated below.

    Please do not post your e-mail address (or mine) to a newsgroup reply. Doing
    so will only attract the unwanted attention of spammers.


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Kieron White" wrote:

    > I have created a database which will hold about 1000 or more records which
    > will consist of 8 to 10 digits per record. I am having difficulty in creating
    > a function within a form which will allow me to carry out a search on these
    > records.
    >
    > What I had in mind was a function which will allow the user to carry out a
    > seach on these records. However, the user might not know all of the digits.
    > They might only know 2, 3 or perhaps 7 of these digits and once they have
    > been entered I am looking for a list of possible results. Most probably by
    > using a continous form.
    >
    > Firstly, is it possible to do something like this?
    >
    > Secondly, if this is possible, how does one go about designing and
    > developing something hopefully as powerful as this.
    >
    > Thanks In Advance,
    > Kieron White
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Create a textbox named search & enter the numbers + * or ? as wildcard(s)
    examples:
    123*78*
    1237?89*

    In the afterupdate_event of the field put:

    Private Sub Search_AfterUpdate()
    Me.Filter = "TheNumberfield Like '" & Me!Search & "'"
    Me.FilterOn = True
    End Sub

    HTH

    Pieter


    "Kieron White" <KieronWhite@discussions.microsoft.com> wrote in message
    news:12B39473-E8A4-400C-B572-4AFBE8B33B98@microsoft.com...
    >I have created a database which will hold about 1000 or more records which
    > will consist of 8 to 10 digits per record. I am having difficulty in
    > creating
    > a function within a form which will allow me to carry out a search on
    > these
    > records.
    >
    > What I had in mind was a function which will allow the user to carry out a
    > seach on these records. However, the user might not know all of the
    > digits.
    > They might only know 2, 3 or perhaps 7 of these digits and once they have
    > been entered I am looking for a list of possible results. Most probably by
    > using a continous form.
    >
    > Firstly, is it possible to do something like this?
    >
    > Secondly, if this is possible, how does one go about designing and
    > developing something hopefully as powerful as this.
    >
    > Thanks In Advance,
    > Kieron White




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4187 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page