Page 1 of 2 12 LastLast
Results 1 to 15 of 24
  1. #1
    Join Date
    Dec 2012
    Posts
    15

    Question Access Report Clickable Checkboxes

    I have an Access report that populates based on results of a query. I need the report to have checkboxes on each line for the user to click on and off independently.

    I have tried using unbound checkboxes on the report and when you click one, the whole list comes on/off. When I make the boxes bound to a yes/no column in the table you cannot click them at all. It gives an message at the bottom that control cannot be edited. The reports are read only.

    So, how do you create checkboxes that can be clicked on or off independently in the report?

    I have also tried exporting to Word, and the checkboxes do not show up. Exporting as PDF they show up, but are not functional.

    Please help me. I am a newbie.

  2. #2
    Join Date
    Nov 2011
    Posts
    413
    If your Report is Read Only, of course the checkbox will not work! Selectively make fields enabled and leave the checkbox as enabled.

  3. #3
    Join Date
    Dec 2012
    Posts
    15
    How do you selectively make fields enabled?

  4. #4
    Join Date
    Nov 2011
    Posts
    413

    Open Report is Design mode.

    Right click the field and edit it's properties in design mode.Click on the 3 dots next to the field. Hope this helps.
    Attached Thumbnails Attached Thumbnails EditProperties.png  

  5. #5
    Join Date
    Dec 2012
    Posts
    15

    still not working

    It says that it is enabled.
    Attached Thumbnails Attached Thumbnails AccessScreenShot.jpg  

  6. #6
    Join Date
    Nov 2011
    Posts
    413
    Under Format is it set to Visible as well?

  7. #7
    Join Date
    Dec 2012
    Posts
    15
    Yes, it is set to be visible

  8. #8
    Join Date
    Nov 2011
    Posts
    413
    What parameters are in the query the Report is based on?

  9. #9
    Join Date
    Dec 2012
    Posts
    15
    Well, the query reads responses the user puts in on a form. I have multivalue checkbox set up, so the user can select parameters of the work that is being done. There are many fields from the table in the query parameters. The two in the picture called used in plan, and n/a are my yes/no fields in the table.
    Attached Thumbnails Attached Thumbnails AccessScreenShot.jpg  

  10. #10
    Join Date
    Nov 2011
    Posts
    413
    This can be done but not so easy.I refer you to these links to view the steps. You will need to embed a macro and use a custom menu for it to work.
    Add a custom macro menu to Word | TechRepublic
    SetValue Macro Action

  11. #11
    Join Date
    Nov 2011
    Posts
    413
    So why not simply use the form to update the Report? Check off what you like and then the Report will show what you want!

  12. #12
    Join Date
    Dec 2012
    Posts
    15
    The report spits out suggested items for the plan set, which may or may not apply in the designer's circumstance. This is why the user needs to be able to check for each item whether it is used in the plan or n/a.

  13. #13
    Join Date
    Dec 2012
    Posts
    15
    The user needs to input these for each circumstance. The only reason I added it to the table is so the checkboxes could be bound.. When I used unbound checkboxes, then if you clicked one they all became checked.

  14. #14
    Join Date
    Dec 2012
    Posts
    15
    I have been tasked with creating a checklist that is dependent on certain conditions, then the user has to save and send in a copy showing that they either used the item or it does not apply.

  15. #15
    Join Date
    Nov 2011
    Posts
    413

    Here is a Screenshot Example

    Why not use a continuous form or datasheet and just check off what you need to? Add the criteria to the form. I can only visualize so much without seeing what you have. I would write the code for this on a form and then use either a continuous form or datasheet myself.
    Attached Thumbnails Attached Thumbnails ContinuousForm.png  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •