Search results

I tried that. Same problem. Would the structure of the table matter? Autonumber | DateTime | UserName | Formname (Which I skipped) | Action | more fields

The error I'm getting now is regarding: DoCmd.RunSQL SQL Run-time error '3134': Syntax error in INSERT INTO statement.

[ Option Compare Database Public LogEvent As String Private Declare PtrSafe Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim sName Dim lngLen As Long...

Re: http://www.access-programmers.co.uk/forums/showthread.php?t=266335 vbaInet, His code gets me the same error. I removed the # because it showed in the results. I don't want that. Where is the missing single quote?

Why do I get ads?

Here's my full code. Option Compare Database Public LogEvent As String Private Declare PtrSafe Function apiGetUserName Lib "advapi32.dll" Alias _ "GetUserNameA" (ByVal lpBuffer As String, nSize As Long) As Long Function fOSUserName() As String ' Returns the network login name Dim sName...

http://www.access-programmers.co.uk/forums/showthread.php?t=266335 My desktop won't let me reply, so I'm having to do this ????? I'll reply with my phone. Public Function LogEvt() Dim SQL As String SQL = "INSERT INTO AuditTrail ( DateTime, UserName, FormName ) SELECT #" & Now() & "...

Thank you for that one. That line looks ok. Now, I'm doing debug.print on DoCmd.RunSQL; SQL. .RunSQL is highlighted in blue

Run-time error '3134': Syntax error in INSERT INTO statement

DoCmd.RunSQL SQL is highlighted in yellow. Runtime 3134.

Didn't work.

I'm trying to get a record written to a table showing when a table opens. I want to see Date/Time, UserName, "***Report has been opened." I'm having issue here: Public Function LogEvt() Dim SQL As String SQL = "INSERT INTO AuditTrail ( DateTime, UserName, FormName ) SELECT #" & Now() &...

Really lost on this one. Got my forms and reports working. Suggestions on getting a string written to a table when another table is opened/closed?

Since my browsers, at work, won't reply. I fixed the problem. Rather than using Screen.ActiveForm.Name, I omitted the fourth column for the name and changed the logon string from "Logon Open" to "Subject Candidate Form Opened". Simpler and it works. Now to figure out how to do this with a...

I used my phone. I'll check when I get back to work tomorrow. Thank you

Let's try my phone

I cleared the history and no luck. I'm using SRWareIron and I've tried Firefox, too. No luck.

I get a "This webpage is not available" message. I've tried various reply options.

Why can't I reply to posts on my thread?

I want to write my form name to a field called ItemName on a table when aform is opened/closed. Can't quite figure out me.name. Help? SQL = "INSERT INTO EventLog ( Event, EvTime, UserName, ItemName ) SELECT '" & LogEvent & "' AS x1, #" & Now() & "# as x2, fOSUserName(), me.name;" Why can't...