var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Append Query
What is the syntax for tell a quey to append only the record choosen, ie. wher the curser is???
Any help is greatly appreciated.
Suppose you have a form with textbox named txtUserID, then an append query may look like this:
dim strSQL as String
' design your query
strSQL= "INSERT INTO tblMain (Field1, Field2) SELECT Field1, Field2 FROM tblAnotherTable WHERE UserID=" & me.txtUserID & ";"
' execute your query