Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

subform problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JennBard1 - 11 Oct 2005 19:00 GMT
i made a subform but i am unable to enter in more than one line. An error
message comes up whenever i try to save
"The changes you requested to the table were not successful because they
would create duplicate values in the index, primary key or relationship.
Change the data in the field or fields that contain duplicate data, remove
the index, or redefine the index to permit duplicate entries and try agin".
i have edited to indexes but i don't know what else to do it still doesn't
want to work for me. Any suggestions?
Jeff - 12 Oct 2005 06:40 GMT
> i made a subform but i am unable to enter in more than one line. An error
> message comes up whenever i try to save
[quoted text clipped - 4 lines]
> i have edited to indexes but i don't know what else to do it still doesn't
> want to work for me. Any suggestions?

Open the table in design view and click on the field that causes the
problem.
Below, in the properties section, in 'indexed' choose, yes, allow
duplicates.

Although indexed fields are usually duplicate protected because they
provide a unique reference for each register of data.

Hope it helps.
Larry Linson - 15 Oct 2005 22:23 GMT
> i made a subform but i am unable to enter
> in more than one line. An error
[quoted text clipped - 9 lines]
> what else to do it still doesn't
> want to work for me. Any suggestions?

I don't understand what you mean by "I have edited to indexes".

Perhaps you have not included the Table's unique key in the Form embedded in
the Subform Control. As the message clearly indicates, whatever you are
doing is trying to save a record with a Key that is identical to the Key of
a Record already in the Table. From that perspective, examine the Table, the
Form embedded in the Subform Control, and the main Form.

Jeff's suggestion might allow you to save, but there is a very high
probability that an Index defined as unique (or a Primary Key) was created
in that manner _for a purpose_ and that purpose would be defeated if you
change the definition of the Table.

And, with no more information than you provided, some hints and tips on how
to go about debugging the problem are going to be all that is possible.

 Larry Linson
 Microsoft Access MVP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.