[AccessD] I just gotta vent

Doug Steele dbdoug at gmail.com
Fri Dec 13 13:04:04 CST 2013


Just off the top of my head - I've avoided problems with forms with no data
by putting the actual data bound form in a subform of a 'dummy' parent
form.  I don't know if this would help you or not.

Doug


On Fri, Dec 13, 2013 at 10:38 AM, Tony Septav <TSeptav at uniserve.com> wrote:

> 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
>
> --
> 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