PDA

View Full Version : Print button connected with checkboxes



mms1991
08-22-2017, 04:50 AM
Hello, I'm a beginner developer and I need your help. I have Access database ( records were imported form Excel) and I made a form with checkboxes which names are the same like name of columns in database. I would like to connect them with this columns and make a button for printing only checked columns (you know what i mean? it's difficult to explain it to you in English).

OBP
08-25-2017, 01:30 AM
Apologies for the late reply, I did not see this post appear.
This can be done, but depending on how many Fields (columns) you have it may be easier to create Queries and Reports for all the combinations that you might have.
The reason that I say this is because creating the queries and reports at run time and then deleting them causes the database to grow quite quickly.
It may also take a lot of debugging to get it to operate satisfactorily.
It might also be possible to create one report and then hide the Fields that you do not want to display, the only downside is it will probably leave blank areas in the report.

How would you like to proceed?