Prev: Datasheet Subform Query
Next: Free migration kit for MS Access developers: MS Office 2010 Web Apps
From: esn on 27 May 2010 14:20
I have a from with a whole bunch of subforms contained within a tab
control, so that users can enter data into five or six related
tables. In most cases the subforms are in datasheet view so that
users can see all the related records from a particular table as they
enter them, rather than viewing them one at a time. I prefer using
datasheet view rather than a continuous form because it allows me to
use the space on the form better and tends to look more like the
physical datasheets on which the data were recorded.

In the interest of keeping users from screwing around too much with
things or getting confused, I'd like to hide the drop-down arrows in
the column headings that bring up the sort/filter menu. I tried
setting the allow filters property to no, but the arrows are still
there (because sorting is still allowed). Any way to hide or disable
those things?
From: Tom van Stiphout on 28 May 2010 10:11
On Thu, 27 May 2010 11:20:07 -0700 (PDT), esn <ericnewkirk(a)gmail.com>
wrote:

At the Form level, set the Shortcut Menu to No.

-Tom.
Microsoft Access MVP


>I have a from with a whole bunch of subforms contained within a tab
>control, so that users can enter data into five or six related
>tables. In most cases the subforms are in datasheet view so that
>users can see all the related records from a particular table as they
>enter them, rather than viewing them one at a time. I prefer using
>datasheet view rather than a continuous form because it allows me to
>use the space on the form better and tends to look more like the
>physical datasheets on which the data were recorded.
>
>In the interest of keeping users from screwing around too much with
>things or getting confused, I'd like to hide the drop-down arrows in
>the column headings that bring up the sort/filter menu. I tried
>setting the allow filters property to no, but the arrows are still
>there (because sorting is still allowed). Any way to hide or disable
>those things?
 | 
Pages: 1
Prev: Datasheet Subform Query
Next: Free migration kit for MS Access developers: MS Office 2010 Web Apps