Welcome to SPN

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

Sign Up Now!

Missing Records in Table - Combo Box Problem?

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

  1. Louise54

    Louise54
    Expand Collapse
    Guest

    Have had same database running fine for 6+ years. With a few new users added
    in past few months, suddenly encountering some problems with 1 particular
    table. The table is a "source code" table containing 3 fields (unique id
    auto-number, code (text field), description, and active (yes/no field). I
    have a query based on this table that returns all active source codes. On 3
    forms, there are combo boxes which have limit-to-list set to yes, where the
    user selects the correct source code from the list. For some reason, lately
    one or two of the "code" field is changing in my table. It's almost as though
    someone is "overwriting" the field through the combo box. Is that possible?
    Today I've also noticed that a few of the records in the table are actually
    missing. Any idea on how this can be happening?
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Missing records delay CBI probe into riots of 1984 (Khaleej Times) Breaking News Mar 18, 2006
    Pacific Oil slicks spotted in search for missing Malaysia Airlines plane (Live updates) Breaking News Mar 8, 2014
    Heritage The curious case of Maharaja's 'missing' painting History of Sikhism Oct 29, 2013
    India Half of the missing children in 2013 remain untraced in India Breaking News Sep 3, 2013
    Note to admin: Missing post Literature Jul 7, 2013

  3. UpRider

    UpRider
    Expand Collapse
    Guest

    Are the combo boxes bound to the table data fields? They should not be if
    you don't want the combo boxes to update the source code table.

    UpRider

    "Louise54" <Louise54@discussions.microsoft.com> wrote in message
    news:2F4749C7-C6DB-4665-87E5-E613C97C8844@microsoft.com...
    > Have had same database running fine for 6+ years. With a few new users
    > added
    > in past few months, suddenly encountering some problems with 1 particular
    > table. The table is a "source code" table containing 3 fields (unique id
    > auto-number, code (text field), description, and active (yes/no field). I
    > have a query based on this table that returns all active source codes. On
    > 3
    > forms, there are combo boxes which have limit-to-list set to yes, where
    > the
    > user selects the correct source code from the list. For some reason,
    > lately
    > one or two of the "code" field is changing in my table. It's almost as
    > though
    > someone is "overwriting" the field through the combo box. Is that
    > possible?
    > Today I've also noticed that a few of the records in the table are
    > actually
    > missing. Any idea on how this can be happening?
     
  4. Louise54

    Louise54
    Expand Collapse
    Guest

    I think I've found my problem. In 4 of the 5 forms that use this data, the
    form had combo boxes, based on a query of the table. The 5th form actually
    had this field as a text box, bound to the table. I think the field was added
    as an afterthought for what was intended to be a reference only, but
    apparently someone was making edits to this field which subsequently changed
    the data in the table. I have set the field property to "Locked". Hopefully
    this will eliminate the problem until I can come up with a better way to do
    that. Thanks so much for your help!

    "UpRider" wrote:

    > Are the combo boxes bound to the table data fields? They should not be if
    > you don't want the combo boxes to update the source code table.
    >
    > UpRider
    >
    > "Louise54" <Louise54@discussions.microsoft.com> wrote in message
    > news:2F4749C7-C6DB-4665-87E5-E613C97C8844@microsoft.com...
    > > Have had same database running fine for 6+ years. With a few new users
    > > added
    > > in past few months, suddenly encountering some problems with 1 particular
    > > table. The table is a "source code" table containing 3 fields (unique id
    > > auto-number, code (text field), description, and active (yes/no field). I
    > > have a query based on this table that returns all active source codes. On
    > > 3
    > > forms, there are combo boxes which have limit-to-list set to yes, where
    > > the
    > > user selects the correct source code from the list. For some reason,
    > > lately
    > > one or two of the "code" field is changing in my table. It's almost as
    > > though
    > > someone is "overwriting" the field through the combo box. Is that
    > > possible?
    > > Today I've also noticed that a few of the records in the table are
    > > actually
    > > missing. Any idea on how this can be happening?

    >
    >
    >
     

Share This Page