Groups | Search | Server Info | Login | Register

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

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

Show all headers | View raw

On 5/1/2011 6:40 PM, BobAlston wrote:
> 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
Yes I confirmed it is that error, error 3162 and it occurs at that
point.  I put a stop statement immediately before that statement and one
immediately after and ran it again, to confirm that is where the error
is generated.

Bob

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