+ Reply to Thread
Results 1 to 29 of 29

User Form Search and Update

  1. #1
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    User Form Search and Update

    Not sure if I am linking this correctly but here it goes...http://www.excelforum.com/excel-prog...ification.html

    This is a previous post link that is now solved but I have a new question based on the code in the post. I would like to know how to add a search and update ability to the user form I have created. I am newb with user forms so I apologize in advance for my lack of knowledge.

    And yes I know the way it is set up now it is depositing data in two different locations; this is for a specific purpose.

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

    Re: User Form Search and Update

    Take a look at the DatabaseForm example here

    http://excel-it.com/vba_examples.htm

    The earlier example already has code added using .Find, so you can also see how that works.It just needs applying to a Find button as the suggested example does
    Hope that helps.

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

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    Roy, thanks for the link. trying to implement the ideas into my userform. will repost the completed product when if I get it to work.

  4. #4
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    I have no idea what i did wrong, but when i tried to use the cmbFindAll piece of code i was suprised to see it wipe my entire workbook out. I dont just mean wiped out i mean gone. I can hit Alt+F11 and see the pages within the workbook but I can not access them. When i try and run a macro I get a global fail error message. I removed the code from my user form and saved but found no joy in this correcting the issue.

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

    Re: User Form Search and Update

    Have you got a copy with the code in? I doubt if the code caused this, that's one of my top downloads, must be several thousand.

  6. #6
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    I had to start from a backup copy of my workbook. lucky for me there is only one minor change between the two copies so I didnt lose a lot of work. I will try to re-insert the code and see what happens.

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

    Re: User Form Search and Update

    Add the code exactly as you did before,then attach it. I'll take a look

  8. #8
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    ok so I have the workbook working 100%, but not the piece of code. this is how i modified it but i must be missing something as i get an error when i search.

    Please Login or Register  to view this content.
    the sheet the parts are stored on is "Part_Center" the sheet the user form is on is "Bid_ToC" the first cell any part is listed on in the "Part_Center" sheet is A4 (A4:F4 makes up the current full line information for the first part)

  9. #9
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    any idea on how to make this work?

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

    Re: User Form Search and Update

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!

  11. #11
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    attached a workbook that i have been using to test with.
    Attached Files Attached Files

  12. #12
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    royUK..I have attached the requested example..hopefully you can help with this issue.

  13. #13
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    Still looking for a little help on this please.

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

    Re: User Form Search and Update

    There's no Part Centre worksheet. What have you serched for & what ios the error message?

  15. #15
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    The code I posted is from the actual workbook I am working on, the attachment I posted has the code set for the attached workbook and is my test book. The two are not the same in that respect but the code is relatively the same. But I am getting the same stop point in the posted example and the actual workbook.

    Run-time error ‘1004’-
    Method ‘Range’ of object’_Worksheet’ failed

    Please Login or Register  to view this content.
    I have tried changing ‘Sheet3’ to “Customer_Information” in the attached example posted but the error is the same, so I am not sure what mistake I am making.

  16. #16
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    can someone take a second to look at the attachement and help with a solution. I am trying to get the "search" button to work.
    Attached Files Attached Files

  17. #17
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    been awhile since i had a chance to look at this post. Is there anyone who can take a few moments to help out with this issue. the attached book1 is causing me some issue as i can not seem to get the search function to work.

  18. #18
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    Can I get a forum mod to close this post as unsolved? I need help with getting a search function to work, but postulating does not get me closer to an answer or solution. There for with the lack of guidance I could use I will take my question to another forum, with higher hopes and less frustration.

  19. #19
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    Re: User Form Search and Update

    You have an unqualified range reference, which means it refers to the active sheet. So,
    Please Login or Register  to view this content.
    ... or, better,
    Please Login or Register  to view this content.
    Entia non sunt multiplicanda sine necessitate

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

    Re: User Form Search and Update

    You left it 5 months before bumping!!!!!

    You also haven't responded to your other post,which needed the Title amending. So read the Forum Rules& follow them or don't bother posting here
    Last edited by royUK; 03-18-2010 at 02:40 AM.

  21. #21
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    Roy,

    Not sure what you mean by 5 months as I started this post roughly a month ago. And as for the other post, it is closed by Daveexcel..thanks for the suggestion though of fixing it or not posting here any more.

  22. #22
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    SHG,

    thanks that solved the issue up to that point, then it snagged a couple of lines down.

    Please Login or Register  to view this content.

  23. #23
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    i reconfigured some stuff in my workbook, to try to get the search function to work a little better or at all (i was hoping) but this code continues to fail me. I have seen the code work, but I have had nothing but issue after issue with it.

  24. #24
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    Need help with adding a search function to my user form.

    Attached is my workbook, current coding for the search function is not working properly. Any help is Welcome and Appreciated.
    Attached Files Attached Files

  25. #25
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,669

    Re: User Form Search and Update

    Instead of
    Please Login or Register  to view this content.
    , which works only on the active sheet,
    Please Login or Register  to view this content.
    GoTo takes an optional argument that you should look at in Help.

    EDIT: But before you do that, put Option Explicit at the top of every module.
    Last edited by shg; 03-18-2010 at 06:43 PM.

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

    Re: User Form Search and Update

    Quote Originally Posted by jabryantiii View Post
    Need help with adding a search function to my user form.

    Attached is my workbook, current coding for the search function is not working properly. Any help is Welcome and Appreciated.
    You suggested that you weren't receiving the help you required,I pointed out that you didn't respond immediately. A valid point, you then gave me negative feed back for this.

    That is no way for persuading me to help, I also pointed out your lack of response to another post of yours, which actually had comments by at least two other mods.

    Please feel free to sort your own problems, I won't be helping you further & read the Forum Rules because any future infringement will result in a ban!

  27. #27
    Registered User
    Join Date
    12-28-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    98

    Re: User Form Search and Update

    royUK,

    I am sorry that you feel that way. I have gone back through this thread and noticed that I have responded to every thing in a timely manner for a forum site, (within an hour or two) more over to point out again this thread was started roughly a month ago. Where you came up with 5 months is beyond me because the tag for the start of this thread is 2/17/2010.

    The reason for the negative feedback is due to the wild assumption of 5 months and using this thread to point out a mistake that I made in another thread. As well as pointing out that if I could not fix my error on that thread that I should stop posting here. As I pointed out that thread was closed and does not allow me to make any changes to it. I also emailed Daveexcel and asked him why he didnít move it instead of closing it.

    If for some reason you feel that posturing and threatening me with being banned from this forum is warranted then please do not hesitate from fulfilling your desire. From where I sit, it seems like retaliation to a valid negative feedback.

    For the most part this forum has been a blessing for people looking to broaden their Excel and VBA knowledge but if this is the attitude and response I am not sure why anyone would come here. If I remain un-banned I will return to seek help and offer any help I can with what knowledge I have. If not I will seek help in a different venue.

  28. #28
    Registered User
    Join Date
    02-03-2012
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: User Form Search and Update

    Set rSearch = Sheets("Customer_Information").Range("i4", Range("i65536").End(xlUp))

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

    Re: User Form Search and Update

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

+ 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