[AccessD] I just gotta vent

Tony Septav TSeptav at Uniserve.com
Fri Dec 13 12:38:31 CST 2013


Hey John
You thick as brick. Do not do it OnChange, try KeyUp or KeyDown.

Tony Septav
Nanaimo, BC
Canada

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
Sent: December-13-13 12:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] I just gotta vent

LOL, Charlotte...

 From my immediate previous response...

The control HAS the focus.  I am TYPING IN IT.  In the ONCHANGE event I
ask for ThixCtl.text and am told "the text property is only available if
the control has the focus"

Understand this appears to be a "special case" that a million others are
complaining about on Google, and have since the early 2000s.

1) Bound form
2) No data displayed on the form.  IOW all of the controls themselves in the
detail sections are not displayed at all.


On 12/13/2013 12:59 PM, Charlotte Foust wrote:
> John, where are you seeing the exception?  Is it in a popup error message
> or when you're stepping through the code?  The text property isn't
> available from the IDE as I recall, because the focus is in the IDE.
>   Anybody else have a different experience with that?  It sounds like you
> want to make the textbox behave like the textbox portion of a combobox.  I
> generally force the user to click a search button or something to make
sure
> the textbox value is available.
>
> Charlotte.
>
>
> On Fri, Dec 13, 2013 at 6:28 AM, John Colby <jwcolby at gmail.com> wrote:
>
>>> Not sure I follow that. As Shamil said, what are you using to determine
>> the focus? Screen.ActiveControl?
>>
>> The control HAS the focus.  I am TYPING IN IT.  In the ONCHANGE event I
>> ask for ThixCtl.text and am told "the text property is only available if
>> the control has the focus"
>>
>> EXCUSE ME?
>>
>> How can the OnChange be firing if the control does not have the focus.
>>
>> "By design" means that we have pretty toolbars to design and haven't got
>> time to fix bugs that have been around for TEN YEARS.
>>
>>
>>> Don't get that. I use unbound controls all the time for searches.
>> I don't doubt that.  What you DON'T do is use the .text property to do it
>> because "the control doesn't have the focus".  Even though I am TYPING IN
>> IT.
>>
>> BUG folks.
>>
>> Understand that this works just fine IF the (bound) form had a recordset
>> displaying something.  But think about it.  This is an EDIT form.  There
>> should not be a new record, this is for editing existing records.  The
user
>> is not allowed to enter new records. There should not be "some fake
record
>> just to allow this to work". The form should be blank and I should be
able
>> to do exactly what I am doing in order to select some value to go get
>> existing records.
>>
>> jwc
>>
>>
>> On 12/13/2013 8:38 AM, Jim Dettman wrote:
>>
>>> <<1)  The text box CAN ACCEPT the focus but Access refuses to believe
that
>>> it has the focus IF there is no data in the form.>>
>>>
>>> Not sure I follow that.  As Shamil said, what are you using to determine
>>> the focus?  Screen.ActiveControl?
>>>
>>> <<2) TxtBox.Text is not available unless the control has the focus.>>
>>>
>>>    That would be correct.   .Oldvalue is the record prior to editing,
>>> .Value
>>> is the current value or the control, and .text is the keystroke buffer
>>> before it has been committed to the control.
>>>
>>> <<3) ONLY txtbox.Text has the actual value in the control for each
>>> character typed in.  TxtBox.Value is only updated when the control loses
>>> the focus.>>
>>>
>>>    Correct.
>>>
>>> <<4) So at least one record has to be displayed in the form BEFORE the
>>> search can be used.>>
>>>
>>>    Don't get that.  I use unbound controls all the time for searches.
>>>
>>> Jim.
>>>
>>>
>>>
>>> -----Original Message-----
>>> From: accessd-bounces at databaseadvisors.com
>>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby
>>> Sent: Thursday, December 12, 2013 02:44 PM
>>> To: accessd at databaseadvisors.com
>>> Subject: [AccessD] I just gotta vent
>>>
>>> Trying to do some search kind of stuff using a text box to allow a user
>>> <<snip>>
>>>
>>>
>> --
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list