khill Posted October 26, 2005 Share Posted October 26, 2005 Greetings,Both of the following two commands work!DoCmd.RunSQL "UPDATE [individual Life Events Table] SET Changed = currentuser() WHERE [individualID#] = " & Me.Individual & " "DoCmd.RunSQL "UPDATE [individual Life Events Table] SET Changed = str(Date()) WHERE [individualID#] = " & Me.Individual & " "Why does the following command not work? DoCmd.RunSQL "UPDATE [individual Life Events Table] SET Changed = currentuser()+" "+str(Date()) WHERE [individualID#] = " & Me.Individual & " "Thanks for taking the time to help.Ken Hill Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now