Search results for query: *

Hi SkipVought This still does not solve problem. I am a complete novice at this, this is the first time I've written/adapted VB. I am unsure what you mean by 'Can you run the assembled sSQL?'. Sorry! Thanx a mil :~/ %-)

Hi Still trying to debug the following code and getting error messages. Complies ok when I try to run it pops up error message. Can anyone help? Function AuditEditBegin(sTable As String, sAudTmpTable As String, sKeyField As String, _ lngKeyValue As Long, bWasNewRecord As Boolean) As...

Doh! thanks, 1 bug fixed millions to go!:-(

Hi I am trying to debug the following code and I get a Error code "run time error 3131 syntax error in 'FROM' clause" it looks perfect to me any suggestions. The code breaks on db.execute sSQL. Function AuditEditBegin(sTable As String, sAudTmpTable As String, sKeyField As String, _...

Hi Everyone, Thanks for replying. If it helps to see all the code in its entirety, you can view the code on this link http://www.allenbrowne.com/AppAuditCode.html and the 'step by step' function is on this link http://www.allenbrowne.com/AppAudit.html. I am adapting the code through access...

Hi Can anyone help, I am new at being a DBA and I am trying to adapt code for an audit trail in one on my DB's. I am getting a byRef type mismatch error on one of the lines. I know I need to declare what status is but I don't know what status is!! Here is copy of code: Option Compare...