Results 1 to 2 of 2

FYI: User pick list example

  1. #1
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    7,754

    FYI: User pick list example

    Here is my example of a user pick list. The user can pick items from a list (dbl-click) the items are added to a Picked list table. This table can be joined to the main table to pull ONLY the items chosen. (rather than have a query with many OR clauses)


    It also has filters by Letter or State to help speed up picks.

    Click image for larger version. 

Name:	pick3NY-lbls.jpg 
Views:	114 
Size:	162.6 KB 
ID:	20795
    Below are the queries show for each list,button, or action.
    qsNames1Ltr:
    select [name], [state] from tClients where [name] like forms!frmPick!lstAlf & "*"


    qsAvail:
    select [name], [state] from tClients


    qs1State:
    select [name], [state] from tClients where [state] = forms!frmPick!lstState


    qsPicked:
    select * from tPicked


    qaAddPickedPerson:
    INSERT INTO tPicked ( Name, State )
    SELECT [Name] ,[State] FROM tClients
    WHERE ((ClientID)=[Forms]![frmPick]![lstAvail)


    qdEmptyPikTbl:
    DELETE * FROM tPicked


    qdDel1Person:
    DELETE * FROM tPicked where [name] = forms!frmPick!lstPicked

  2. #2
    johannesh is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Sep 2016
    Posts
    1
    Hello Sir!
    Thank you for providing this hopefully useful information for me. I hope you can help me with my personal query. I want to create this piece:Click image for larger version. 

Name:	Database Email Form Sketch v1.png 
Views:	76 
Size:	14.5 KB 
ID:	25657

    I wondered if you could help me out by doing that and explaining what steps I have to take first.
    Please don't hesitate to answer me!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. IFF record not in list allow user to enter fields
    By gg091869 in forum Programming
    Replies: 4
    Last Post: 10-04-2013, 04:19 PM
  2. Replies: 1
    Last Post: 10-11-2012, 02:07 PM
  3. Replies: 7
    Last Post: 05-12-2012, 03:46 PM
  4. Replies: 2
    Last Post: 02-09-2012, 04:31 AM
  5. display a list of values based on user input
    By karl1971 in forum Access
    Replies: 3
    Last Post: 12-06-2011, 09:19 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums