Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-10-2013, 11:31 AM   #1
reb0101
Newly Registered User
 
Join Date: Oct 2006
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
reb0101 is on a distinguished road
Binding Data to a ListView

hey all,
I'm back to banging my head against the wall on an entirely different issue, the elusive ListView.
Let me tell you what I have, and works, and what I'm hoping for, not working yet.
Shipping Database that seems to never be complete.

REGION TABLE:

REG_ID (PK Autonumber)
SELECT (YES/NO select)
REGION (Text)

COUNTRY TABLE:

CNTRY_ID (PK Autonumber)
SELECT (YES/NO select)
COUNTRY (Text)

There are other tables, PORT, CARRIER, etc but they don't matter now because if I can get it to work with REGION/COUNTRY it certainly won't work with others.
This is what i have and works, so far;

QRY_REG (query to REGION table) and is the record source for a continous_forms subform.
When a REGION is selected and it is refreshed, it filters the subform for COUNTRY right next to it just like a cascading combo box.
REGION check box is selected, COUNTRY checkbox is selected and then another query that on a button will append the selected values from both to SHIPMENTS table.
It will also clear the selected values.
This works but I want to be able to do this with a Listview (not Listbox).
I have spent several hours trying to get my head around the code to bind that Listview with data from both tables.
1 or 2 source files were found but one has so many bells and whistles I can barely even find the relevant SQL (it has buttons to change icons, colors, etc).
at least theoretically this should not be rocket science.
Binding 2 or 3 fields at most from one table.
One more thing and this is just an extra (stumbled upon it in the aforementioned code).
I would like to add one more SELECT box to the COUNTRY table.
This would be "INACTIVE" so that if it is selected the COUNTRY populated in the ListView would be in Red, or vbRed.
The ListView will not have to display this value, it can be set from another form.
Only need COUNTRY and the SELECT box for the ListView, same for REGION.
How hard would this be just to bind a table to a ListView?

reb0101 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
How do I save data in listview in table biancaioana Modules & VBA 14 08-25-2012 04:28 AM
binding data to listbox jamesmor VB.NET 1 11-10-2010 11:33 PM
Binding Passed Data Matty VB.NET 12 08-18-2006 03:21 PM
Reading Data From a ListView Control the_utmost Forms 0 03-14-2005 01:11 PM
binding data to a calander control jamesdawson Modules & VBA 2 11-07-2002 06:54 PM




All times are GMT -8. The time now is 07:54 AM.


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