Doug Steele
dbdoug at gmail.com
Fri Dec 13 13:06:01 CST 2013
Sorry, didn't finish my thought. Your search textbox would be in the parent form, so it wouldn't get confused by the empty subform. Doug On Fri, Dec 13, 2013 at 11:04 AM, Doug Steele <dbdoug at gmail.com> wrote: > 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 >> > >