In a previous lesson I learned about creating a log:

Private Sub LogIt(Description As String, Notes As String)

    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO LogT (Description, Notes) " & _
        "Select '" & Description & "', '" & Notes & "'"
    DoCmd.SetWarnings True

End Sub

and it worked like a charm... until I uploaded it to a server where the default values of the date/time didn't transfer with the tables... therefore, I can't seem to time stamp the event in the log.  

is there a code like an update query in sql to place just before the sequence of the log?  or is there a better way?

Rick

---

Reply from Richard Rost:

You should be able to set up a default value on the server field, but you'll have to do that in your server's table config. It's different for each server, unfortunately.

The alternative is to just send the date/time value with the other two fields and make your function handle it.