473,320 Members | 1,965 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Generating reports based on checkbox event

My problem goes like this.....
I have an access database file in which i have tables,forms,queries,reports and sub-reports...I have many forms in my database..The forms consists of many sub-forms in it...when i am executing a query on a form which has six sub-forms in it a report is generated with all the data of main form and data in six sub-form..This is working fine..But i wants the report to be generated only ifuser selects any particular sub-form..for example..there will be a check box on every subform..the data in that sub-form should be generated on report unless the user checks the chekbox..should i be writing some query for this action or should i be writing vb scripts for this event ..Am a beginner in vb script .please help me with code/query ..Any help from you would be appreciated..Many thanks in advance

Regards
May 3 '12 #1
2 1790
Mihail
759 512MB
For now I can see 2 approaches, depending how data from sub-forms are displayed in the report:
1) If you use sub-reports then you can show/hide the sub-reports based on the related checkbox value;
2) If the report is based on a query then design the query to select or none the records based on the check boxes values.
May 4 '12 #2
maxamis4
295 Expert 100+
The other item to remember is that you will have pass through the filter into the report form. If you need examples with this please let me know.


Reference link
** SNIP **
May 7 '12 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: jeffgeorge | last post by:
Trying to create multiple acct reports based on the selection in a list box. I've set the list box for multiple selections, and in the report data source, I have a SQL statement which is reading...
2
by: Vikram | last post by:
i want simple report functionality for which i do not want to use any reporting tool like crystal etc. Is there any class or code available which can be used for generating reports using asp.net...
5
by: tshad | last post by:
Is there a way to allow a user to press a radio button if it is already selected? There is an onCheckedChanged event that fires when the person presses the button and it is isn't selected...
4
gregerly
by: gregerly | last post by:
Hello All, I just wanted to get some input from the experts, what options are available for generating reports using PHP / MySQL. I can easily create HTML reports, but I'm thinking more along the...
0
by: Aswanth | last post by:
I'm Generating Reports in SSRS-2005.. Previously I got the Data from One Database & Generated Reports.. Now I used to get the Data from Two Different Databases(ie Database-1 & Database-2) & to...
0
by: Aswanth | last post by:
I'm Working with Asp.Net with C#.. & I'm Generating Reports in SSRS-2005.. Till Now I'm Generating Reports in SSRS-2005 with Stored Procedure.. in Which I'm Generating Reports for One...
0
by: Aswanth | last post by:
I'm Using Asp.Net with C# & SSRS 2005 for Generating Reports.. I'm Having HUGE Data in Text Log File.. I want to Get this Data from this Log File & to Generate REPORTS in SSRS 2005.. Please...
1
by: Aswanth | last post by:
I'm Using Asp.Net with C# & SSRS 2005 for Generating Reports.. I'm Having HUGE Data in Microsoft Excel Sheets .. I want to Get this Data from this Microsoft Excel Sheets & to Generate REPORTS in...
1
by: sbettadpur | last post by:
hello everybody, please give me an information for generating reports in pdf format. where i will get library files, with an example of creating pdf files thank you
0
by: Minckeleers | last post by:
hello everyone, I'm pretty new in VB, moderate experience in Acces but I need to get a 'universal' code for generating reports from a table or query. It has to automatically create a report...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.