Allen Browne, are you home? Stuck in AppAudit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Allen, or any helpful soul

Using the code in a previous link ( http://members.iinet.net.au/~allenbrowne/AppAudit.html ) to track audits to a table (using a subform). I'm getting an error 3450, Syntax error, incomplete query clause. It points to this when I debug

'Remove any cancelled update still in the tmp table. (There's not anything currently in the temp table
Set db = DBEngine(0)(0
sSQL = "DELETE FROM " & sAudTmpTable & ";
I remember thinking that errors often point to some point _after_ the actual cause, but I have looked for any errors and don't see anything obvious. I did have to change my table name references to having 2 sets of quotes, because my table name has a space (bad, I realize) so I have ..."'tablename here'"... where it's referenced. Is that correct? And is there anywhere else, other than the places you specified in your link, where I need to code/declare the table names

Thanksin advance... I'm trying

Cat Winslow
 
Cat Winslow said:
Hi, Allen, or any helpful soul,

Using the code in a previous link (
http://members.iinet.net.au/~allenbrowne/AppAudit.html ) to track
audits to a table (using a subform). I'm getting an error 3450,
Syntax error, incomplete query clause. It points to this when I
debug:

'Remove any cancelled update still in the tmp table.
(There's not anything currently in the temp table) Set db =
DBEngine(0)(0) sSQL = "DELETE FROM " & sAudTmpTable & ";"

I remember thinking that errors often point to some point _after_ the
actual cause, but I have looked for any errors and don't see anything
obvious. I did have to change my table name references to having 2
sets of quotes, because my table name has a space (bad, I realize) so
I have ..."'tablename here'"... where it's referenced. Is that
correct? And is there anywhere else, other than the places you
specified in your link, where I need to code/declare the table names?

Thanksin advance... I'm trying!

Cat Winslow
Click to expand...

I'm not Allen, but try, instead of specifying your table names in this
form:

"'tablename here'"

using this form instead:

"[tablename here]"

Access generally uses the square brackets to ensure that improperly
formed names are understood.
 
Dirk,

I must be asleep! Where did I get the idea to use quotes??? DUH! You guys are the best

Cat
 
Back
Top