Ah, shucks. Thanks Liz.
Bill
--- In MS_Access_Professionals@yahoogroups.com, Liz Ravenwood <liz_ravenwood@...> wrote:
>
> AHA!
>
> You know, I believe I have encountered that one before myself. I had forgotten all about that.
>
> Bill, you da man!
>
> 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 12:37 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: Re: [MS_AccessPros] Re: Append record not working
>
> Bill,
>
> You were correct. There was field that is marked as required in the household table that I was not taking into consideration in the query. Thanks so much.
>
>
>
> With warm regards,
>
> Arthur Lorenzini| SQL Server/Access Developer l alorenzin@...
> 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: Bill Mosca <wrmosca@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Tuesday, September 13, 2011 2:17 PM
> Subject: [MS_AccessPros] Re: Append record not working
>
>
> Art
>
> Validation can be things like Required, Allow Zero length = No. Check each field in the target table for things like that.
>
> Bill
>
> --- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@> wrote:
> >
> > That's what I am working on. The warning is telling me 1 record was not appended due to validation violation but my issue is neither of the tables have any validation code in them. Is there anyway to see what the query is actually thowing?
> >
> >
> >
> >
> > With warm regards,
> >
> > Arthur Lorenzini| SQL Server/Access Developer l alorenzin@
> > 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: Bill Mosca <wrmosca@>
> > To: MS_Access_Professionals@yahoogroups.com
> > Sent: Tuesday, September 13, 2011 2:08 PM
> > Subject: [MS_AccessPros] Re: Append record not working
> >
> > Â
> > Art
> >
> > Open the form and make sure there is an ApplicationID and the rest of the fields.
> >
> > Then open a new query and paste the SQL statement in the SQL view. Run the query. Be sure the database options for warnings are turned on.
> >
> > When you run the query you should get warnings about a new record is about to be appended and then one telling you thta 1 record was appended. Either that or it will say the record could not be appended due to violations.
> >
> > That should give you some idea of why it is failing.
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@> wrote:
> > >
> > > 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
> > >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
> [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.
>
Tidak ada komentar:
Posting Komentar