Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / October 2007

Tip: Looking for answers? Try searching our database.

I want to create a search box in access

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dethra - 31 Oct 2007 12:12 GMT
I have a database that I can create a query on, to bring up certain details
that I need to look at, without all the fluff.
When i run the query, I need to create either a macro, or a query, that will
show me a search box, so that I can search forspecific postcodes in my query.
is this possible with Access 2007? Is anything similar to this possible,
that will save me having to go to the filter everytime i want to search for a
new postcode?
I've spoke to MS and trawled the internet, and no one seems to be able to
help me.

Anything would be appreciated.
Allen Browne - 31 Oct 2007 12:25 GMT
You must use a form to do this. It can be in Continuous View if you want it
to show multiple rows.

It is very easy to create an unbound text box (or combo) in the Form Header,
and use its After Update event procedure to filter the form.

There's some simple code here:
   Using a Combo Box to Find Records
at:
   http://allenbrowne.com/ser-03.html

This one allows you to specify which field to search (choose from a combo),
and what value to search for (type in a text box), and applies the filter
with each character you type:
   Find as you type - Filter forms with each keystroke
at:
   http://allenbrowne.com/AppFindAsUType.html
It's very easy to use: copy, paste, and set one property.

This one is a more comprehensive example, showing you how to offer a filter
on several fields in combination:
   Search form - Handle many optional criteria
at:
   http://allenbrowne.com/ser-62.html
It involves writing more code (specific to the fields you want to offer.)
The screenshot illustrates how a continuous form can be set up to show
multiple rows.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a database that I can create a query on, to bring up certain details
> that I need to look at, without all the fluff.
[quoted text clipped - 10 lines]
>
> Anything would be appreciated.
Dethra - 31 Oct 2007 13:01 GMT
Thanks for that Allen, but I can't use this in Access 2007.
I'm new to this, so all the coding goes over my head. I'm trying to make
heads over tails here, but the information which you provided, whilst very
good, is unusable.

I do understand that the coding will essentially be the same for all the
programs, but 2007 is so much more different to the previous versions I have
seen.

Do you have anything else? I tried the forms, and that didn't get me
anywhere. I created a Split Form, but could not randomly search postcodes,
and it would not bring up all the details.

> You must use a form to do this. It can be in Continuous View if you want it
> to show multiple rows.
[quoted text clipped - 38 lines]
> >
> > Anything would be appreciated.
Allen Browne - 31 Oct 2007 13:11 GMT
If you are using Access 2007, there is a Search box in the horizontal
scrollbar of your query. Just use that.

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for that Allen, but I can't use this in Access 2007.
> I'm new to this, so all the coding goes over my head. I'm trying to make
[quoted text clipped - 59 lines]
>> >
>> > Anything would be appreciated.
John Spencer - 31 Oct 2007 13:24 GMT
You could try a parameter query.  This is the simplest (and least flexible)
method.

Field: PostCode
Criteria: [Find which postcode]

This will automatically display a dialog box everytime the query is
executed.  It will allow you to specify ONE postcode.

Signature

John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

>I have a database that I can create a query on, to bring up certain details
> that I need to look at, without all the fluff.
[quoted text clipped - 10 lines]
>
> Anything would be appreciated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.