Selasa, 13 September 2011

RE: [MS_AccessPros] Append record not working

 

So there must be some type of a validation rule on one of the fields?

I got a weird one today. I tried to export a query to an xlsx file, and I got the key violation error. The xlsx file would have been created too, from scratch so that got me. How I got around it is I ran the query interactively and then did a copy and paste to an xlsx file by hand. Weird...

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com


-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art Lorenzini
Sent: Tuesday, September 13, 2011 10:38 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Append record not working

It pops the Appending 1 record to table message and then pop another error message box:

CRHA Applicant Trakker set 0 field(s) to Null due to type conversion error, and it didn't add 0 recrds to the table due to key violations, 0 records die to lock violations and 1 records due to validation rule validations.





With warm regards,

Arthur Lorenzini| SQL Server/Access Developer l alorenzin@live.com
Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947

1316 E. 7th Street
Sioux Falls, SD 57103
SQL Server Development
Database Adminstration Services
Microsoft Access Development
Grant Writing TA Services
IT Assessment Services
Software Application Training







From: Liz Ravenwood <liz_ravenwood@beaerospace.com>
To: "'MS_Access_Professionals@yahoogroups.com'" <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, September 13, 2011 12:28 PM
Subject: RE: [MS_AccessPros] Append record not working


Art,

That error took me a long time to get to understand. Is it erroring for sure on the key violation or another violation?

Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Tuesday, September 13, 2011 9:49 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Append record not working

I have the following append query that keep reporting a violation error:

INSERT INTO tblApplicationHousehold ( FirstName, MiddleName, LastName, MaidenName, ApplicationID )
SELECT tblApplicant.FirstName, tblApplicant.MiddleName, tblApplicant.LastName, tblApplicant.MaidenName, tblApplication.ApplicationID
FROM tblApplicant INNER JOIN tblApplication ON tblApplicant.ApplicantID = tblApplication.ApplicantID
WHERE (((tblApplication.ApplicationID)=[Forms]![Application Details]![ApplicationID]));

It's not inserting the record into the tblApplicatioHousehold record. I first I though it was a PK issue but the PK for the table is HouseholdID so I am a bit confused.

Thanks,
Art
Sioux Falls, SD

------------------------------------

Yahoo! Groups Links

This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.




[Non-text portions of this message have been removed]



------------------------------------

Yahoo! Groups Links




This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

__._,_.___
Recent Activity:
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


A bad score is 598. A bad idea is not checking yours, at freecreditscore.com.
.

__,_._,___

Tidak ada komentar:

Posting Komentar