Groups | Search | Server Info | Keyboard shortcuts | Login | Register
Groups > comp.databases.ms-access > #1253
| From | "Bob Barrows" <reb01501@NOyahooSPAM.com> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: Using AllenBrowne's AppAudit routine - getting errors with nulls |
| Date | 2011-05-05 15:58 -0400 |
| Organization | A noiseless patient Spider |
| Message-ID | <ipuvgl$8eo$1@dont-email.me> (permalink) |
| References | (6 earlier) <ipu7hp$2h0$1@dont-email.me> <ipuai0$8vl$1@dont-email.me> <ipub82$gb8$2@dont-email.me> <ipudhv$d3l$1@dont-email.me> <ipus62$il$1@dont-email.me> |
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?
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar
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