Recs not being written 1

[Trudye]

Ok, ok I know this sounds crazy, BUT my pgm is writing recs to a table and the recs are not showing up.

I step thru the pgm as I am executing the code as it is writing the rec. I dbl ck the dealid, the client name, the company name as the data is being moved (field by field) to the output area. I step thru the Update command right thru the Return command for that paragraph (write_Deal . I stop stepping and ck the table, no rec shows. All of the recs up to that point have been written. I know because I am doing a count just before the Update command, 26 recs have been counted and 26 recs have been written.

So you can imagine I open the table on what s/b the 27 rec and it is not there I'm a little confused. It also is not writing the 27th rec. The final count is 42 recs counted and only 36 written.

I copied the original output table and renamed it, just to insure I was writing to the right table. Nothing changed. There are 2 other client recs that get written on 2 diff tbls, those recs are there and correct.

What the heck is going on. I know Access is HINKY but this is ridiculous

Thanks much,
Trudye

 

[PHV]

Seems that 6 records violated some integrity or validation rules ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Trudye]

It was a "Allow zero length" that did me in.

Thanks so much PHV, now I can cancel my Psyche appointment at least for now.

Be well,
Trudye

 

[Trudye]

I have a question. Why didn't I get a msg? I thought I remembered getting a msg the last time I encountered this problem.

Trudye

 

[PHV]

You get a msg if your code use DoCmd.RunSQL and there is no DoCmd.SetWarnings False.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886