+ Reply to Thread
Results 1 to 7 of 7

Select the record for display

  1. #1
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Select the record for display

    Hello masters,

    I have a report in listbox shows a list of entries made.
    I need that one to be edited and save back.
    I created pretty report in listbox. And
    when I click it I need it to display in a Textbox so that I can edit
    and save back.

    This is the code i use to load in textbox.
    Please help me.
    Please Login or Register  to view this content.
    Please help me.
    Regards, Charles P
    Attached Files Attached Files
    Last edited by ebin charles; 06-19-2011 at 06:29 AM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Select the record for display - Please help me

    The VBA project is protected!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Select the record for display - Please help me

    You are using FindNext without Find

  4. #4
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Select the record for display - Please help me

    Quote Originally Posted by royUK View Post
    The VBA project is protected!
    Sorry,

    I am very sorry.

    I attached now.

    regards
    charles
    Attached Files Attached Files

  5. #5
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Select the record for display - Please help me

    Quote Originally Posted by royUK View Post
    You are using FindNext without Find
    Please now attached the correct file.

    it's not works for "Find" also.

    regards
    charles

  6. #6
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Select the record for display - Please help me

    This is the corrected code
    Please Login or Register  to view this content.
    This will also edit the entries

    Please Login or Register  to view this content.
    I've also amended the FillResults Procedure

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor ebin charles's Avatar
    Join Date
    03-31-2010
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    255

    Re: Select the record for display -

    Thank you very much.

    When I run the code to edit and save, it save in different row.
    I need the entry which I choose to edit and should save on same entry(row).

    I manipulated but I could't get that.

    any idea to save it on same row?

    charles
    Last edited by Leith Ross; 06-19-2011 at 01:39 PM. Reason: Removed Quoted Text

+ 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