Help with specified search options in form.

[Ganimex]

Hello,

I am very new with access 2007 and have little Access or VBA experiance. In fact I have only been using Access for around 3 weeks. I am creating a massive DB with information for over 350 clients. The idea is to create the database and dispose of 700+ excel files and the pathetic directory system we currently have but we need Access to be better than the large file system we currently have.

My question is this:
I am trying to create a search button that will apply a filter and will also work with other filters that may be applied at the same time. The reason for this is to minimize the amount of customers we have to sort through. Lets say the button is to show all prepay clients and once its pressed I need a box to fill with the clients that are all prepay only. We have Prepay, Monthly and Spot work as the 3 options. Also I need a button to work along with the others that show active or inactive.

For example I need to be able to press buttons and see in a selectable (in the box the client double clicked needs to take me to that clients details form) vertical box only clients that are Active/ Monthly/ Preferred/ Custom High.

Is this possible and how should I go about doing it.

Thank you lots,
Ganimex

[repath]

Hello Ganimex,
your task is simple, if you know how to create a SIMPLE QUERY.

If you know, then as a first step:
Create the said PREPAY, MONTHLY, SPOTWORK Queries.

as second step:
place a combo/drop down list box and select its source property to be VALUE LIST and type these three values in the combo box.

you have docmd.openquery
follow the syntax and write at the click code of the combo box

docmd.openquery "Query name"
eg: docmd.OpenQuery "prepay", acViewNormal,acReadOnly

you can see the selected details.

My advice is to do more homework on Queries as you have database.

These queries can be automatically be exported to Ms. Excel.

Also you have autoreport option in reports tab, by selecting the query as its source, a report is also built automatically, which also can be exported to Ms. Excel format.

With regards
Repath Athyala
www.Repath.WordPress.com

[munkee]

I would do something similar to the dynamic "where" string creation that allen browne uses in his search/filter scripts.

http://allenbrowne.com/ser-62.html

Take a look at the link there.

[Ganimex]

Thank you for the prompt response. Let me take a couple minutes and go over the link you posted.

Thanks Again,
GanImeX