Groups > comp.databases.ms-access > #1265

Re: Using AllenBrowne's AppAudit routine - getting errors with nulls

From	BobAlston <bobalston9@yahoo.com>
Newsgroups	comp.databases.ms-access
Subject	Re: Using AllenBrowne's AppAudit routine - getting errors with nulls
Date	2011-05-05 22:16 -0500
Organization	A noiseless patient Spider
Message-ID	<ipvp6d$q5m$1@dont-email.me> (permalink)
References	(8 earlier) <ipub82$gb8$2@dont-email.me> <ipudhv$d3l$1@dont-email.me> <ipus62$il$1@dont-email.me> <ipuvgl$8eo$1@dont-email.me> <ipv0a5$ir9$1@dont-email.me>

Show all headers | View raw

On 5/5/2011 3:11 PM, BobAlston wrote:
> On 5/5/2011 2:58 PM, Bob Barrows wrote:
>> BobAlston wrote:
>>> On 5/5/2011 9:51 AM, Bob Barrows wrote:
>>>> set tdf=currentdb.tabledefs("tablename")
>>>>>> for each fld in tdf.fields
>>>>>> if fld.required then debug.print fld.name
>>>>>> next
>>> OK the insert into query IS the cause. If I copy it and save into a
>>> query object and run it, it fails with the same error.
>>
>> What if you delete the INSERT INTO part and just test the SELECT part?
>>>
>>> Yet I can insert a null into a text field, a date field and a numeric
>>> field without error, using an insert into.
>>>
>>> I visually checked and ran modified code to ensure no field was marked
>>> as required.
>>>
>>> *******************************
>>>
>>> Narrowed it down to a number of type double that appeared to be null.
>>> This is a hold over variable from the previous system and can be
>>> deleted.
>>>
>>> Amazing.
>>>
>> Yeah - we should have listened to Doug Steele.
>> So your problem is solved?
>>
>>
> It will be solved. I am first trying to reset all the values of the
> problem field to +1. Perhaps it is some garbage value that is causing
> the problem. If that fails, I will remove the field from my app.
>
> Bob
Apparently it was garbage in the numeric type double field as once I 
reset all of them to +1 everything worked.

I have converted data originally from Lotus Notes 4.x.
Bob

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar

Thread

Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-01 18:40 -0500
  Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Douglas J Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> - 2011-05-01 20:01 -0400
  Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 11:11 -0500
    Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-02 12:52 -0400
      Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 12:11 -0500
        Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 12:17 -0500
          Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-02 12:45 -0500
            Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-02 14:53 -0400
            Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 08:09 -0500
              Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-05 10:00 -0400
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 09:12 -0500
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-05 10:51 -0400
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 14:01 -0500
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-05 15:58 -0400
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 15:11 -0500
                Re: Using AllenBrowne's AppAudit routine - getting errors with nulls BobAlston <bobalston9@yahoo.com> - 2011-05-05 22:16 -0500

csiph-web