Results 1 to 3 of 3
  1. #1
    pratim09 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    30

    Insert query inserting 2 same records in the table

    My below sql inser statement is at first inserting one row in the table but after some time it automatically adds one more row in the table

    strSQL = "INSERT INTO RELEASELIST ([Release Name],[Production Date],[Code Delivery Date],[Reg1 Completion Date],[Reg2 Completion Date],[Imp Test Completion Date],[Content Type],[Modified],[Created],[Created By],[Modified By] ) VALUES ('" & txtReleaseName & "','" & dateProd & "','" & codeDelDate & "','" & regression1date & "','" & regression2date & "','" & impcompdate & "','Item','" & currDateTime & "','" & currDateTime & "','" & strUsername & "','" & strUsername & "')"

    DoCmd.RunSQL strSQL

    Need help on this .

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,166
    How do you execute this SQL? Is it in some sort of loop?

  3. #3
    pratim09 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    30
    I am getting the values from a form and I am adding the record by a add button - the click of which has got the below sql.

    Say my form has 2 fields A and B and in my sql i have A B C and D where C and D are time stamp and username which i am getting from different function.When I click on the add button initially A B C and D are getting inserted properly but after few secs in the table i see one more record inserted with values A and B only that too above the record which contains A B C and D. Not able to find out what is the problem.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Inserting multiple records into a table
    By New2Access in forum Programming
    Replies: 1
    Last Post: 07-07-2011, 09:18 PM
  2. Replies: 1
    Last Post: 12-28-2010, 11:24 AM
  3. Insert query into table FROM two table sources
    By svcghost in forum Queries
    Replies: 2
    Last Post: 11-05-2010, 09:10 AM
  4. Replies: 0
    Last Post: 02-24-2010, 12:56 AM
  5. Insert Query output into a table
    By ammu_sridhar in forum Programming
    Replies: 1
    Last Post: 06-12-2009, 01:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums