Disabling form search and filter icon in navigation buttons bar?

[Peter W]

I need to upgrade an Access 2000 .mdb database to run with an Access 2007
installation. This gives me access to a lot of new features. But some I would
like to be without.

In quite a few forms I display query results in one or more subforms
presented in datasheet view. I have enabled the navigation buttons. This is
mainly done because it gives an easy access to the total number of records in
the query. And it also give easy access to last and first record

In Access 2007 the bar in the bottom of a form in datasheet view now not
only displays the navigation buttons with the record count it also displays
the filter status on the form and have a nice little search box.


I really would like to disable/hide the filter status and most important the
search box and still keep the navigation buttons.


form.navigationbuttons = false removes the bar but this leaves me with the
job of adding a query for counting the records for each sub form and then
adding my own navigation buttons to each form.

I use my own filter routines and have disabled access form filter. That is
not a problem in 2000 but in 2007 I get a greyed out icon displaying "no
filter" right after the navigation buttons. This is a bit anoying because in
some the smaller subform only half of the icon is viewable.

My main problem that in some of the subforms it is possible get a very large
number of records (150.000+) returned from the query. If anything is entered
in the navigation buttons seach box it appears the access does a "on the fly
free text search" in all fields in all records. This crashes access 2007.

I had the same problem with the "dropdown menu" that in datasheet view
allows the user to select resorting directly. It also crashes access 2007.
The datasheet dropdown menu are now disabled.

If I cannot get rid of the new fuctions in the navigation buttons bar are
there any way either per form or for the total database to disable the "on
the fly" search?

 

[Minton M]

I need to upgrade an Access 2000 .mdb database to run with an Access 2007
installation. This gives me access to a lot of new features. But some I would
like to be without.

In quite a few forms I display query results in one or more subforms
presented in datasheet view. I have enabled the navigation buttons. This is
mainly done because it gives an easy access to the total number of records in
the query. And it also give easy access to last and first record

In Access 2007 the bar in the bottom of a form in datasheet view now not
only displays the navigation buttons with the record count it also displays
the filter status on the form and have a nice little search box.

I really would like to disable/hide the filter status and most important the
search box and still keep the navigation buttons.

form.navigationbuttons = false removes the bar but this leaves me with the
job of adding a query for counting the records for each sub form and then
adding my own navigation buttons to each form.

I use my own filter routines and have disabled access form filter. That is
not a problem in 2000 but in 2007 I get a greyed out icon displaying "no
filter" right after the navigation buttons. This is a bit anoying because in
some the smaller subform only half of the icon is viewable.

My main problem that in some of the subforms it is possible get a very large
number of records (150.000+) returned from the query. If anything is entered
in the navigation buttons seach box it appears the access does a "on the fly
free text search" in all fields in all records. This crashes access 2007.

I had the same problem with the "dropdown menu" that in datasheet view
allows the user to select resorting directly. It also crashes access 2007.
The datasheet dropdown menu are now disabled.

If I cannot get rid of the new fuctions in the navigation buttons bar are
there any way either per form or for the total database to disable the "on
the fly" search?

Peter,

I don't know of any reliable programatic way to remove these buttons
selectively. I have written a subform that provides navigation buttons
and a recordcount that I can dump onto any form holding a datasheet to
stop users using the new features. To be honest, this is the easiest
way of achieving what you describe. It also enables you to change the
look and feel of the app so it doesn't feel so much like an Access
application.

I was hoping that Access would open up the object model on datasheets
in the new versions but they've been made more complicated without any
ability to capture their events. Argh.

-- James

 

[Peter W]

Well I had been hoping that there at least was a way of trapping the search
event so I could "hot-fix" it by clearing either the event trigger or the
search value

even a "global search disable" would have been usable.

But thanks anyway