Microsoft Access Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Microsoft Access Development
Reload this Page

Query based on list column

Discuss Query based on list column in the Microsoft Access Development forum on Dev Articles.
Query based on list column Microsoft Access Development forum to discuss problems and solutions with this popular DBMS. Use Access to build and modify database tables, or full-featured applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 13th, 2006, 06:48 PM
firebellyx firebellyx is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2006
Posts: 1 firebellyx User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 m 13 sec
Reputation Power: 0
Query based on list column
I need to know how to base a query on a column from a selected listbox value.

(example (I know this is wrong))... =list17.selected(column(1))
what would be the appropriate way to reference a column in a selected value of a listbox?
Reply With Quote
  #2  
Old June 14th, 2006, 03:43 AM
MStef MStef is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2006
Location: Zagreb - Croatia
Posts: 94 MStef User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 17 h 30 m 49 sec
Reputation Power: 3
Look at "DemoLBColumnA2000.mdb".
Look at Form1,ListBox, BoundColumn properties.
Look at Query1, Table1.
Attached Files
File Type: zip DemoLBColumnA2000.zip (14.0 KB, 357 views)
Reply With Quote
  #3  
Old June 28th, 2006, 09:08 AM
DuBB DuBB is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2006
Location: Amsterdam, The Netherlands
Posts: 2 DuBB User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 36 m 51 sec
Reputation Power: 0
Query 2 or more values from column
Thanks, great sample and works like a charm !
Is there anyone who knows how to modify this, or make a different solution to query 2 or more values from the column ??
Reply With Quote
  #4  
Old June 30th, 2006, 03:44 AM
MStef MStef is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Mar 2006
Location: Zagreb - Croatia
Posts: 94 MStef User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 17 h 30 m 49 sec
Reputation Power: 3
Hello DuBB!
Look at "DemoLBColumnA2000.mdb" a new one.
Look at QueryTem, Query2,
Open Form2 and try to select more lines in list box.
You have to include MICROSOFT DAO 3.6 OBJECT LIBRARY
in references in your mdb.
Comments on this post
DuBB agrees!
Attached Files
File Type: zip DemoLBColumnA2000.zip (22.0 KB, 262 views)
Reply With Quote
  #5  
Old June 30th, 2006, 01:28 PM
DuBB DuBB is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Jun 2006
Location: Amsterdam, The Netherlands
Posts: 2 DuBB User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 36 m 51 sec
Reputation Power: 0
Great Thanks !!
Hi MStef,

This looks exactly like the thing I was looking for.
I probably never become a great wizard like you are.
Thanks a lot, I will now try to get this working in the database i'm working on.

Greetings from Amsterdam !
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Microsoft Access Development > Query based on list column

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway. 
Stay green...Green IT