Hello folks!,
uhm i am building an enrollment system in my school and i have created a report which gives the summary of enrollment. Specifically it will provide the summary of male,female,foreign,local,new,regular, as well as the total number of enrollment per level per department in our school. The report i am making contains 204 unbound text boxes[uniquely provides information needed] that will be populated by a vba on load. And because of this i created 188 queries for this to function, so this report will be populated on load using the codes below:
[I don't have 10 post yet: but i hope u understand the link of the code:]
hypertexttransferprotocols://www[DOT]dropbox[DOT]com/s/g4crdar45flkxlp/CodesForReport.txt?dl=0
Report output:
hypertexttransferprotocols://www[DOT]dropbox[DOT]com/s/l95c9ff0uycguym/rptEnrollmentESummary.pdf?dl=0
Now because of this, it will take me approximately 20 secs to load and finish the report. It uses approximately 40mb now in memory. I also notice a database opening slowdown (i cant determine the exact quantity, just a slowdown from before). And base from the report we have just 21 enrollees, what more if it will rise?
[When i was doing the query and code for the English Department Summary part, i t was just 3 secs.(i compared the recordset recordcount to dcount(dcount is was way slower, 11 secs, so no way that i will use d count)]
Now that the overallall loading is 20 secs, am i still doing the optimal solution with my code and queries?
Is there better solution?
Btw, i'm using MS Access 2010, the database is not yet split, plan to split yes,
sorry for the noob post, i wish some replies. tnx in advance.
[sorry for forcing to post links without minimum requirements, dont worry i will meet them soon.]
uhm i am building an enrollment system in my school and i have created a report which gives the summary of enrollment. Specifically it will provide the summary of male,female,foreign,local,new,regular, as well as the total number of enrollment per level per department in our school. The report i am making contains 204 unbound text boxes[uniquely provides information needed] that will be populated by a vba on load. And because of this i created 188 queries for this to function, so this report will be populated on load using the codes below:
[I don't have 10 post yet: but i hope u understand the link of the code:]
hypertexttransferprotocols://www[DOT]dropbox[DOT]com/s/g4crdar45flkxlp/CodesForReport.txt?dl=0
Report output:
hypertexttransferprotocols://www[DOT]dropbox[DOT]com/s/l95c9ff0uycguym/rptEnrollmentESummary.pdf?dl=0
Now because of this, it will take me approximately 20 secs to load and finish the report. It uses approximately 40mb now in memory. I also notice a database opening slowdown (i cant determine the exact quantity, just a slowdown from before). And base from the report we have just 21 enrollees, what more if it will rise?
[When i was doing the query and code for the English Department Summary part, i t was just 3 secs.(i compared the recordset recordcount to dcount(dcount is was way slower, 11 secs, so no way that i will use d count)]
Now that the overallall loading is 20 secs, am i still doing the optimal solution with my code and queries?
Is there better solution?
Btw, i'm using MS Access 2010, the database is not yet split, plan to split yes,
sorry for the noob post, i wish some replies. tnx in advance.
[sorry for forcing to post links without minimum requirements, dont worry i will meet them soon.]