473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Tab Order Add-In?

I have a form in A97 that requires many textboxes and comboboxes (about
300). The customer insists on seeing all the information on one form
so I can't break it up into several forms. Neither they nor I want to
use a tab control. Because of all this, the Tab Order control is quite
inefficient at organizing the tab order. Even the trick of wiggling
the mouse to the right and left while dragging a control or controls to
the top or bottom of the tab order doesn't speed it up enough. One
idea is to write the names and positions of the controls to a file, put
the controls into a long column, run Auto Order, then read the file to
reset the original positions of the controls. Another idea is to play
with the TabIndex property, perhaps by clicking on the controls in the
desired tab order while running code. Has anyone produced an Add-In
that improves the user experience for developers that need to change
the Tab Order for lots of controls? Does anyone have other ideas about
a good way to do this?

James A. Fortune
CD********@FortuneJames.com

Aug 16 '06 #1
7 2272
CD********@FortuneJames.com wrote in
news:11**********************@b28g2000cwb.googlegr oups.com:
I have a form in A97 that requires many textboxes and comboboxes
(about 300). The customer insists on seeing all the information
on one form so I can't break it up into several forms. Neither
they nor I want to use a tab control. Because of all this, the
Tab Order control is quite inefficient at organizing the tab
order. Even the trick of wiggling the mouse to the right and left
while dragging a control or controls to the top or bottom of the
tab order doesn't speed it up enough. One idea is to write the
names and positions of the controls to a file, put the controls
into a long column, run Auto Order, then read the file to reset
the original positions of the controls. Another idea is to play
with the TabIndex property, perhaps by clicking on the controls in
the desired tab order while running code. Has anyone produced an
Add-In that improves the user experience for developers that need
to change the Tab Order for lots of controls? Does anyone have
other ideas about a good way to do this?
You realize that you can select and move more than one control at a
time in the tab order dialog?

And that you can set the Tab Order property in the property sheet?

And that if you drop the controls on the form in order, they'll end
up with the right tab order?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 16 '06 #2
David W. Fenton wrote:
CD********@FortuneJames.com wrote in
news:11**********************@b28g2000cwb.googlegr oups.com:
I have a form in A97 that requires many textboxes and comboboxes
(about 300). The customer insists on seeing all the information
on one form so I can't break it up into several forms. Neither
they nor I want to use a tab control. Because of all this, the
Tab Order control is quite inefficient at organizing the tab
order. Even the trick of wiggling the mouse to the right and left
while dragging a control or controls to the top or bottom of the
tab order doesn't speed it up enough. One idea is to write the
names and positions of the controls to a file, put the controls
into a long column, run Auto Order, then read the file to reset
the original positions of the controls. Another idea is to play
with the TabIndex property, perhaps by clicking on the controls in
the desired tab order while running code. Has anyone produced an
Add-In that improves the user experience for developers that need
to change the Tab Order for lots of controls? Does anyone have
other ideas about a good way to do this?

You realize that you can select and move more than one control at a
time in the tab order dialog?
Yes. I said, "while dragging a control or controls."
>
And that you can set the Tab Order property in the property sheet?
Is this something other than the TabIndex property for the individual
control that I mentioned? Neither the individual controls nor forms in
A97 have a TabOrder property. Have I overlooked something?
>
And that if you drop the controls on the form in order, they'll end
up with the right tab order?
I don't have enough foresight to create the controls in an order that
follows the final tab order :-). Once coding has begun it's
inconvenient to drop controls because A97 sometimes fails to reattach
the event to the code when the code pre-exists. But your idea solved
most of the problem. I created a page header and saw that controls
moved back from the page header went to the end of the tab order
without affecting event code. The remaining problem was getting the
controls back to their original location. With that many controls on a
form they have to aligned like a matrix so the alignment tools allow me
to get them back in position fairly easily. Thanks.

James A. Fortune
CD********@FortuneJames.com

Aug 16 '06 #3
CD********@FortuneJames.com wrote:
David W. Fenton wrote:
>CD********@FortuneJames.com wrote in
news:11**********************@b28g2000cwb.googleg roups.com:
>>I have a form in A97 that requires many textboxes and comboboxes
(about 300). The customer insists on seeing all the information
on one form so I can't break it up into several forms. Neither
they nor I want to use a tab control. Because of all this, the
Tab Order control is quite inefficient at organizing the tab
order. Even the trick of wiggling the mouse to the right and left
while dragging a control or controls to the top or bottom of the
tab order doesn't speed it up enough. One idea is to write the
names and positions of the controls to a file, put the controls
into a long column, run Auto Order, then read the file to reset
the original positions of the controls. Another idea is to play
with the TabIndex property, perhaps by clicking on the controls in
the desired tab order while running code. Has anyone produced an
Add-In that improves the user experience for developers that need
to change the Tab Order for lots of controls? Does anyone have
other ideas about a good way to do this?
You realize that you can select and move more than one control at a
time in the tab order dialog?

Yes. I said, "while dragging a control or controls."
>And that you can set the Tab Order property in the property sheet?

Is this something other than the TabIndex property for the individual
control that I mentioned? Neither the individual controls nor forms in
A97 have a TabOrder property. Have I overlooked something?
>And that if you drop the controls on the form in order, they'll end
up with the right tab order?

I don't have enough foresight to create the controls in an order that
follows the final tab order :-). Once coding has begun it's
inconvenient to drop controls because A97 sometimes fails to reattach
the event to the code when the code pre-exists. But your idea solved
most of the problem. I created a page header and saw that controls
moved back from the page header went to the end of the tab order
without affecting event code. The remaining problem was getting the
controls back to their original location. With that many controls on a
form they have to aligned like a matrix so the alignment tools allow me
to get them back in position fairly easily. Thanks.

