Using AllenBrowne's AppAudit routine - getting errors with nulls

From	BobAlston <bobalston9@yahoo.com>
Newsgroups	comp.databases.ms-access
Subject	Using AllenBrowne's AppAudit routine - getting errors with nulls
Date	2011-05-01 18:40 -0500
Organization	A noiseless patient Spider
Message-ID	<ipkr15$rth$1@dont-email.me> (permalink)

Show all headers | View raw

Anyone else use Allen Browne's appAudit routine to log changes to Access 
tables?

allenbrowne.com/appaudit.html

I set it up for one table.  When writing the before image of the table 
record, I get the error

"you tried to assign the null value to a variable that is not a variant 
data type"

It occurs in

db.Execute sSQL

and sSQL is

INSERT INTO aud_client_Data_Additional SELECT TOP 1 
audtmp_client_Data_Additional.* from audtemp.client_data_additional
where (audtemp_client_Data_Additional.audtype = 'EditFrom')
ORDER BY audtemp_Client_Data_Additional.audDate DESC;

It is writing the before image of the record, previously saved in the 
audtemp.... table into the aud.... table.

Clearly my table DOES have various null values in it.

It seems to me that my best approach to resolve would be to use DAO or 
ADO and update the data fields using a loop of all controls and check 
for null values before attempting to set a value.

Anyone have other suggestions?

Bob

Back to comp.databases.ms-access | Previous | Next — Next 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