Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2006, 10:53 AM
Registered User
 
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problems with listview :S

Greetings, I need to make a listview where informations would be prsented this way:
TEXT-TEXT-TEXT-Checkbox (x8)

When I swich checkboxe to true in my listview, the first column is a checkbox... But I need it to be on the 4th column to the 12th column :S

If anyone know how to do this, please let me know.

I've also heard that Datagrid can do this in an easier way... But I cant find the control of the datagrid (Using Access 2000). If anyone can help me on this part, I'd be very grateful :)

Thanks in advance

 
Old June 15th, 2006, 12:35 PM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

I'm not sure what you are trying to do with this control. Do you want the user to select only one of the choices, or any combination of the choices?



mmcdonal
 
Old June 16th, 2006, 07:41 AM
Registered User
 
Join Date: Jun 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well I want the user to see all the result of a SQL request and let him be able to change the data. For exemple, change a checkbox cell unchecked to checked and save it (For a kindof list of presence, if the client was present, the user will check the checkbox).

I actually found a way to do this using subforms, but the result is really awful and I cant find a way to set a request SQL on my request table, because the request I use shows ALL the results instead of the resultts about the specific meeting... I tried to add a new temporary table with the ID of the meeting chosen, everything's shows fine but we cant change any data, so it is useless for me. So I need to select my request with a small SQL looking like
"SELECT * FROM reqMyRequest WHERE ID_Meeting = " & _
intMeeting

Because when I add ID_Meeting=11 as condition in my request table, everything's work fine... it is only when I go get the ID from another table that it says the recordset cannot be updated.





Similar Threads
Thread Thread Starter Forum Replies Last Post
ListView asters VB.NET 2002/2003 Basics 0 March 27th, 2008 05:00 AM
Listview SelectedItem Apocolypse2005 Visual Basic 2005 Basics 1 October 28th, 2007 01:08 PM
listView AristotleYu ASP.NET 2.0 Basics 0 May 11th, 2006 04:54 AM
Moving columns i ListView problems Skorpa C# 3 May 18th, 2004 01:43 AM
ListView, ListItem problems/questions Tremmorkeep C# 0 July 17th, 2003 04:21 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.