Build search function in to a form

Vincent Guerrero

unread,

May 10, 2013, 3:13:26 PM5/10/13

to

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

Gloops

unread,

May 10, 2013, 3:54:22 PM5/10/13

to

Vincent Guerrero wrote, on 10th May 2013 21:13 UTC + 2 :
> 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
>

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.

Douglas J Steele

unread,

May 10, 2013, 3:57:18 PM5/10/13

to

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

"Vincent Guerrero" wrote in message
news:939bf038-2d84-403f...@googlegroups.com...

Gloops

unread,

May 10, 2013, 4:05:25 PM5/10/13

to

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 :)

Phil A

unread,

May 10, 2013, 10:58:37 PM5/10/13

to

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

"Vincent Guerrero" <vsgue...@gmail.com> wrote in message
news:939bf038-2d84-403f...@googlegroups.com...

Access Developer

unread,

May 11, 2013, 5:02:55 PM5/11/13

to

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

"Vincent Guerrero" <vsgue...@gmail.com> wrote in message
news:939bf038-2d84-403f...@googlegroups.com...