I'm using Allen Brown's code for audit tracking
(http://allenbrowne.com/AppAudit.html). My aud table doesn't populate with
the tracking info at all. I think it might be a problem with the table
set-up. I just can't find the problem. These are the fields in my table:



Table1



ID (primary key) AutoNumber

Defect Number

End-user Text

Date Date/Time

Summary Memo





audTmpTable1



audType Text

audDate Date/Time

audUser Text

ID AutoNumber

Defect Number

End-user Text

Date Date/Time

Summary Memo





audTable1



audType Text

audDate Date/Time

audUser Text

ID AutoNumber

Defect Number

End-user Text

Date Date/Time

Summary Memo

audID (primary key) AutoNumber





I didn't substitute anything in the code with audID, I just used 'ID' in
place of InvoiceID (I'm not sure what audID is for). I commented out the
error handler and checked the code line by line. I'm getting a runtime
error 3131 (Syntax error in FROM clause). It highlights "db.Execute sSQL."
When I comment that out, I also get other errors with db.Execute sSQL
(Syntax error in INSERT INTO statement). I'm not sure how to fix this.
Does anyone have any suggestions?





Thanks,

Brad

Try posting to comp.databases.ms-access or
microsoft.public.access.modulescoding or
microsoft.public.access.modulesdaovba newsgroups.

This ng is not seen by most people.

--

Ken Snell
<MS ACCESS MVP>

"Bradley Burton" <bradbadNOSPAM (AT) comcast (DOT) net> wrote