UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V  1 2 >  (Go to first unread post)
   Reply to this topicStart new topic
> ListBox Picker    
 
   
strive4peace
post Mar 31 2004, 01:16 AM
Post#1


strive4peace
Posts: 20,459
Joined: 10-January 04



Form with List Box picker -- you can pick one or all Projects to show employees for.
There are 2 list boxes
1. one for projects to choose from and
2. one for projects that have been picked
you can move one item at a time by double-clicking on it or with > or <
you can move all items with >> or <<
Once items are chosen, click Show Query -- Access creates a query showing records from the Employees table that are working on projects in the Projects table -- and opens it up.
Attached File(s)
Attached File  LISTPICK.ZIP ( 50.39K )Number of downloads: 1772
 
Go to the top of the page
 
flyboy021
post Dec 12 2018, 04:35 PM
Post#2



Posts: 1
Joined: 12-December 18



Tried to download, but doesn't open with Access 2016. Anyone have a way of converting into a new version?
Go to the top of the page
 
tina t
post Dec 12 2018, 04:57 PM
Post#3



Posts: 6,107
Joined: 11-November 10
From: SoCal, USA


the attached db in the first post in this thread is in A97 format. if nobody else converts it for you today, i can convert it to A2003 at home this PM, and upload. AFAIK, you should be able to open an A2003 db in A2016. if not, maybe somebody else can pick up the ball and convert from A2003 to a newer version of Access for you.

hth
tina
This post has been edited by tina t: Dec 12 2018, 04:57 PM

--------------------
"the wheel never stops turning"
Go to the top of the page
 
isladogs
post Dec 12 2018, 05:54 PM
Post#4


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


ACCDB version attached. Converted in A2010 then opened in A2016 as a check
Attached File(s)
Attached File  LISTPICK_ACCDB.zip ( 60.45K )Number of downloads: 106
 

--------------------
Go to the top of the page
 
River59
post Dec 13 2018, 10:43 AM
Post#5



Posts: 1,734
Joined: 7-April 10
From: Detroit, MI


isladogs

I would like to make an unusual request of you if I may. I am developing a banking application on a very secure pc that does not allow us to download or open any outside files. I cannot even use a flash drive to move things off or on my computer. What I can do is copy something from here to my pc (at least I can copy/paste any text from here to my pc).

I suggested to my manager that we use a pick list on a couple of our forms. He does not quite understand what I am saying nor what they look like. Since you just posted this, I was wondering if you can post here a screenshot or snip of what one of them look like.
That way he can see how we list our items on one side and the user simply uses the arrow to move them to the other or vice versa.

I would appreciate very much if you can swing this.

Thanks!

--------------------
Remember ... Armstrong, Aldrin and Collins flew to the moon and back with a computer system less complex than a modern, programmable toaster ...
Go to the top of the page
 
cheekybuddha
post Dec 13 2018, 10:58 AM
Post#6


UtterAccess VIP
Posts: 11,515
Joined: 6-December 03
From: Telegraph Hill


Hi there,

Here's a screenshot of the form in the demo.

hth,

d
Attached File(s)
Attached File  20181213_listpick_pic.PNG ( 38.77K )Number of downloads: 52
 

--------------------


Regards,

David Marten
Go to the top of the page
 
River59
post Dec 13 2018, 11:23 AM
Post#7



Posts: 1,734
Joined: 7-April 10
From: Detroit, MI


Thank you cheekybudda!

--------------------
Remember ... Armstrong, Aldrin and Collins flew to the moon and back with a computer system less complex than a modern, programmable toaster ...
Go to the top of the page
 
isladogs
post Dec 13 2018, 01:39 PM
Post#8


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


Thanks for saving me that job David!

--------------------
Go to the top of the page
 
cheekybuddha
post Dec 13 2018, 01:46 PM
Post#9


UtterAccess VIP
Posts: 11,515
Joined: 6-December 03
From: Telegraph Hill


No probs! I was curious to look at the demo anyway.

thumbup.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
isladogs
post Dec 13 2018, 01:48 PM
Post#10


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


I was particularly grateful as I had deleted it again from my computer - I already have similar code! thumbup.gif

--------------------
Go to the top of the page
 
tina t
post Dec 13 2018, 05:13 PM
Post#11



Posts: 6,107
Joined: 11-November 10
From: SoCal, USA


Doug Steele also documented the code and instructions for the two-listbox setup in an issue of Smart Access, which can be found on his website here. scroll down to the link called March 2006: Let me check my list... to download an A97 demo db and A2000 demo db, and a pdf file with the code, etc.