James A. Fortune
CD********@FortuneJames.com
TabIndex is the property you are looking for.

The idea of setting TabIndex in code while clicking the controls is kind
of intriguing... it would be easy, in fact, except you would have to
write an OnClick event for every control. 300 controls... ick. If you
did this you would want an environment variable to enable/disable
setting TabIndex. Maybe there's an API call that would return the name
of the control that was clicked... would reduce the code to one instance
of a three-line procedure. hmm...
--
Smartin
Aug 16 '06 #4
CD********@FortuneJames.com wrote in
news:11**********************@i3g2000cwc.googlegro ups.com:
David W. Fenton wrote:
[]
>And that you can set the Tab Order property in the property
sheet?

Is this something other than the TabIndex property for the
individual control that I mentioned? Neither the individual
controls nor forms in A97 have a TabOrder property. Have I
overlooked something?
The TabIndex *is* the property that gets altered when dragging in
the Tab Order dialog.
>And that if you drop the controls on the form in order, they'll
end up with the right tab order?

I don't have enough foresight to create the controls in an order
that follows the final tab order :-). Once coding has begun it's
inconvenient to drop controls because A97 sometimes fails to
reattach the event to the code when the code pre-exists. But your
idea solved most of the problem. I created a page header and saw
that controls moved back from the page header went to the end of
the tab order without affecting event code. The remaining problem
was getting the controls back to their original location. With
that many controls on a form they have to aligned like a matrix so
the alignment tools allow me to get them back in position fairly
easily. Thanks.
That's great. It never occurred to me that just dragging them off
the detail and back on would change the tab order for you -- glad
you thought of that!

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Aug 17 '06 #5

<CD********@FortuneJames.comschreef in bericht news:11**********************@i3g2000cwc.googlegro ups.com...
The remaining problem was getting the controls back to their original location.
I use the following 'trick' to copy controls from one form or report to another.
Result is the controls are in the *exact* position where they were in the former form or report:

1) Create a label called UL (UpperLeft) - Make the label invisible.
Make sure the position of the label is UpperLeft (0,0)
or simply delete the label and paste it back in the section where you need it.
2) Copy the needed controls and so on TOGETHER with this label
************************************************** *
3) Paste where you need them.

Result: *Exact same position* as before.
For instance this is great for a logo or picture that you need on more forms

Arno R
Aug 17 '06 #6

David W. Fenton wrote:
>
That's great. It never occurred to me that just dragging them off
the detail and back on would change the tab order for you -- glad
you thought of that!

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
The idea would likely never have occurred to me without your comment.
I might give Smartin's idea a try anyway though. It sounds fun.

Thanks again,

James A. Fortune
CD********@FortuneJames.com

Aug 17 '06 #7
CD********@FortuneJames.com wrote:
David W. Fenton wrote:
>That's great. It never occurred to me that just dragging them off
the detail and back on would change the tab order for you -- glad
you thought of that!

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

The idea would likely never have occurred to me without your comment.
I might give Smartin's idea a try anyway though. It sounds fun.

Thanks again,

James A. Fortune
CD********@FortuneJames.com
Heh, let me know what you find out (^:

Also seems like you could design your own Tab Order control using a list
box with a much larger work area.

And I suppose you know the trick of setting tab orders in reverse? This
just spares you the trouble of remembering which index you are on as you
click through the controls. You click the last control in the desired
tab order, set its index to zero. Then click the next-to last, set it to
zero, and so on to the first control, setting each index to zero as you
go. This is not quite as convenient in Access as it is in VB though.

--
Smartin
Aug 17 '06 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Scott | last post by:
I have a view that contains the following SQL1 and it takes about 500ms to run with Explain Plan EXP1. However, if I add an order by clause(e.g. select * from view1 order by ID desc), it will then...
4
by: Tim923 | last post by:
The following lines were tried: x1 = (-b + sqrt(pow(b,2)-(4*a*c))) /(2*a); x1 = (-b + sqrt(pow(b,2)-(4*a*c))) / 2*a; I noticed that the last parentheses were optional and didn't change...
13
by: Dark Rayden | last post by:
Hi! I recently got a strange problem and I have no idea on the solution. I try to do a ORDER BY statement with a fixed order of values, because my client want's it this way. My approach is...
5
by: Dave | last post by:
Hi, I am currently writing a requirements gathering system which which have requirement values of 1.1, 1.1.2, 1.1.3, 2.3.4.5 etc etc. This works fine stored as varchar in SQL Server 2000 until...
2
by: Silvia | last post by:
Hi I have a datagrid with values and when I order by one column and select one row the row selected not is de correct is that the original one row before order The code is that Dim gTable As...
1
by: weetat.yeo | last post by:
Hi all , I have 2 table as show below : When do join the 2 table using SQL statement , how i going to order by Table A sw_version then Table B card_sw_version_no column ? Anyone have ideas ?...
1
by: Simon | last post by:
currently am builing a access ordering system. I was going to use autonumber as the order number but have heard that it is not recomended to do this. I have read that i need some code that will...
7
by: solen | last post by:
Hello, Debian with Perl, unixODBC. I have a problem with "ORDER BY". An ordinary SQL workes fine and I can print it out to the webpage. But when I add the ORDER BY it stops working. Any...
2
aas4mis
by: aas4mis | last post by:
I have a query that works fine when ordered by the puller id (cf.op.id). The problem comes when I try to order by the sum of the boxes (sum(cf.qq)). I have read "UniVerse SQL Reference" and...
0
by: Xiaode | last post by:
I only manage to do this assignment using combo box anyone has any idea to do this using option box??? Specifications Create a form based application that resembles the above figure. For each...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.