Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    11

    Unanswered: Insert/Append Data to a Table

    Please Help.

    I'd like a Click procedure to copy data from 3 unbounded Text Boxes (txtNum, txtText, and txtDate) on a form, to the corresponding fields TempQty, TempTxt, and TempDate in Table tblTemp. Table tblTemp was created and is empty. Thanks.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Dim strSQL As String
    strSQL = "Insert Into tblTemp (TempQty, Temptxt, TempDate) Values (" & txtNum & ",'" & txtText & "',#" & txtDate & "#)"
    DoCmd.RunSQL strSQL

  3. #3
    Join Date
    Apr 2003
    Posts
    11
    Thanks, Rockey. I got it working.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •