Prev: Time Change
Next: product key
From: Jenny on 25 Jan 2006 06:01
Err msg: Err Msg: The changes you requested to the table were not successful
because they would create duplicate values in the index, primary key or
relationship.

I have researched this on the web and there seems to be a bug in Access 2003
with this error msg but I am using Access 2002.

I have a main form with a combo box to choose client.

A subform displays all events relating to the chosen client.

For ONE of those clients, I am allowed to edit data in the subform. For the
rest I get the above error msg.

I have checked the indexes, relationships and Pkey's and they are all in
line with the Access rules.

The only thing that seperates the ONE client's events I can edit in the
subform form the others, is that is the first in the list. Otherwise it has
things in common with all the other clients


Please can you help? Is there any known bug here & if so please how do I
fix it?

Thanks a lot

Jenny

From: Jenny on 25 Jan 2006 06:15
SORRY PLEASE IGNORE THIS POST AS IT IS IDENTICAL TO POST BELOW! Would really
appreciate help on below though!
Thanks

"Jenny" wrote:

> Err msg: Err Msg: The changes you requested to the table were not successful
> because they would create duplicate values in the index, primary key or
> relationship.
>
> I have researched this on the web and there seems to be a bug in Access 2003
> with this error msg but I am using Access 2002.
>
> I have a main form with a combo box to choose client.
>
> A subform displays all events relating to the chosen client.
>
> For ONE of those clients, I am allowed to edit data in the subform. For the
> rest I get the above error msg.
>
> I have checked the indexes, relationships and Pkey's and they are all in
> line with the Access rules.
>
> The only thing that seperates the ONE client's events I can edit in the
> subform form the others, is that is the first in the list. Otherwise it has
> things in common with all the other clients
>
>
> Please can you help? Is there any known bug here & if so please how do I
> fix it?
>
> Thanks a lot
>
> Jenny
>
 | 
Pages: 1
Prev: Time Change
Next: product key