Autofilter functionality for QBF

B

Brian

I would like to use a QBF in which I only need the basic functionality of the
Autofilter in MS Excel, nothing more. The people using the database will be
completely confused if they have to open queries and search/sort on their
own. Since they are very familiar with the Autofilter in Excel, I figure this
would be beneficial. Can someone point me in the right direction?
 
V

Vincent Johns

Brian said:
I would like to use a QBF in which I only need the basic functionality of the
Autofilter in MS Excel, nothing more. The people using the database will be
completely confused if they have to open queries and search/sort on their
own. Since they are very familiar with the Autofilter in Excel, I figure this
would be beneficial. Can someone point me in the right direction?
Click to expand...

Here's an idea that will give you EXACTLY the basic functionality of the
Autofilter in MS Excel.

In Excel, use Data --> Get External Data --> New Database Query, and
import the Query or Table you wish to use. Then turn on Data --> Filter
--> Autofilter.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
D

Dr Alok Modi MD

If you want to work in access only, you could also make a command button and
use it to bring up the find dialog box, that will give you enough
funtionality for your users to search exactly what they are looking for in a
particular text box in your form.

Dr Alok Modi MD
 
Top