I would like to create a list of check boxes on a form which could be converted to specific text for a report. Thanks
I would like to create a list of check boxes on a form which could be converted to specific text for a report. Thanks
What do you mean by a 'list' of checkboxes? And converted to what text? Suggest you provide a mockup of what you want to achieve.
If you want to provide a db for analysis, follow instructions at bottom of my post.
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.
It would be convenient while I do an inspection on a piece of equipment to open a form that had multiple check boxes that could be selected when things were completed, such as “Cleaned”, “Calibrated “ etc. which when a report was run would display “Cleaned” and “Calibrated “ on the report.
To be something "Cleaned", its ID must exist in the table "tblCleaned", along with other details of the "Cleaning" transaction. ;-)
Then, in the report's query you can keep a field based on an expression like this:That means that your database seems to need a new design. :-iCode:IsCleaned: DCount("*";"tblCleaned";"[piece_ID]=" & [piece_ID])>0
Would you be so kind as to explain the expression seeing I am a newbie. Thanks
Hard to know the best solution for the current design while knowing nothing about the tables structure. Might also be possible to make chkCleaned tag property to "Cleaned" and put the tag property into a report textbox. Sounds like the form isn't printed, so why not use a combo and just get the chosen value?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Assuming you table (and form) has a bunch of Yes/No fields you want to check and then show the wording on the report you can use something like this as the control source for the report textboxes:
=IIF([Calibrated]=True,"Calibrated","Not Calibrated")
=IIF([Cleaned]=True,"Cleaned","Not Cleaned")
This assumes the same fields are part of the report's record source.
Cheers,
Vlad
It would be better to keep the data of the completion of each job in a separate table. After that, with a query to this table, you can see if this process has been done or not and, besides, you have a history of your work (who, when, what etc).
So, if you have a table for the cleaning procceses (say tblCleaned), the expresion of my last post returns TRUE if exist records in this table for the specific piece. That means that the specific piece have cleaned.
I hope I'm clear now.Code:DCount("*"; Count everything "tblCleaned"; in table with name "tblCleaned" "[piece_ID]=" & [piece_ID]) where the field "piece_ID" of table "tblCleaned" equals with the field "piece_ID" of the query where this expression take place >0 and the result is greater than zero.
The methodology of attached sample database is based on this theory.
Best regards,
John