Welcome to SPN

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

Sign Up Now!

combo data

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

Tags:
  1. John

    John
    Expand Collapse
    Guest

    i use dropdown (combo box) to enter data for example: -
    in form
    i click : item no (combo box)
    auto update : item name
    but
    in table
    item no is updated, but item name is not updated.

    pls help me !

    thanks

    JOHN
     
  2. Loading...


  3. Jeff Boyce

    Jeff Boyce
    Expand Collapse
    Guest

    John

    Is ItemNo defined as a Unique value? (It sounds like it isn't).

    In your combo box, are you binding the ItemNo or the ItemName?

    Regards

    Jeff Boyce
    Microsoft Office/Access MVP


    "John" <John@discussions.microsoft.com> wrote in message
    news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    >i use dropdown (combo box) to enter data for example: -
    > in form
    > i click : item no (combo box)
    > auto update : item name
    > but
    > in table
    > item no is updated, but item name is not updated.
    >
    > pls help me !
    >
    > thanks
    >
    > JOHN
     
  4. John

    John
    Expand Collapse
    Guest

    Hi Jeff

    ItemNo defined as number
    combo box binding ItemNo

    Thanks

    JOHN

    "Jeff Boyce" wrote:

    > John
    >
    > Is ItemNo defined as a Unique value? (It sounds like it isn't).
    >
    > In your combo box, are you binding the ItemNo or the ItemName?
    >
    > Regards
    >
    > Jeff Boyce
    > Microsoft Office/Access MVP
    >
    >
    > "John" <John@discussions.microsoft.com> wrote in message
    > news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    > >i use dropdown (combo box) to enter data for example: -
    > > in form
    > > i click : item no (combo box)
    > > auto update : item name
    > > but
    > > in table
    > > item no is updated, but item name is not updated.
    > >
    > > pls help me !
    > >
    > > thanks
    > >
    > > JOHN

    >
    >
    >
     
  5. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    I Think we might have a denormalized table issue
    He wants to store Both values from the combo (bad practise) or to display
    the name on the form (good practise)
    either way:

    Sub Cbo_AfterUpdate()
    Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    End Sub

    Pieter


    "John" <John@discussions.microsoft.com> wrote in message
    news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    > Hi Jeff
    >
    > ItemNo defined as number
    > combo box binding ItemNo
    >
    > Thanks
    >
    > JOHN
    >
    > "Jeff Boyce" wrote:
    >
    >> John
    >>
    >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    >>
    >> In your combo box, are you binding the ItemNo or the ItemName?
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >>
    >> "John" <John@discussions.microsoft.com> wrote in message
    >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    >> >i use dropdown (combo box) to enter data for example: -
    >> > in form
    >> > i click : item no (combo box)
    >> > auto update : item name
    >> > but
    >> > in table
    >> > item no is updated, but item name is not updated.
    >> >
    >> > pls help me !
    >> >
    >> > thanks
    >> >
    >> > JOHN

    >>
    >>
    >>
     
  6. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    I Think we might have a denormalized table issue
    He wants to store Both values from the combo (bad practise) or to display
    the name on the form (good practise)
    either way:

    Sub Cbo_AfterUpdate()
    Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    End Sub

    Pieter


    "John" <John@discussions.microsoft.com> wrote in message
    news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    > Hi Jeff
    >
    > ItemNo defined as number
    > combo box binding ItemNo
    >
    > Thanks
    >
    > JOHN
    >
    > "Jeff Boyce" wrote:
    >
    >> John
    >>
    >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    >>
    >> In your combo box, are you binding the ItemNo or the ItemName?
    >>
    >> Regards
    >>
    >> Jeff Boyce
    >> Microsoft Office/Access MVP
    >>
    >>
    >> "John" <John@discussions.microsoft.com> wrote in message
    >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    >> >i use dropdown (combo box) to enter data for example: -
    >> > in form
    >> > i click : item no (combo box)
    >> > auto update : item name
    >> > but
    >> > in table
    >> > item no is updated, but item name is not updated.
    >> >
    >> > pls help me !
    >> >
    >> > thanks
    >> >
    >> > JOHN

    >>
    >>
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  7. John

    John
    Expand Collapse
    Guest

    Hi Pieter

    i am not good in visual basic. I do not understand your advise, pls explain
    other way

    JOHN

    "Pieter Wijnen" wrote:

    > I Think we might have a denormalized table issue
    > He wants to store Both values from the combo (bad practise) or to display
    > the name on the form (good practise)
    > either way:
    >
    > Sub Cbo_AfterUpdate()
    > Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    > End Sub
    >
    > Pieter
    >
    >
    > "John" <John@discussions.microsoft.com> wrote in message
    > news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    > > Hi Jeff
    > >
    > > ItemNo defined as number
    > > combo box binding ItemNo
    > >
    > > Thanks
    > >
    > > JOHN
    > >
    > > "Jeff Boyce" wrote:
    > >
    > >> John
    > >>
    > >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    > >>
    > >> In your combo box, are you binding the ItemNo or the ItemName?
    > >>
    > >> Regards
    > >>
    > >> Jeff Boyce
    > >> Microsoft Office/Access MVP
    > >>
    > >>
    > >> "John" <John@discussions.microsoft.com> wrote in message
    > >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    > >> >i use dropdown (combo box) to enter data for example: -
    > >> > in form
    > >> > i click : item no (combo box)
    > >> > auto update : item name
    > >> > but
    > >> > in table
    > >> > item no is updated, but item name is not updated.
    > >> >
    > >> > pls help me !
    > >> >
    > >> > thanks
    > >> >
    > >> > JOHN
    > >>
    > >>
    > >>

    >
    >
    >
     
  8. John

    John
    Expand Collapse
    Guest

    Hi

    my question is I key in data in form

    itemno (combo box)
    itemname (auto appear)

    after key-in, data record in form but check in table, itemname is not
    update. in report to print out itemname is "blank"

    Pls help me

    Thanks
    JOHN

    "Pieter Wijnen" wrote:

    > I Think we might have a denormalized table issue
    > He wants to store Both values from the combo (bad practise) or to display
    > the name on the form (good practise)
    > either way:
    >
    > Sub Cbo_AfterUpdate()
    > Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    > End Sub
    >
    > Pieter
    >
    >
    > "John" <John@discussions.microsoft.com> wrote in message
    > news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    > > Hi Jeff
    > >
    > > ItemNo defined as number
    > > combo box binding ItemNo
    > >
    > > Thanks
    > >
    > > JOHN
    > >
    > > "Jeff Boyce" wrote:
    > >
    > >> John
    > >>
    > >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    > >>
    > >> In your combo box, are you binding the ItemNo or the ItemName?
    > >>
    > >> Regards
    > >>
    > >> Jeff Boyce
    > >> Microsoft Office/Access MVP
    > >>
    > >>
    > >> "John" <John@discussions.microsoft.com> wrote in message
    > >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    > >> >i use dropdown (combo box) to enter data for example: -
    > >> > in form
    > >> > i click : item no (combo box)
    > >> > auto update : item name
    > >> > but
    > >> > in table
    > >> > item no is updated, but item name is not updated.
    > >> >
    > >> > pls help me !
    > >> >
    > >> > thanks
    > >> >
    > >> > JOHN
    > >>
    > >>
    > >>

    >
    >
    >
     
  9. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    On the properties page for the cbo find AfterUpdate Event -> click the
    builder (...) -> select: Event Procedure -> ok
    & type the code (using your controlname for the combo, instead of cbo and/or
    ItemName)

    Pieter

    "John" <John@discussions.microsoft.com> wrote in message
    news:F8729820-DD75-4EF9-AC19-4B4B0251FFCA@microsoft.com...
    > Hi Pieter
    >
    > i am not good in visual basic. I do not understand your advise, pls
    > explain
    > other way
    >
    > JOHN
    >
    > "Pieter Wijnen" wrote:
    >
    >> I Think we might have a denormalized table issue
    >> He wants to store Both values from the combo (bad practise) or to display
    >> the name on the form (good practise)
    >> either way:
    >>
    >> Sub Cbo_AfterUpdate()
    >> Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    >> End Sub
    >>
    >> Pieter
    >>
    >>
    >> "John" <John@discussions.microsoft.com> wrote in message
    >> news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    >> > Hi Jeff
    >> >
    >> > ItemNo defined as number
    >> > combo box binding ItemNo
    >> >
    >> > Thanks
    >> >
    >> > JOHN
    >> >
    >> > "Jeff Boyce" wrote:
    >> >
    >> >> John
    >> >>
    >> >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    >> >>
    >> >> In your combo box, are you binding the ItemNo or the ItemName?
    >> >>
    >> >> Regards
    >> >>
    >> >> Jeff Boyce
    >> >> Microsoft Office/Access MVP
    >> >>
    >> >>
    >> >> "John" <John@discussions.microsoft.com> wrote in message
    >> >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    >> >> >i use dropdown (combo box) to enter data for example: -
    >> >> > in form
    >> >> > i click : item no (combo box)
    >> >> > auto update : item name
    >> >> > but
    >> >> > in table
    >> >> > item no is updated, but item name is not updated.
    >> >> >
    >> >> > pls help me !
    >> >> >
    >> >> > thanks
    >> >> >
    >> >> > JOHN
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>
     
  10. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    On the properties page for the cbo find AfterUpdate Event -> click the
    builder (...) -> select: Event Procedure -> ok
    & type the code (using your controlname for the combo, instead of cbo and/or
    ItemName)

    Pieter

    "John" <John@discussions.microsoft.com> wrote in message
    news:F8729820-DD75-4EF9-AC19-4B4B0251FFCA@microsoft.com...
    > Hi Pieter
    >
    > i am not good in visual basic. I do not understand your advise, pls
    > explain
    > other way
    >
    > JOHN
    >
    > "Pieter Wijnen" wrote:
    >
    >> I Think we might have a denormalized table issue
    >> He wants to store Both values from the combo (bad practise) or to display
    >> the name on the form (good practise)
    >> either way:
    >>
    >> Sub Cbo_AfterUpdate()
    >> Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    >> End Sub
    >>
    >> Pieter
    >>
    >>
    >> "John" <John@discussions.microsoft.com> wrote in message
    >> news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    >> > Hi Jeff
    >> >
    >> > ItemNo defined as number
    >> > combo box binding ItemNo
    >> >
    >> > Thanks
    >> >
    >> > JOHN
    >> >
    >> > "Jeff Boyce" wrote:
    >> >
    >> >> John
    >> >>
    >> >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    >> >>
    >> >> In your combo box, are you binding the ItemNo or the ItemName?
    >> >>
    >> >> Regards
    >> >>
    >> >> Jeff Boyce
    >> >> Microsoft Office/Access MVP
    >> >>
    >> >>
    >> >> "John" <John@discussions.microsoft.com> wrote in message
    >> >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    >> >> >i use dropdown (combo box) to enter data for example: -
    >> >> > in form
    >> >> > i click : item no (combo box)
    >> >> > auto update : item name
    >> >> > but
    >> >> > in table
    >> >> > item no is updated, but item name is not updated.
    >> >> >
    >> >> > pls help me !
    >> >> >
    >> >> > thanks
    >> >> >
    >> >> > JOHN
    >> >>
    >> >>
    >> >>

    >>
    >>
    >>




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4367 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  11. John

    John
    Expand Collapse
    Guest

    Hi Pieter

    I need your help, pls advise me

    Thanks

    JOHN

    "Pieter Wijnen" wrote:

    > I Think we might have a denormalized table issue
    > He wants to store Both values from the combo (bad practise) or to display
    > the name on the form (good practise)
    > either way:
    >
    > Sub Cbo_AfterUpdate()
    > Me.ItemName.Value = Me.cbo.Column(1) ' zero based
    > End Sub
    >
    > Pieter
    >
    >
    > "John" <John@discussions.microsoft.com> wrote in message
    > news:6E19129A-4AC0-424C-BD0D-22ECB77BB041@microsoft.com...
    > > Hi Jeff
    > >
    > > ItemNo defined as number
    > > combo box binding ItemNo
    > >
    > > Thanks
    > >
    > > JOHN
    > >
    > > "Jeff Boyce" wrote:
    > >
    > >> John
    > >>
    > >> Is ItemNo defined as a Unique value? (It sounds like it isn't).
    > >>
    > >> In your combo box, are you binding the ItemNo or the ItemName?
    > >>
    > >> Regards
    > >>
    > >> Jeff Boyce
    > >> Microsoft Office/Access MVP
    > >>
    > >>
    > >> "John" <John@discussions.microsoft.com> wrote in message
    > >> news:FD7403D8-73FC-4C96-BEF0-9CA34764E08E@microsoft.com...
    > >> >i use dropdown (combo box) to enter data for example: -
    > >> > in form
    > >> > i click : item no (combo box)
    > >> > auto update : item name
    > >> > but
    > >> > in table
    > >> > item no is updated, but item name is not updated.
    > >> >
    > >> > pls help me !
    > >> >
    > >> > thanks
    > >> >
    > >> > JOHN
    > >>
    > >>
    > >>

    >
    >
    >
    > --
    > ----------------------------------------
    > I am using the free version of SPAMfighter for private users.
    > It has removed 4367 spam emails to date.
    > Paying users do not have this message in their emails.
    > Get the free SPAMfighter here: http://www.spamfighter.com/len
    >
    >
    >
     

Share This Page