1,000 records to search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to be able to type a company name and do a search from a form and
bring up all the companies information on the form..... I am a novice
 
Well, one way is simply to put your cursor in the company name field, and
hit ctrl-f.

You then can search for a company name.

A little more advanced is while in a form, go records->filter->filter by
form.

The above will "turn" your form into a instant search form. (give this a
try).

Another neat idea is to open up the form in design mode, and add a combo box
with the wizard. the wizard can build you a "drop down" combo that lets you
select a company, and then the form "jumps" to that record. So, try the
wizard. (and choose the option "find a record based on.....").

The above is a good starting point for you.

Note that 1000, or even 10,000 records is nothing for ms-access to search
for.

When you learn some additional ms-access skills, then here is my take on
building a search screen:

http://www.members.shaw.ca/AlbertKallal/Search/index.html
 
Albert D.Kallal said:
Well, one way is simply to put your cursor in the company name field, and
hit ctrl-f.

You then can search for a company name.

A little more advanced is while in a form, go records->filter->filter by
form.

The above will "turn" your form into a instant search form. (give this a
try).

Another neat idea is to open up the form in design mode, and add a combo box
with the wizard. the wizard can build you a "drop down" combo that lets you
select a company, and then the form "jumps" to that record. So, try the
wizard. (and choose the option "find a record based on.....").

The above is a good starting point for you.

Note that 1000, or even 10,000 records is nothing for ms-access to search
for.

When you learn some additional ms-access skills, then here is my take on
building a search screen:

http://www.members.shaw.ca/AlbertKallal/Search/index.html


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.members.shaw.ca/AlbertKallal

Thank you for the help Albert, I am actually looking more into the search screen. Do you use VBA code? If so I have a friend that can help me with that if someone could get us going in the right direction on how to start.
Click to expand...

Thank you,
Randy
(e-mail address removed)
 
I don't have a sample download (yet) for the search form.

However, I do use a bit of code. Assuming you have tryed the first 3
suggestions (none of which requite you to write code), then you can try my
last suggestion.

Build a unbound form. Place a text box near the top. Lets call the control
txtLastName. Turn just about everything off for this form (record selector,
navigation buttons etc). This form is NOT attached to a table, nor any data
(we call this a un-bound form).

In addition to the above, you an build nice continues form that displays the
columns of data in a nice list. you can then put this form as a sub-form
into the above form.

Then, in the txtLastName after update event you simply stuff the results
sql "search" into that sub-form.


dim strSql as string


strSql = "select * from tblCustomer where
LastName like '" & me.txtLastName & "*'"


me.MySubFormname.Form.RecordSource = strSql.


That is all there is to to the above...
 
Back
Top