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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: fizzlesquirt
- Order by date
-
insert into statement giving 3075 error
Thanks PHV! The addition of the replace(errDesc... made all the difference. The only other code I had to add was to turn off warning messages at the beginning and then turn back on at the end. Public Function errorCapture(frmName As String, errNum As String, errDesc As String)...- fizzlesquirt
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
insert into statement giving 3075 error
I am trying to use a SQL insert statement to automatically add a record to a table to capture errors. The table setup: errRecordID - primary key, no duplicates, autonumber Date - Date/Time FormName - text errorNumber - text errorDescription - memo Notes - memo The code in VBA is as follows...- fizzlesquirt
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
