[AccessD] (no subject)

Just checked - none of those fields on the form or sub-forms.

Rocky
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
Sent: Monday, December 14, 2009 5:32 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] (no subject)

...do you by chance have one of those fields bound on an open form?

William

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Monday, December 14, 2009 2:46 PM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: [AccessD] (no subject)

> Dear List:
>
>
>
> I am getting an error 3022 - "changes you requested were not 
> successful because they would product duplicate values..." etc. when 
> the following code gets to the .Update line.
>
> Dim rstCOCITemp As DAO.Recordset
>
> 'add to check-out/check-in table the number of times it's in quantity
>
> Set rstCOCITemp = db.OpenRecordset("Select * FROM tblCheckOutCheckIn") 
> With rstCOCITemp
>
>    .AddNew
>    !fldCOCIRADID = argRADID
>    !fldCOCIInventoryID = argPackageID
>    !fldCOCIInventoryItemID = Null
>    !fldCOCICheckOut = Null
>    !fldCOCICheckIn = Null
>    .Update
>
>
> fldCOCIRADID, fldCOCIInventoryID, fldCOCIInventoryItemID, are all 
> indexed, duplicates OK, default value zero.  db is set to Currentdb.
>
> Any ideas why this chunk of code should generate an error 3022?
>
> MTIA
>
>
>
> Rocky Smolin
>
> Beach Access Software
>
> 858-259-4334
>
> www.e-z-mrp.com <http://www.e-z-mrp.com/>
>
> www.bchacc.com <http://www.bchacc.com/>
>
>
>
>
>
>



> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com