Build search function in to a form

[Vincent Guerrero]

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

 

[Gloops]

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]

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

 

[Gloops]

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 :

 

[Phil A]

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

 

[Access Developer]

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