SQL: Insert Statement

========= QUESTION --------- How do I add a record to a table using SQL?   ========= ANSWER --------- see EXAMPLES   ========= EXAMPLES ---------  SQLTxt = "INSERT INTO 0000T_Log (Dt, Log) VALUES (#" & Now() & "#, '" & Me.CurrentStatus & "')"CurrentDb.Execute SQLTxt   ========= APPLIES TO / KEY WORDS --------- Microsoft Access SQL Insert [...]

By | 2017-12-01T23:47:37+00:00 September 2nd, 2011|Access, Computers, Documentation, Microsoft, SQL, VBA|0 Comments