Re: Trigger event on change to unbound text in unbound form progra

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: AbeR (AbeR_at_discussions.microsoft.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 11:33:03 -0800

Thanks!

"John Doe" wrote:

> Try using the OnChange event for the date field instead of the
> AfterUpdate event.
>
> That seems to work pretty well for me (I have a database app that I'm
> basically doing the same thing).
>
>
> On Thu, 6 Jan 2005 16:53:41 -0000, "Brendan Reynolds" <brenreyn at
> indigo dot ie> wrote:
>
> >The Before and After Update events of a control are not fired when you
> >change the value of that control programmatically, if that is what you mean.
> >The usual solution is to call any code that you would have called from the
> >Before or After Update event from the code that changed the value. If you
> >don't want to do that, a possible alternative might be to use the Timer
> >event of the form. Use a static variable in the Timer event to keep track of
> >the previous value of the control, and compare that to the current value.
>
>
>
>
> "AbeR" <AbeR@discussions.microsoft.com> wrote in message
> news:F08C9222-14EA-4D43-A9F3-42C146416814@microsoft.com...
> > I'm developing an adp (access project)
> >
> > I have an unbound field in an unbound form that I need to check for
> > changed
> > data from another form to trigger an action. I don't seem to generate an
> > even
> > when that happens.
> >
> > Let me explain:
> > I have built a dashboard form that collects information from many tables.
> > A
> > set of those text controls return date fields from different tables. If I
> > uses an after update on any of these controls I can write to the
> > appropriate
> > table (so far no problem).
> >
> > I have a form that is essentially a calendar in dialog box to improve the
> > user interface. Double click on any txtbox that should contain dates and
> > the
> > date is shown in the calendar. Change the calendar and the date appears in
> > the appropriate text box (so far no problem)
> >
> > If I change the date in any text box by physically overwriting the
> > contents
> > the after_update event works. If I change the date by using my calendar
> > control dialog form the text box renders the correct date, but I can't
> > seem
> > to trigger an event.
> >
> > Any suggestions (without having to write ugly, unmentionable code in the
> > calendar form since each textbox does something different?)
> >
> > Thank you for any recommendations.
> > -- Abe
> >
>
>
>

Relevant Pages

  • Re: Trigger event on change to unbound text in unbound form progra
    ... Thanks Brendan. ... > change the value of that control programmatically, if that is what you mean. ... >> data from another form to trigger an action. ... >> date is shown in the calendar. ...
    (microsoft.public.access.forms)
  • Re: Calendar code not working
    ... the workbook or worksheet being protected (you also checked the workbook, ... and Insert controls, in the ActiveX controls I have listed "Calendar Control ... I do have the mscal.ocx file on my office computer. ...
    (microsoft.public.excel.misc)
  • Re: Calendar code not working
    ... I chose to "Repair" the installation and the Calendar control now works ... I presume it's hidden within the sheet somehow and you need ... I do have the mscal.ocx file on my office computer. ...
    (microsoft.public.excel.misc)
  • RE: Actual Date
    ... control is populated programmatically as it is in this case. ... The only thing wrong with that is that now the calendar ... Private Sub cmdMonthDown_Click ... Select Case KeyCode ...
    (microsoft.public.access.gettingstarted)
  • Re: Calendar code not working
    ... I had tried to insert the Calendar by being in design mode. ... The Calendar control really confuses me as, where does it go when you do ... Objects have been inserted into a sheet. ... I do have the mscal.ocx file on my office computer. ...
    (microsoft.public.excel.misc)