Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
John Sh's latest activity
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
I stand corrected on that point, however <You can set focus on any control as long as it's not disabled.> and visible
Friday at 1:49 AM
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
If a control has focus and you try to setfocus to that control you will get an error. Majp insists on leaving out the "if activecontrol...
Friday at 1:27 AM
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
I've changed the code to the following and it now works correctly, even with the same value in each combo. You certainly put me on the...
Friday at 12:25 AM
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Actually it only appears to work. It returns the contents of the control, not the name. So if I put 1 in each combo there is no change...
Friday at 12:15 AM
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Thank you. That does exactly what I want, although I did get trapped where there was no active control. I can't use it in a load event...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Au contraire. You have left out the comparison. Your code actually does nothing. The code, below from arnelgp mirrors my code but passes...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
what I wrote is this, Private Sub isInFocus(str As String) If Me.ActiveControl.Name = str Then Exit Sub...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Do you think there is a difference between the active control and the control with focus? Of course not, they are one and the same. What...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Read what you have just written, you have proven yourself wrong. <<<if cboSpecies does not have focus it now has focus>>> or "if...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
That is your interpretation. It is not what I have written. In plain English. If the input to the sub, str, is the same as the name of...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Read the code. there is no "Else" clause involved. Private Sub isInFocus(str As String) If Me.ActiveControl.Name <> str Then...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
Sounds good but the rowsource for the controls has to be changed to correct for the different inputs. Private Sub btnBot_Click()...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
That's precisely what it's supposed to do. If the active control is the same as the control having setfocus applied then nothing...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
It's highlighted because I was stepping through to get the screen shots. I have tried the long version, same result but I haven't tried...
Mar 21, 2024
J
John Sh
replied to the thread
When "X" is not equal to "X"
.
In the case that a query only returns one result, the combobox waits to be updated, In this case I call combo_afterupdate which has the...
Mar 21, 2024
Home
Members
Top
Bottom