Hi everyone,

I've developed a database for several users where I work. I have the
full fledged version of access, however the users seem to only have a
'reader' as such that doesn't allow them to view the database window
or edit the DB. This is FINE - perfect in fact.

However, it also limits the users from using the mouse to copy paste
and most annoyingly, it doesn't allow them to select the sort A-Z, Z-A
options that are available to me to sort columns in a datasheet.

Is it possible to enable this in any other way?

If I have a datasheet as a subform and my users want to sort any of
the 4 columns alphabetically, is there a button I can add to the
form??

Any help would be appreciated!

Cheers
DeZZar!

"DeZZar" <derrick.goostrey (AT) gmail (DOT) com> wrote

It sounds like the startup options have been limited. Either unrestrict the
startup options or else provide custom menus and toolbars.

Keith.
www.keithwilby.co.uk

DeZZar wrote:
They should be able to right click in any column and choose Sort Ascending
or Descending.

If they want to sort 4 columns, they can click on one header and drag across
to select 4 columns, then move the mouse pointer off the column headers and
right click.


Add a button onto your main form, and add these lines to the Click event:

Me.subform_name.SetFocus
DoCmd.RunCommand acCmdSortAscending