Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Update linked table

Discussion in 'Information Technology' started by Peter Neumaier, Jul 28, 2006.

  1. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    Hi NG!

    I am trying to update a linked table through an access form.

    My form receives its data through a query (defined as "Record Source")
    and contains a textfield. The current status is, that after updating
    the textfield, my table gets only updated if I leave the form. I would
    like to update the linked table after leaving the textfield.

    What is the way to make that happen?

    Thank you and regards,
    Peter
     
  2. Loading...


  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    put your code in the fields afterupdate event instead of the forms
    afterupdate

    Pieter

    "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    news:1148297378.687438.128610@38g2000cwa.googlegroups.com...
    > Hi NG!
    >
    > I am trying to update a linked table through an access form.
    >
    > My form receives its data through a query (defined as "Record Source")
    > and contains a textfield. The current status is, that after updating
    > the textfield, my table gets only updated if I leave the form. I would
    > like to update the linked table after leaving the textfield.
    >
    > What is the way to make that happen?
    >
    > Thank you and regards,
    > Peter
    >
     
  4. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    there is no code, that is what I am asking for?

    thx&regards

    Pieter Wijnen wrote:
    > put your code in the fields afterupdate event instead of the forms
    > afterupdate
    >
    > Pieter
    >
    > "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    > news:1148297378.687438.128610@38g2000cwa.googlegroups.com...
    > > Hi NG!
    > >
    > > I am trying to update a linked table through an access form.
    > >
    > > My form receives its data through a query (defined as "Record Source")
    > > and contains a textfield. The current status is, that after updating
    > > the textfield, my table gets only updated if I leave the form. I would
    > > like to update the linked table after leaving the textfield.
    > >
    > > What is the way to make that happen?
    > >
    > > Thank you and regards,
    > > Peter
    > >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    If you use a macro, same thing applies (afterupdate or close)

    HTH

    Pieter


    "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    news:1148301936.714768.142620@y43g2000cwc.googlegroups.com...
    > there is no code, that is what I am asking for?
    >
    > thx&regards
    >
    > Pieter Wijnen wrote:
    >> put your code in the fields afterupdate event instead of the forms
    >> afterupdate
    >>
    >> Pieter
    >>
    >> "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    >> news:1148297378.687438.128610@38g2000cwa.googlegroups.com...
    >> > Hi NG!
    >> >
    >> > I am trying to update a linked table through an access form.
    >> >
    >> > My form receives its data through a query (defined as "Record Source")
    >> > and contains a textfield. The current status is, that after updating
    >> > the textfield, my table gets only updated if I leave the form. I would
    >> > like to update the linked table after leaving the textfield.
    >> >
    >> > What is the way to make that happen?
    >> >
    >> > Thank you and regards,
    >> > Peter
    >> >

    >
     
  6. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    how to update the table with the inserted data in the textfield, that's
    all I need!?

    regards
    peter
     
  7. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    In the AfterUpdate Event of the Control (Click builder icon .. /select Event
    Procedure)

    Private Sub Text1_AfterUpdate
    On Error Resume Next
    Me.Dirty = False
    End Sub

    "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    news:1148303037.420380.91990@u72g2000cwu.googlegroups.com...
    > how to update the table with the inserted data in the textfield, that's
    > all I need!?
    >
    > regards
    > peter
    >
     
  8. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    i got a date of format mm/dd/yy in the textfield your code screws up
    the whole format ...
     
  9. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    no, but access does if your regional settings differ from mm/dd/yy (Access
    then displays the data according to these settings)

    Pieter

    "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    news:1148304583.202725.299700@i39g2000cwa.googlegroups.com...
    >i got a date of format mm/dd/yy in the textfield your code screws up
    > the whole format ...
    >
     
  10. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    sry, to avoid confusion, i probably didnt say it properly ....

    access changes my date format to a time format?
     
  11. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    change the format property to mm/dd/yy (should do the trick)

    Pieter

    "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    news:1148305345.521899.262460@u72g2000cwu.googlegroups.com...
    > sry, to avoid confusion, i probably didnt say it properly ....
    >
    > access changes my date format to a time format?
    >
     
  12. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    doesnt work, after editing the textfield, the value jumps automatically
    to 12:00 am
     
  13. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    OKIDO
    Please retain all text when answering in newsgroups, it is annoying to have
    to read all previous ones when it's no longer fresh in memory

    Private Sub Text1_AfterUpdate
    On Error Resume Next
    ' handle mm/dd/yy
    Me.Text1 =
    DateSerial(right(me.text1,2),Left(me.text1,2),Mid(me.text1,4,2))
    Me.Dirty = False
    End Sub

    Pieter

    PS what happened to your data when you closed the form?
    All my code did was to save the edited data

    "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    news:1148306789.402658.202970@y43g2000cwc.googlegroups.com...
    > doesnt work, after editing the textfield, the value jumps automatically
    > to 12:00 am
    >
     
  14. Peter Neumaier

    Peter Neumaier
    Expand Collapse
    Guest

    pieter,

    it's working, thx man ;)
    Pieter Wijnen wrote:
    > OKIDO
    > Please retain all text when answering in newsgroups, it is annoying to have
    > to read all previous ones when it's no longer fresh in memory
    >
    > Private Sub Text1_AfterUpdate
    > On Error Resume Next
    > ' handle mm/dd/yy
    > Me.Text1 =
    > DateSerial(right(me.text1,2),Left(me.text1,2),Mid(me.text1,4,2))
    > Me.Dirty = False
    > End Sub
    >
    > Pieter
    >
    > PS what happened to your data when you closed the form?
    > All my code did was to save the edited data
    >
    > "Peter Neumaier" <Peter.Neumaier@gmail.com> wrote in message
    > news:1148306789.402658.202970@y43g2000cwc.googlegroups.com...
    > > doesnt work, after editing the textfield, the value jumps automatically
    > > to 12:00 am
    > >
     

Share This Page