Go Back   Access World Forums > Microsoft Access Reference > Microsoft Access Tutorials

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-21-2015, 12:48 PM   #1
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,334
Thanks: 0
Thanked 735 Times in 720 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
User Pick Lists

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 selections.

below are the queries/events that go with the various controls...
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


pick3NY-lbls.jpg

Ranman256 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating lists of items and running a report on total sales of items in the lists... thesurfagents Reports 0 09-27-2012 11:44 AM
May I Pick Your Brains? JediYodaNT Queries 3 08-04-2010 12:55 PM
Copying data between lists with value lists as recordsource CrArC Modules & VBA 2 09-14-2007 12:30 AM
Randomly pick records for each User ren1104 Queries 4 02-24-2007 09:25 AM
Pick List EmmaJane Excel 2 03-16-2006 08:34 AM




All times are GMT -8. The time now is 12:46 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World