Page 1 of 2 12 LastLast
Results 1 to 15 of 22
  1. #1
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29

    Unbound check box on continuous form

    If I have an unbound check box in continuous form view, checking the box checks the box for all records. This actually makes sense to me but I'm fishing for ideas for a work around that will allow me to have a check box in continuous form view. I guess the short answer is to just create a new y/n field in the table that has no meaning and bind it to that? Can anybody think of a better way? I was think about using a function as the datasource but can't get it to work.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    What is purpose of checkbox? If you need a method for arbitrary selection of records, then the checkbox must be bound to field.
    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
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29
    I have a list of users and I want to select some from the list to do an action like send an email to the ones selected

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    "Can't get it to work" doesn't tell us much. If you need help with code then post it for analysis.
    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
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29
    I have a sample access file where I have an example. I'd like to include it so you can see what I'm trying to do but do not know how to attach a file.

  6. #6
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You can't have unbound checkboxes such as you are trying to accomplish. Selecting one will select them all. One option is to have a temporary table which contains the checkbox. Another option would be to have a listbox instead of a subform and allow multiple selections.

  7. #7
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29

    Here is a sample of what I'm trying to do.

    In the example if have a yes/no field in the database which will work but I do not want to have to add that field to the database. What I want to do it which the check9 control, I'd like to be able to check each row individually if I want that customer to be selected.

  8. #8
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29
    I've try to attach the file but can not get it to work.

  9. #9
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    another option is to use a disconnected ado recordset

    also see this link which may meet your needs

    https://www.access-programmers.co.uk...d.php?t=289116

  10. #10
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I've try to attach the file but can not get it to work.
    click on the 'go advanced' button, then scroll down to 'Attachments'

  11. #11
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29
    I've done the open to create multiselect listbox which works but I would like to have it works with the checkbox.

  12. #12
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29
    I've tried the advanced button but when I either drag the file over or use the browse to file and insert, how do I get it to actually attach the file?

  13. #13
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I've done the open to create multiselect listbox which works but I would like to have it works with the checkbox.
    if you are referring to the link I provided, then I don't think you can since you cannot conditionally format a checkbox. You will either need to add a checkbox to your underlying or separate table or use a disconnected ado recordset as previously suggested.

    how do I get it to actually attach the file?
    1. Click manage attachments
    2. click add files
    3. click browse
    4. click upload - attachment will appear at bottom of form
    5. click insert inline - at the bottom of the attachments widnow
    6. close the attachments window

  14. #14
    Rpschwar is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2017
    Posts
    29
    I have tried all steps but when I do insert inline(0) I get an error:
    www.accessforums.net says:

    Please drag & drop an existing attachment on to "Drag Files Here" or add
    a new one by pressing "Add Files".

    Both get me to the same place with the error. I can not even attach an image.

  15. #15
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    I do insert inline(0)
    the 0 implies you have not got a file to insert - are you completing steps 3 and 4 above?

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 8
    Last Post: 07-24-2017, 03:16 AM
  2. Replies: 1
    Last Post: 03-07-2017, 06:32 AM
  3. Check all check boxes on continuous form
    By NISMOJim in forum Forms
    Replies: 7
    Last Post: 06-14-2016, 02:14 AM
  4. Replies: 9
    Last Post: 07-14-2014, 07:56 PM
  5. Populating a Continuous Form with Unbound Fields
    By gazzieh in forum Programming
    Replies: 6
    Last Post: 02-28-2013, 11:11 AM

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