+ Reply to Thread
Results 1 to 4 of 4

whenever i submit data it is storing in 2nd row in table instead of storing first row

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    whenever i submit data it is storing in 2nd row in table instead of storing first row

    database table

    Employee_Name System_Name Login_Date Login_Time Logout_Time Team_Lead_By Project_Name Allocated_Work Work_Completed User_Comments


    after userlogin it is stored in first but when userlogout it is storing in second row

    please help me out


    Please Login or Register  to view this content.
    Last edited by baig123; 09-09-2014 at 06:54 AM. Reason: paragraph

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: whenever i submit data it is storing in 2nd row in table instead of storing first row

    Dont understand the post.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: whenever i submit data it is storing in 2nd row in table instead of storing first row

    example:

    if user login it stores in first row of the database after some hours the when userlog out it storing in
    some other row

    like this Why?

    Employee_Name System_Name Login_Date Login_Time Logout_Time

    raj gh0201b 19/02/1991 9:30AM

    6:00PM

  4. #4
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: whenever i submit data it is storing in 2nd row in table instead of storing first row

    Without access to the SQL Server DB, cant really see what is happening....

    also, i wouldnt post userids and passwords on this.

    You are using an insert into rather than update

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Storing decimal value in Access table
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2010, 11:01 AM
  2. Help with storing data
    By J in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2006, 01:10 PM
  3. storing data
    By JK57 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2006, 07:20 PM
  4. storing data
    By jimbo_jones in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2005, 12:05 PM
  5. Storing data
    By Bob Mckenzie in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-30-2005, 03:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1