SQL insert without user prompt? 1

[NXMold]

I am using some code to add a record to a table, but it pops up with a warning about appending 1 row... I don't want the user to see that and have the option to cancel. Can I surpress this message?

strSQL = "INSERT INTO UserTable ([NetworkName], [WorkstationID], [DisplayName]) VALUES ('" & NetworkUserName & "', '" & Environ("COMPUTERNAME") & "', '*" & NetworkUserName & "*')"

DoCmd.RunSQL strSQL

 

[MajP]

http://msdn.microsoft.com/en-us/library/aa220747(office.11).aspx

 

[JoeAtWork]

strSQL = "INSERT INTO UserTable ([NetworkName], [WorkstationID], [DisplayName]) VALUES ('" & NetworkUserName & "', '" & Environ("COMPUTERNAME") & "', '*" & NetworkUserName & "*')"

DoCmd.SetWarnings False
DoCmd.RunSQL strSQL
DoCmd.SetWarnings True

Joe Schwarz
Custom Software Developer

http://www.plandev.net

 

[Remou]

You can use Execute.

Set db=CurrentDB

db.Execute strSQL, dbFailOnErrror

msgbox "Inserted records: " & db.RecordsAffected

 

[NXMold]

Thanks guys! I'm having a tough time finding syntax references in the help files for update queries, thats my next task.

I want to update the UserTable with a status (login at xx:xx, closed, idle for XX min, etc) from a function. Does anyone have a link to some syntax documentation? This sql stuff is still voodoo to me.

 

[jamaarneen]

Hi NXMold,

Here you got some url's. you only have to google "SQL sayntax" and you will get a lot of good stuff.

http://www.mckoi.com/database/SQLSyntax.html

http://www.firstsql.com/tutor1.htm

http://www.w3schools.com/Sql/default.asp

Ja