Add-In

S

Steve S

When viewing the Tab Order of controls on a form I see this neat pop-up that
allows me to click and drag controls names to get the tab order sorted in the
way I want. Is this, or a similar, utility-add in-whatever available for
general use and if so how do I get it?

Steve s.
 
A

Al Campagna

Steve,
Not sure what "add-in" you're referring to, but Access already has a View/TabOrder
dialog box that does just that. You can Auto Order the fields, or select a field and drag
it up the Tab Order sequence listing.
 
S

Steve S

Yes, I know that but I would like to know if the code behind the
View/TabOrder dialog box is available for developers to use in their apps. I
need to be able to let users determine the "sort order" of records
dynamically. Now I have them type in a number to set the sort order but it
would be nice to let them 'click and drag'.

Steve
 
A

Al Campagna

Steve,
Not that I'm aware of...
That could be programatically handled through the OrderBy/OrderByOn property of the
form.
The user could select a few sort criteria fields and Asc or Desc, via combos and
checkboxes, and a multiple field OrderBy statement could be concatenated to create and
apply an OrderBy property. Probably a sorting dialog popup form would be a good way to
assemble the sorting criteria
..--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
J

J. Goddard

Hi -

The tab order has nothing to do with the sort order of the form's
records. You can change the tab order in VBA by setting the TabIndex
property of form controls, but that still only affects the order the
cursor moves from one control to the next.

John
 
S

Steve S

I guess I did not do a very good job of presenting my problem. I used the
EXAMPLE of the TabOrder screen to hopefully show what I wanted to do with
ANOTHER set of recoreds. I know that the tab order has nothing to do with
the way records are displayed, that just sets the order in which the tab
stops are sequenced. when i use the View/TabOrder dialog screen to click and
drag the control names the Tab Indes is changed.

I have records that display in a sub form in a certain order. To change
that order the user can enter his/her preference in the sortkey field ie: to
get a record to be at the top of the list he/she enters a 1 in the sort key
field and so forth. thsi is kind of cumgersom.

what I want to do is let them click and drag the selected record to the top
of the display and have the sor key change automatically ( as the tab indes
changes when i move a control name to the top of the list).

I thought there might be an add-in or freeware to accomplish this. Again I
am using the View/TabOrder dialog as an axample of that I want to accomplish
with a different record set.

thanks for any help.
 
Top