+ Reply to Thread
Results 1 to 4 of 4

Update command not working properly.

  1. #1
    Registered User
    Join Date
    07-03-2011
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Update command not working properly.

    Hi All,

    Update command is not working properly - updates first row not the current row. When removed the Offset it updated heading row.

    Find next/previous not working at all. Not sure which option is easier - have 3 commands: search, find next, find previous or one command - search, and when clicked on it moves to the next entry on the list.

    Can anyone help please?
    Last edited by KasiaFavourite; 07-08-2011 at 06:25 AM. Reason: More concise

  2. #2
    Registered User
    Join Date
    07-03-2011
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Update command not working properly.

    Ok. I've been working on the Update Command, and it now updates the found entry - but saves it in last row, rather than the row where the entry was found... Attached updated version. Can anyone please help?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-03-2011
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Unhappy Re: Update command not working properly.

    Hope this will help:
    This code is not working like it should
    Please Login or Register  to view this content.
    This one I've tried with ActiveCell in the code but it was updating 1st row in the database. Now it's updating last one...

  4. #4
    Registered User
    Join Date
    07-03-2011
    Location
    Glasgow, Scotland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Update command not working properly.

    Bump, no reply.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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