Solved

Which is more efficient, Procedures on a form or in a module

Posted on 2004-08-27
4
244 Views
Last Modified: 2010-04-17
I have a very large module (.bas) containing maybe 40 procedures. I third of these pertain to reports. Would it be more efficient to have the report procedures moved to the Form used for reports?

When A procedure in a .bas is executed, does the whole .bas get loaded into memory?



Sorry I only have 40 points!
0
Comment
Question by:hrogers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 5

Accepted Solution

by:
rsriprac earned 40 total points
ID: 11918665
>I have a very large module (.bas) containing maybe 40 procedures. I third of these pertain to reports. Would it be more efficient to have the report procedures moved to the Form used for reports?

Yes if some form is used more infrequently then others, it is worth doing so.

>When A procedure in a .bas is executed, does the whole .bas get loaded into memory?

Yes, the whole module is loaded when a routine is called upon.

-RAm
0
 
LVL 3

Expert Comment

by:aravindtj
ID: 11921600
Use modules. It is loaded in memory only once.
It can be reusable by another methods.

Using modules is a better way.

All the best.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Octopus Deploy: need a Time Event that fires every midnight 2 59
"lblTime is not declared" 3 65
Looking for reading material 2 45
Notepad++ Question 11 28
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question