A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

The changes you requested to the table werenot successful ........



 
 
Thread Tools Display Modes
  #1  
Old April 30th, 2010, 01:31 PM posted to microsoft.public.access.forms
aligahk06
external usenet poster
 
Posts: 9
Default The changes you requested to the table werenot successful ........

Dear All,

I wont be able to feed data to my form named (DelNoteBrkForm) which is
created from Delivery_Track Query.
The thing is that if i m saving my records to the form (DelNoteBrkForm)
record could not be saved.
The eroor encountered was
The changes you requested to the table werenot successful because they would
create duplicate values in the index,primary key,or
relationship.Change tha data in the field or field that contain duplicate
data, remove the index or redifine the index to permit
duplicate entries and try again.

Actually i want to open this form with all records from the form
Delivery_Track ( There is a command button )
OPenSubForm.
Suppose i am searching Delivery No 22568 and once i click on command button
opensubform then it will directly redirects us to the
DelNotebrkform and show us the corresponding Delivery No and their fields.

Attachment is for ur reference.

Please assist ?

Rgds,
Aligahk06
  #2  
Old April 30th, 2010, 02:41 PM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default The changes you requested to the table werenot successful ........

On Fri, 30 Apr 2010 05:31:01 -0700, aligahk06
wrote:

There are no attachments in a text-only forum.

You can't "save records to the form"; rather you save data to the
table(s) that the form is bound to.

The error message indicates that you're trying to save a record that
is similar to one that already exists. For example if I have a unique
index on OrderID + ProductID in my OrderDetails table, and I try
saving a second line item for this order with the same Product, this
error will occur. Review your database design and the reason for the
error should become apparent.

-Tom.
Microsoft Access MVP



Dear All,

I wont be able to feed data to my form named (DelNoteBrkForm) which is
created from Delivery_Track Query.
The thing is that if i m saving my records to the form (DelNoteBrkForm)
record could not be saved.
The eroor encountered was
The changes you requested to the table werenot successful because they would
create duplicate values in the index,primary key,or
relationship.Change tha data in the field or field that contain duplicate
data, remove the index or redifine the index to permit
duplicate entries and try again.

Actually i want to open this form with all records from the form
Delivery_Track ( There is a command button )
OPenSubForm.
Suppose i am searching Delivery No 22568 and once i click on command button
opensubform then it will directly redirects us to the
DelNotebrkform and show us the corresponding Delivery No and their fields.

Attachment is for ur reference.

Please assist ?

Rgds,
Aligahk06

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.