Results 1 to 9 of 9
  1. #1
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365

    Using checkboxes Listview control


    Help! I have the listview control in and working but
    Code:
    LV1.Checkboxes = True
    is bringing up error Method or data member not found
    I have googled for a solution but can't find one - only others asking how to do it.
    Please does anyone know how ?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Exactly what do you want this line to accomplish? Are you trying to set all checkboxes to True? What event is this code in?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    There's a list of items and I want to flag some to be used when an "OK" button is clicked.
    If a checkbox is impossible, perhaps I can use the row click event to build a list on the list index.
    But checkboxes would be better.
    The Listview Control is in a Form on it's own and Form Load populates it from a files search.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    You want to selectively check some boxes based on some criteria?

    I have done very limited testing with listview and that is one aspect I have not looked at. I can check/uncheck all which involves a looping structure. I suspect the same will be needed for your conditional check. What would be the criteria determining checked/unchecked?

    Do you want to provide db for review?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    Thanks June. You have managed to make checkboxes visible ? That sounds very promising.
    Normally they're in the first column, and can be checked/unchecked by clicking on them, The Criteria is what rows the user wants to select.
    I'll attach my Form, but it doesn't contain very much and criteria is not relevant so I 've just populated a few rows with text.
    Attached Files Attached Files

  6. #6
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Okay, your form is not using a ListView control, it is just a Listbox.

    Listbox and Combobox only show checkboxes when bound to a multi-value field.

    Suggest you consider CJ's app.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    Middlemarch is offline Competent Performer
    Windows 10 Access 2019
    Join Date
    Mar 2015
    Posts
    365
    Well, that's mighty embarrassing, I'd created the Form some time back and as I always use a listview, just assumed it was.
    No wonder the listview instructions weren't working.
    Now all is perfect, checkboxes galore. CJ's example was great, but the way listview allows column resize is a winner.
    Thanks to you both.

  9. #9
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    You can adapt the example to use a datasheet in a subform if you wanted resizeable columns

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Listview Control
    By Middlemarch in forum Programming
    Replies: 13
    Last Post: 08-21-2023, 08:08 PM
  2. Anyone used listview control in Access
    By Middlemarch in forum Forms
    Replies: 2
    Last Post: 12-27-2022, 01:26 AM
  3. How to requery listview control from subform.
    By atzdgreat in forum Forms
    Replies: 8
    Last Post: 10-31-2019, 03:48 AM
  4. MS ListView Control for office 2013
    By moodhi in forum Forms
    Replies: 2
    Last Post: 10-19-2017, 04:23 PM
  5. ListView Control (ActiveX) in Ms.Access Form
    By ahmed_one in forum Access
    Replies: 18
    Last Post: 04-21-2015, 10:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums