"jahn" <jahnbigbooty@[EMAIL PROTECTED]
> schreef in bericht
news:39c11119-e9c6-4816-afd2-4bffbf655108@[EMAIL PROTECTED]
> Hello -
>
> I'm wondering if anyone has a solution to the way the sort dialog
> opens when users choose Sort Records... (this is FM 9, Mac &
> Windows). The dialog that opens appears to always default to the
> Current Layout set of fields rather than Current Table, whereas the
> Current Table field set would be much better for my users (organized
> according to function with specific sort fields at the top).
>
> I know I can script the sort function using custom menus etc. to
> always open with a specific set of fields on the right-hand side, but
> that can be frustrating for users who do a custom sort, realize they
> wanted it done slightly different and reopen the sort dialog only to
> find all the fields they'd dragged over to the right-hand box have
> reverted to the scripted default. Is there a simple work-around so
> Current Table always shows in the left-hand box? Any suggestion would
> be great.
>
> Thanks.
>
> -Jahn
Jahn,
Create a script that does the sorting. Specify the sort order, don't tick
the 'perform without dialog' box. This defaults to current table, or can
be
made to default to any layout you might need.
Disable the sort from the menu with a custom menu, so your users can't use
that any more. Then make a button on your layout-that fires the script.
If
you only need onbe table to be referenced you could also re-route the
ctrl-s
with a custom menu, so ctrl-s will trigger your script instead of the
standard sort.. If your are a bit into scripting you could make it so that
ctrl-s always fires a main script, which then branches out for each table
you need.
something like:
if current layout is A
do this sort
if current layout is B
do that sort
etc
end if
Remember to NEVER work on your original menu-set, but always start out
with
making a copy and working on that. If you screw up using the original set
you might loose access to you file.
Keep well, Ursus
|
