+ Reply to Thread
Results 1 to 3 of 3

Search db Capability for a userform with multi-field display

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Portsmouth, VA now, Falmouth, VA 4 yrs, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    617

    Search db Capability for a userform with multi-field display

    Yes, maybe Access would have been better for this, but a friend asked me to string it together in Excel as he understands Excel a little better than Access.
    I have a sheet with maybe 20 columns, aka Fields
    Each Row is a record (As it should be )
    The Rows are all part of a formal table.
    I have created a form with labels and textboxes for each field, which presently can easily add a row to the table and insert all data (Yes, I know, very basic for you gurus!).

    I have always been lousy at working comboboxes into searches, and perhaps I should be using listboxes.
    I want him to be able to start typing in a name in a box and as he types the choices within the db of accumulated contacts is narrowed down by the letters input until there is a suitable handful that he can choose from, select one, and upon selection it would bring up the respective fields from the flat db located on a sheet into the userform for review, editing or deletion.

    Does anyone know of a good example or tutorial that I can download and study? I would really love the workbook shown at the top of this page, but for the life of me I can't figure out how to get it, even though it appears it was intended for download! That example is above and beyond what I need for this occasion, but I really want to learn how to do something with all the capabilities it has (but not necessarily the butterflies...).

    As always, the help I get from you folks is above amazing and I thank-you!

    Edit: With a little more "looking" I see that the page I thought was the solution I wanted, really isn't. It relies on a textbox-to-autofilter, where I rather have a combobox or listbox that displays several columns of information so if a name is in there twice, say, "John Smith", then also other fields, perhaps address, would show to differentiate between records for selection.
    Last edited by brucemc777; 03-17-2016 at 09:18 PM.

  2. #2
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    105

    Re: Search db Capability for a userform with multi-field display

    Here is an example of connected to Excel files to read them as if they were a database table (with fields and record sets).

    DBCONT.xlsm contains the code to connect to testDBCONT.xlsx

    Test this out. Hit F8, go through it. Setup the fieldsArray to work with other Excel files that you have.

    Search ADODB connections to Excel files. YouTube is where I went long ago. WiseOwlTutorials was a big help.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Portsmouth, VA now, Falmouth, VA 4 yrs, Palm Bay, FL for 2 yrs, was Colorado Springs, CO for ten years; Cedark Park, TX; Zeeland, MI; Wilmette, IL; Princeton Junction, NJ; NY, NY
    MS-Off Ver
    365
    Posts
    617

    Re: Search db Capability for a userform with multi-field display

    Thank-you, I look forward to learning a lot!

+ 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. [SOLVED] Userform to search worksheet and display data back to the userform
    By zip247 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2015, 05:46 AM
  2. Multi user collaboration capability excel 2013 or 365
    By skearney1975 in forum Excel General
    Replies: 0
    Last Post: 05-17-2013, 10:40 AM
  3. Display Time on a userform from a field in a web page.
    By tristanxix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2013, 03:53 AM
  4. Display field as currency in UserForm
    By david1987 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2012, 05:51 AM
  5. Userform Multi Criteria search
    By winkypinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2012, 04:41 PM
  6. search capability
    By shane.kelly in forum Excel General
    Replies: 1
    Last Post: 04-05-2012, 11:58 PM
  7. Multi-sheet FIND capability
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-15-2006, 04:15 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