Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. blackduck603

    How do I use an Access combobox with a lookup table?

    I have an Access 2000 Form that is bound to a table (InventoryItems). One of the fields in my InventoryItems table is ItemSubTypeID. I have a separate "lookup" table (ItemSubTypes) which contains the follwoing fields: ItemSubTypeID - Autonumber ItemSubTypeDesc - Text ItemTypeID - Number -...
  2. blackduck603

    Error: Access: duplicate values in index, primary key or relationships

    More info... I created a new form and copied all of the controls from my Main Form and SubForm onto the new control. I set the RecordSource Property to the appropriate table and this form works fine with no errors. This seems to substantiate my suspiscion that the problem is related to the Sub...
  3. blackduck603

    Error: Access: duplicate values in index, primary key or relationships

    I forgot to mention..... If I click on the NEW RECORD button After I entered data for the ApptDesc (on the main form) then scroll back to this record, I can then enter data with NO ERROR. It seems like it needs the data stored in db before trying to reconcile the subform data...but it is all...
  4. blackduck603

    Error: Access: duplicate values in index, primary key or relationships

    I inherited an Access 2005 project that has a form with a subform. The subform is used because there is a good number of data and it is set up using tabs. I am getting the following error after entering the last field of data for the subform. "The changes you requested to the table were not...

Part and Inventory Search

Back
Top