Build search function in to a form

Discussion in 'Access General' started by Vincent Guerrero, May 10, 2013.

  1. Hi all,

    I'm building a contracts database. I want to build a search function in toa form that would essentially pull up the "input" screen of the contract when you searched by vendor.

    To clarify...

    I have a main switchboard. On that switchboard there is an "input contract" button which brings up a form with all the fields of a contract. Vendor....address..phone..fax...contract #...etc. It opens blank, but since it feeds the table with all the contracts, you can click through the records and view all the contracts in the database. I would like to put a search function at the top of the form so you could type in a specific vendor and browse those contracts.

    What would be the best way to do this?

    I have a giant access book but i've looked at the "search" topics and they were not what I needed.


    Thanks in advance,

    Vince
     
    Vincent Guerrero, May 10, 2013
    #1
    1. Advertisements

  2. Vincent Guerrero

    Gloops Guest

    Vincent Guerrero wrote, on 10th May 2013 21:13 UTC + 2 :
    Hello,

    So, you want a form to prepare an SQL search ?
    And then of course a form to show the results.

    About two weeks ago, somebody in the French newsgroup asked that, and
    then appeared unable to create a button on a form to launch an action,
    and he told he would not have an occasion to write any other application
    in Access. So after spending several days to give all details for the
    development, I eventually told him to search something already existing,
    or to find a temporary programmer.

    So, do you have any fluency with Ms-Access programming in general, or at
    least any motivation to learn so ?
    Your presentation as writing a database invites to incline in that
    direction, but ... I presume you understand my carefulness.
     
    Gloops, May 10, 2013
    #2
    1. Advertisements

  3. Might something like Allen Brown's Search Criteria
    (http://www.allenbrowne.com/ser-62.html) be what you want?

    "Vincent Guerrero" wrote in message

    Hi all,

    I'm building a contracts database. I want to build a search function in to
    a form that would essentially pull up the "input" screen of the contract
    when you searched by vendor.

    To clarify...

    I have a main switchboard. On that switchboard there is an "input contract"
    button which brings up a form with all the fields of a contract.
    Vendor...address..phone..fax...contract #...etc. It opens blank, but since
    it feeds the table with all the contracts, you can click through the records
    and view all the contracts in the database. I would like to put a search
    function at the top of the form so you could type in a specific vendor and
    browse those contracts.

    What would be the best way to do this?

    I have a giant access book but i've looked at the "search" topics and they
    were not what I needed.


    Thanks in advance,

    Vince
     
    Douglas J Steele, May 10, 2013
    #3
  4. Vincent Guerrero

    Gloops Guest

    Hum, after a very quick glance, it seems it would have been a good thing
    I saw that before the question was asked in French :)

    Douglas J Steele wrote, on 10th May 2013 21:57 UTC + 2 :
     
    Gloops, May 10, 2013
    #4
  5. Vincent Guerrero

    Phil A Guest

    The best way is to use the built-in function from the Access menu.


    Hi all,

    I'm building a contracts database. I want to build a search function in to
    a form that would essentially pull up the "input" screen of the contract
    when you searched by vendor.

    To clarify...

    I have a main switchboard. On that switchboard there is an "input contract"
    button which brings up a form with all the fields of a contract.
    Vendor...address..phone..fax...contract #...etc. It opens blank, but since
    it feeds the table with all the contracts, you can click through the records
    and view all the contracts in the database. I would like to put a search
    function at the top of the form so you could type in a specific vendor and
    browse those contracts.

    What would be the best way to do this?

    I have a giant access book but i've looked at the "search" topics and they
    were not what I needed.


    Thanks in advance,

    Vince
     
    Phil A, May 11, 2013
    #5
  6. The ComboBox wizard will allow you to use a ComboBox to select a value and
    to display the record in which it is found (if it is found)... sounds like
    just what you are looking for.

    --
    Larry Linson
    Microsoft Office Access MVP
    Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

    Hi all,

    I'm building a contracts database. I want to build a search function in to
    a form that would essentially pull up the "input" screen of the contract
    when you searched by vendor.

    To clarify...

    I have a main switchboard. On that switchboard there is an "input contract"
    button which brings up a form with all the fields of a contract.
    Vendor...address..phone..fax...contract #...etc. It opens blank, but since
    it feeds the table with all the contracts, you can click through the records
    and view all the contracts in the database. I would like to put a search
    function at the top of the form so you could type in a specific vendor and
    browse those contracts.

    What would be the best way to do this?

    I have a giant access book but i've looked at the "search" topics and they
    were not what I needed.


    Thanks in advance,

    Vince
     
    Access Developer, May 11, 2013
    #6
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.