If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Access Report Clickable Checkboxes

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Posts: 15
How do you selectively make fields enabled?
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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
Access Report Clickable Checkboxes-editproperties.png  
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Posts: 15
still not working

It says that it is enabled.
Attached Thumbnails
Access Report Clickable Checkboxes-accessscreenshot.jpg  
Reply With Quote
  #6 (permalink)  
Old
Registered User
 
Join Date: Nov 2011
Posts: 413
Under Format is it set to Visible as well?
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
Join Date: Dec 2012
Posts: 15
Yes, it is set to be visible
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Nov 2011
Posts: 413
What parameters are in the query the Report is based on?
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
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
Access Report Clickable Checkboxes-accessscreenshot.jpg  
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
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!
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #14 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #15 (permalink)  
Old
Registered User
 
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
Access Report Clickable Checkboxes-continuousform.png  
Reply With Quote
Reply

Tags
access 2010

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On