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
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
Comment