+ Reply to Thread
Results 1 to 23 of 23

database to userform

  1. 07-14-2011, 04:00 PM #1
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    database to userform

    To preface, I am an extreme excel beginner.

    I created a database to store information in for a survey. I made a userform in VBA and it populates the database no problem. Now, what I want to be able to do is highlight a row in the database and be able to see it back in the userform template. Currently I have to print or take a screenshot of the userform if I want to be able to keep it for future reference (rather than read it from the database), but it would be much easier if it could go back and forth. Does this make sense? Is it possible?

    Thank you for ANY help or suggestions.
    Reply With QuoteRegister To Reply
  2. 07-14-2011, 05:21 PM #2
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: database to userform

    Hi excelkt

    Welcome to the Forum!

    Attached is one way. Double click on any cell in column A. Since you've built UserForms I didn't complete the code example but you'll get the idea.

    Notice the code in Sheet1 Module.

    Let me know of issues.
    Attached Files Attached Files
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  3. 07-15-2011, 10:47 AM #3
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    Hi - thank you! The double-click - see the userform part works. Unfortunately, now when I click "run" to enter data with the userform into the database it says "Could not set the value property.Type mismatch"

    Any thoughts?
    Reply With QuoteRegister To Reply
  4. 07-15-2011, 10:51 AM #4
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: database to userform

    We need to see your code
    Hope that helps.

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

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  5. 08-26-2011, 03:42 PM #5
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    I've attached a copy of the database & userform, if that is easier. This is the intial code, as when I tried to follow your suggestions, I couldn't make it work. Sorry! Thank you so much for your help!!
    Attached Files Attached Files
    Last edited by excelkt; 09-01-2011 at 11:43 AM.
    Reply With QuoteRegister To Reply
  6. 08-27-2011, 02:47 AM #6
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: database to userform

    For a start you have a missing Control - ComboBox1

    I've filled ever entry on the form & can't duplicate the error
    Reply With QuoteRegister To Reply
  7. 08-28-2011, 03:43 PM #7
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    ok ive added the double click to userform code to the sheet and when i double click it pulls up the userform, but the userform is empty. sorry if the problem seems obvious - i am an extreme beginner! i barely understand how ive managed to do what i have already done - mostly just trial and error.
    Last edited by excelkt; 08-28-2011 at 04:24 PM.
    Reply With QuoteRegister To Reply
  8. 08-28-2011, 05:20 PM #8
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: database to userform

    Hi excelkt

    Not sure to whom your question is addressed. If to jaslake then please post your workbook with existing code and with data (sanitized of course).

    That'll help me see what you're trying to do...otherwise I need to reverse engineer your workbook and code to understand what you're trying to do...not willing to do that.
    Reply With QuoteRegister To Reply
  9. 08-29-2011, 03:03 AM #9
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: database to userform

    Add this code to the userform
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 08-29-2011, 08:17 AM #10
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 08-29-2011, 08:19 AM #11
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    I added the above to the userform and this to the sheet:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  12. 08-31-2011, 09:10 AM #12
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform 

    Please Login or Register  to view this content.
    Last edited by excelkt; 08-31-2011 at 02:57 PM.
    Reply With QuoteRegister To Reply
  13. 08-31-2011, 02:13 PM #13
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: database to userform

    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 With QuoteRegister To Reply
  14. 09-01-2011, 11:32 AM #14
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    Hi John,

    Thank you for your help so far! I just realized today that I have to enter the code into the sheet and the userform, before I had entered only the code into the sheet. So here is what I have
    in sheet
    Please Login or Register  to view this content.
    in userform
    Please Login or Register  to view this content.
    When I double click column A it says ambiguous name detected and highlights Private Sub Userform_Initialize from the userform. I have tried naming it Userform and ClinVisitForm. Sorry if this seems obvious - I hadn't even heard of visual basic until a few months ago and this is my first time using it!!

    Thank you so much!

    K
    Reply With QuoteRegister To Reply
  15. 09-01-2011, 11:48 AM #15
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: database to userform

    Hi excelkt

    This message
    ambiguous name detected
    would indicate you have more than one Private Sub UserForm_Initialize events in the UserForm. My guess is you have an empty version from before 
    Please Login or Register  to view this content.
    and the new version you added 
    Please Login or Register  to view this content.
    Eliminate the empty one and try again.
    Reply With QuoteRegister To Reply
  16. 09-01-2011, 12:01 PM #16
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    Sorry - I'm not sure what you want me to do. I have posted my workbook and my code. There is no data in the workbook but the code is there. The userform works - it populates the database but I can't make the database (excel sheet) open to the completed userform. I will post my workbook again in case you had a problem opening it?
    Attached Files Attached Files
    Last edited by excelkt; 09-01-2011 at 04:00 PM. Reason: SOLVED
    Reply With QuoteRegister To Reply
  17. 09-01-2011, 12:09 PM #17
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: database to userform

    Hi excelkt

    Your workbook does NOT include your current code. Can't trouble shoot your workbook without the current code included.
    Reply With QuoteRegister To Reply
  18. 09-01-2011, 12:54 PM #18
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: database to userform

    Hi excelkt

    Here's your file back WITH code. Please tell me what it's not doing that you'd expect it to.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  19. 09-01-2011, 02:43 PM #19
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: database to userform

    Have you not tried the code that I posted to load the TextBoxes?
    Reply With QuoteRegister To Reply
  20. 09-01-2011, 04:00 PM #20
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    Yes, sorry I didn't reply to you properly - I just posted at the bottom and I realize how ambiguous that was! I had some problems with the code you had provided me with but the problem is solved now. Thank you so much for your help!
    Reply With QuoteRegister To Reply
  21. 09-01-2011, 04:02 PM #21
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    Ah I'm so sorry! I know I must have frustrated you I just literally don't know anything about excel but you fixed it! THANK YOU SO MUCH.
    Reply With QuoteRegister To Reply
  22. 09-02-2011, 07:40 AM #22
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: database to userform

    Who fixed it? When you have multiple helpers mention names
    Reply With QuoteRegister To Reply
  23. 09-02-2011, 10:14 AM #23
    excelkt
    excelkt is offline
    Registered User
    Join Date
    07-14-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: database to userform

    Quote Originally Posted by royUK View Post
    Who fixed it? When you have multiple helpers mention names
    jaslake did - thanks!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1