[AccessD] A couple of syntax questions

Rocky Smolin rockysmolin2 at gmail.com
Sat Jan 15 16:18:11 CST 2022

1/. AFAIK, Public or Private have to be used to declare what follows is a
sub of function.  It's either/or.

2. I have a module called Publics.  That's where I put all of the Public
subs and functions. Makes them easy to find. Keeps your code neater and
more maintainable. (What if you delete a form or report that's not needed
anymore that contains a public sub or function in the cbf and forget to
check for it? You won't know it until some other sub or function tries to
call it.). So the answer is it doesn't matter.  Until it does.

3. When I have to do this and there are lots of changes being built into
the new version, I import them as I need them. Keeps it clean and leaves
the garbage behind.



On Sat, Jan 15, 2022 at 1:26 PM Arthur Fuller <fuller.artful at gmail.com>

> 1. If a procedure or function declaration is not declared Private, is it
> thus Public?
> 2. More a style question than a syntax question. Concerning the code behind
> a form, it sometimes happens to me that I realize that the body of what was
> a Private function could be extracted and turned into a public sub or
> function and reused elsewhere. Instinct tell me that this reusable sub or
> function should be moved outside the form's code and placed elsewhere.
> Correct, or doe it not matter?
> 3. Preamble: I have a collection of modules containing code that I'll need
> in most if not all serious projects (by serious I mean 100+ tables, as many
> basic forms to address the lookup tables etc., many more queries, and then
> all the master-detail forms). I have gather all these into a a database.
> Beginning a new project, I typically import all these functions and subs.
> Is there a better way, such as creating a library and referencing it,
> similar to the #include and "Uses" statements in other languages
> On another note, when I converted an app to 64-bit, I discovered that Rick
> Fisher's *Find and Replace* no longer worked. A little searching i Google
> led me to AccessDevTools' *Find and Replace. * They have a trial version,
> which I downloaded, tried for two days,and promptly bought a license. This
> product far surpasses; this is not meant as a slam on Rick's original
> product, not at all. For years regarded it as an essential tool. But now in
> the era of 64 and with the benefit of time, this product goes far beyond.
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list