hth
tina

--------------------
"the wheel never stops turning"
Go to the top of the page
 
MadPiet
post Dec 13 2018, 07:12 PM
Post#12



Posts: 3,327
Joined: 27-February 09



Does anybody have the version that was in Access 2003 (?) Developer's Handbook? There was one that used collections, I think.
Go to the top of the page
 
River59
post Dec 19 2018, 12:17 PM
Post#13



Posts: 1,734
Joined: 7-April 10
From: Detroit, MI


tina t,

I wanted to see the link that you posted ... oops! That site is blocked ... thumbdn.gif
I have a number of databases that I developed stored on thumb drives with a lot of code for functions I've done. Unfortunately I can't use a thumbdrive on this pc and my pc decided to crash and burn Microsoft Office (will not let me reload), so I cannot open the thumb drives there either.
I have to go to the library, open the appropriate database, copy the code to NotePad and save on the thumbdrive. Then, I can put the thumbdrive into my personal computer, open the file, and retype all of the code ... pullhair.gif

Are we having fun yet?

--------------------
Remember ... Armstrong, Aldrin and Collins flew to the moon and back with a computer system less complex than a modern, programmable toaster ...
Go to the top of the page
 
isladogs
post Dec 19 2018, 12:55 PM
Post#14


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


If I had to do that, I'd definitely want to retire! See this parallel thread

--------------------
Go to the top of the page
 
River59
post Dec 19 2018, 01:04 PM
Post#15



Posts: 1,734
Joined: 7-April 10
From: Detroit, MI


Yes, isladogs, it [censored] to be me right now ...

I can't believe I just got censored ... hahaha

Rewrite:

Yes, isladogs, it isn't fun to be me right now ....

This post has been edited by River59: Dec 19 2018, 01:06 PM

--------------------
Remember ... Armstrong, Aldrin and Collins flew to the moon and back with a computer system less complex than a modern, programmable toaster ...
Go to the top of the page
 
isladogs
post Dec 19 2018, 01:14 PM
Post#16


UtterAccess VIP
Posts: 1,680
Joined: 4-June 18
From: Somerset, UK


LOL.
Sometimes the automatic forum censoring does seem a touch extreme

--------------------
Go to the top of the page
 
tina t
post Dec 19 2018, 03:52 PM
Post#17



Posts: 6,107
Joined: 11-November 10
From: SoCal, USA


QUOTE
I wanted to see the link that you posted ... oops! That site is blocked ...

wow, i navigated to that webpage, and copied the URL to post the link. now i can't get to it either, from my posted link, or direct from Google. bummer! wish i'd downloaded the files... :( tina

--------------------
"the wheel never stops turning"
Go to the top of the page
 
cheekybuddha
post Dec 19 2018, 04:39 PM
Post#18


UtterAccess VIP
Posts: 11,515
Joined: 6-December 03
From: Telegraph Hill


Put a shout out to Doug.

I found his dsn-less page still works but everything else was 404.

--------------------


Regards,

David Marten
Go to the top of the page
 
tina t
post Dec 20 2018, 01:16 PM
Post#19



Posts: 6,107
Joined: 11-November 10
From: SoCal, USA


thanks, David! i just PM'd Doug. :) tina

--------------------
"the wheel never stops turning"
Go to the top of the page
 
Doug Steele
post Dec 20 2018, 02:15 PM
Post#20


UtterAccess VIP
Posts: 22,203
Joined: 8-January 07
From: St. Catharines, ON (Canada)


Dang! The site was recently migrated to another host, and it looks as though some of the subwebs didn't migrate properly.

I'll ping the owner of the site and see what's the problem. However, even when the site's back up, it may not solve your issue, because the sample database was created in Access 97, so can't be opened in newer versions.

The good news, however, is that the article and converted database is available online at Let me check my list

--------------------
Doug Steele, Microsoft Access MVP (2000-2018)
Personal webpage
Microsoft profile
Co-author: Access Solutions: Tips, Tricks, and Secrets from Microsoft Access MVPs, published by Wiley
Co-author: Effective SQL: 61 Specific Ways to Write Better SQL, published by Addison-Wesley Professional
Technical Editor: Access 2010 Bible, Access 2013 Bible, Access 2016 Bible, all published by Wiley
Technical Editor: SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, 4th Edition, published by Addison-Wesley Professional
Go to the top of the page
 
2 Pages V  1 2 >


Custom Search


RSSSearch   Top   Lo-Fi    15th October 2019 - 06:59 AM