Results 1 to 4 of 4

Thread: copy record

  1. #1
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178

    Question Unanswered: copy record

    is there a quick way that I can copy the record from one table into another where the table structures are the same?

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Insert into tableB select * from tableA
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    thanks
    I tried:
    DoCmd.RunSQL ("insert into tbl_OrderLineHistory (*) values (Select * from tbl_OrderLine where [PONumber] = '" & Me.Combo1.Value & "' And [OrderDate] = #" & Me.Combo3.Value & "#);")

    but I keep getting a syntax error.

  4. #4
    Join Date
    Jan 2004
    Location
    South Africa
    Posts
    178
    sorry
    never mind
    figured it out

Posting Permissions

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