Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Error 3075 SQL statement in VB
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...- ainemc76
- Thread
- Replies: 6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Running SQL in VBA, Error code 3131
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, _...- ainemc76
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
What is Status in VBA
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...- ainemc76
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
