+ Reply to Thread
Results 1 to 6 of 6

Select items picker screen

  1. #1
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, 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
    615

    Select items picker screen

    By the really, really, lousy title it won't come as a surprise to you that i don't really know how to describe this thing (perhaps another mug of coffee will help), but the following is what i want to do with a filtered list for a purpose on the left and my selections on the right. (I am presuming that i properly uploaded my little screenshot, but if i didn't, it is the same tool one uses to select items to add or remove from most toolbars/ribbons in Windows).

    I imagine that we have an inventory or catalog of items, let's say fruits. I first want to filter that list to be appropriate for the person looking for them, say "Green Fruits". OK, i've done that and have a listing of all green fruits ready to drop into a control on the left side. Now the issue - is there already a canned solution to create identical interaction between left and right haves of this item picker (and while i am at it, what the heck is it properly called)? When a lime is chosen (for instance) and the "Add" control in the middle is clicked, i wish it to appear then in the right hand pane and when satisfied i would insert/append to another table built specifically for those items.

    Given enough poking around and coming back here for instructions i would likely get there, but as my father used to say "There's no point in trying to reinvent the wheel". That isn't meant to sound lazy, just there have been times i spent days trying to do something only to find out from a suggestion that it could be done in seconds-

    Thank you VERY much for your consideration!!!
    -Bruce
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,009

    Re: Select items picker screen

    Bruce - you have marked this as solved. Please share the solution for everyone's benefit. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, 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
    615

    Re: Select items picker screen

    I sure will (Once i actually do figure it out...).

    I dove into working on it. So i wouldn't waste other people's time i marked it solved.

    I'm doing a miserable job, but will get there. So far i am fine with the "INSERT INTO" portion, but i was so tired at the time that i didn't see why though the table updated with the new info, the form did not! I am sure it is a simple thing, but today in the mid 90° heat i get to help a daughter move everything out of a packed garage so she can move into it (though not luxury, it does have a heat pump so she's at least got heat and a/c so you needn't call the authorities on me!).

    Anyway, i hope to resume work tomorrow and when i finally do figure this out, i will post (CAUTION: Though many years with Excel, i AM an Access newbie, which only means that i am worse than a newbie with SQL).

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    91,009

    Re: Select items picker screen

    If you still want someone to help you, remove the SOLVED tag.

  5. #5
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, 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
    615

    Re: Select items picker screen

    I sure will! I am making progress (rather slowly with the family interruptions) and am pretty well guaranteed to need help, but as long as i have not hit an absolute road block i do not want to impose on all you good folks that have helped me out countless times before over on the Excel side of things!

  6. #6
    Forum Contributor
    Join Date
    03-05-2007
    Location
    Falmouth, VA now, 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
    615

    Re: Select items picker screen

    As afore mentioned, i wanted to refrain from having anyone hammer out the solution to this as i chose to take it on, but to keep me from going insane, i need some help!

    I can't wrap my head around handling the quotation marks when running an SQL statement with variables, especially string variables, in VBA. I started even trying multiple "Let's delete this quotation mark, let's add one over here,..." and quickly realized that won't do me any good because even if i hit on the right combination, i will have learned nothing.

    Here is the most recent wrong iteration-

    Please Login or Register  to view this content.
    ALL THE BACKGROUND STUFF YOU PROBABLY DON'T WANT TO KNOW:

    IEmployee is a long integer
    strAgreement is a mixed character string

    tblPersonnel fields: IDPG (the key), IDCXEmployee (an integer foreign key that corresponds to a specific person in another table), IDAgreement (an internal document identifier).

    A formal written agreement is identified by strAgreement in the user interface, as is IEmployee.

    IEmployee is a selected individual that was previously (pretend a moment ago) selected to be on the agreement IDAgreement, where the agreement is identified by strAgreement, that now i changed my mind, was told not to, whatever reason, and i wish to delete that person from the table list of people who might be on that Agreement.

    The reason for using both the lEmployee AND strAgreement is that the table tblPersonnel will hold multiple agreements and people, some people could be on differing agreements.

    I think i am close, but still, i have no set thought process of why and where (or should that be where or why?), i just was emulating examples i saw.

    Please help, i have four daughters who don't want Daddy locked away for climbing a tree and eating bugs and branches...

    THANK YOU!!!

    EDIT: Thank goodness i am also researching for a neurologist in the area. I think i understand the " syntax structure now - the issue is a datatype incompatibility whose origins i located, now i need to resolve-

    EDIT 240709: The datatype error was from my putting lEmployee, a long integer, in double double quotes (which i have learned are for string, single double quotes are for numbers). This is definitely "learn as i go"!
    Last edited by brucemc777; 07-09-2024 at 09:48 AM.

+ 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. Loop through AutoFilter Items and Select/Deselect Desired Items
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-02-2023, 12:51 PM
  2. Replies: 3
    Last Post: 07-25-2016, 05:40 PM
  3. [SOLVED] file-picker thinks it is a folder-picker if the folder picker runs first?
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-01-2016, 01:14 PM
  4. Newbie: Auto Select/un-Select an Range of Slicer Items
    By luckyali in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-23-2014, 09:52 AM
  5. Select Multiple Items in a List and then Print Those Items
    By dcdoc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-26-2013, 01:16 PM
  6. frustrated with VBA select/activate and screen flips
    By William DeLeo in forum Excel General
    Replies: 8
    Last Post: 06-13-2006, 04:20 PM
  7. Select a Cell - Move Row to the Top of the screen
    By CRayF in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2005, 06:05 AM

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