General 'modules' questions

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello All

2 questions:

1) What is the difference between these 2 newsgroups - modulescoding and
modulesdaovba?
2) Does 'compile' mean 'Check syntax of ...', and if so what does
'decompile' do?
(sorry - that was 3 questions!)

Many thanks
Les
 
Leslie,

See answers below respective questions.

HTH,
Nikos

Leslie said:
Hello All

2 questions:

1) What is the difference between these 2 newsgroups - modulescoding and
modulesdaovba?
Click to expand...

Modulesdaovba is the old NG, supposedly being phased out; modulescoding
is the new NG to replace it. Apparently, though, this is not so apparent
(lol), so the old one still gets many more posts.

2) Does 'compile' mean 'Check syntax of ...', and if so what does
'decompile' do?
Click to expand...
Access cannot execute the hich level (VBA) code that you write in the
modules; it has to convert it to executable code first (much harder for
the human brain to follow, let alone write!). The process of converting
is called compilation, which involves various checks, including syntax
check. Then the compiled (executable) code is stored in your .mdb (or
..mde). If you don't compile manually, Access will force a compilation of
each process before it can execute it.

The undocumented "Decompile" action removes the compiled (executable) code.
 
Leslie said:
Hello All

2 questions:

1) What is the difference between these 2 newsgroups - modulescoding
and modulesdaovba?
Click to expand...

modulescoding is the new one that people should be moving to, but not all new
servers have it available yet (old newsgroups are extrememly hard to kill).
2) Does 'compile' mean 'Check syntax of ...', and if so what does
'decompile' do?
(sorry - that was 3 questions!)
Click to expand...

The source code (just text basically) is compiled to a more "computer readable"
form. Access code is not compiled all the way to machine code, but it does
still get compiled to an intermediate stage where the human readable text is no
longer needed. An MDB contains both the compiled code and the text version
whereas an MDE performs the additional task of discarding the source code
leaving only the machine readable code.

Uncompiling tosses out all of the compiled code and leaves only the source text.
This often helps eliminate corruptions that might be affecting the compiled
portion of the code.
 
Klatuu said:
So where is modulescoding? I don't see it in the list under Access.
Is it somewhere else?
Click to expand...

The last I looked, it hadn't yet been included in the web-based
newsreader.
 
Thanks for replying, Dirk. I see your posts often, and you seem very
knowledgable, but your answers, as in this case, are sometimes cryptic. I
already know where it is not. Now I am trying to find out where it is. Your
help would be greatly appreciated.
 
Klatuu said:
Thanks for replying, Dirk. I see your posts often, and you seem very
knowledgable, but your answers, as in this case, are sometimes
cryptic. I already know where it is not. Now I am trying to find
out where it is. Your help would be greatly appreciated.
Click to expand...

Sorry, I never mean to be cryptic. I actually have a tendency to be too
wordy -- ask anyone who's been around a while -- and I'm trying to cut
back.

Anyway, to answer your question, the newsgroup
<microsoft.public.access.modulescoding> has been created on Microsoft's
NNTP server and may have been picked up by other, independent news
servers by now, but hasn't yet been added by Microsoft to the newsgroups
that they make available via their web-based newsreader. If you use a
newsreader program like Outlook Express, Agent, Dialog, or XanaNews (to
name a few), as opposed to the web interface, and connect directly to
the server msnews.microsoft.com, you'll be able to see this and many
other newsgroups that aren't presented on the web site.

If you aren't familiar with the use of a newsreader program to read and
post to newsgroups, you may want to try it. Most of us old-timers --
particularly those of us who don't have broadband internet
connections -- prefer it. Many corporate employers block NNTP, though,
to keep people from wasting time read ... prurient material ... all day.
 
Thanks, Dirk. I have some learning to do. This is something I have not
previously encountered in my 28 years in IT. I will admit to being a novice
when it comes to some of the things you can do on line. It is just that my
career path has not taken me in that direction, yet. It looks like I will
be, I am having to learn C# so we can do a web based application to replace
some really bad old Access code.
 
Klatuu said:
Thanks, Dirk. I have some learning to do. This is something I have
not previously encountered in my 28 years in IT.
Click to expand...

It sounds like we're contemporaries.
I will admit to
being a novice when it comes to some of the things you can do on
line. It is just that my career path has not taken me in that
direction, yet. It looks like I will be, I am having to learn C# so
we can do a web based application to replace some really bad old
Access code.
Click to expand...

You have my sympathies. Turning an Access app into a web application is
a lot of work, even if the Access app is well-written.
 
Back
Top