undocumented VBA features

[pvp]

I have come across a number of undocumented functions/subs/tools in my
time using Access 2002.

Is there a place on or off the web where I can find most of these
undocumented but useful VBA features described? And what is MS' attitude
to these?

Many thanks.

 

[Jim Allensworth]

I have come across a number of undocumented functions/subs/tools in my
time using Access 2002.

Is there a place on or off the web where I can find most of these
undocumented but useful VBA features described? And what is MS' attitude
to these?

Many thanks.

Some of them are right in Access. If you open the Object Browser and
right click on a window, you will see an option to Show Hidden
Members. Select that to see some undocumented features. For example
you can see the SaveAsText method of the Application object. Also,
when this is checked intellisense will be available for the objects.

Note that this setting will not persist through instances of Access.

- Jim

 

[Guest]

Thanks for that, Jim. Wher are these 'undocumented' features described?
Don't tell me, they're undocumented but surely there must be some info
somewhere...

Thanks,

pvp

 

[Larry Linson]

Thanks for that, Jim. Wher are these 'undocumented' features described?
Don't tell me, they're undocumented but surely there must be some info
somewhere...

Would "here and there and maybe nowhere" be useful? It would be accurate.

Some features are undocumented on purpose, because, though they work in a
particular version, they may not appear in some later version... there is
"unofficial documentation" (that is, non-Microsoft information) on some of
those in various places. But, you can't rely on them working in a future
version or even a release updating the current version. Others are
undocumented because they were not tested and validated to the vendor's
satisfaction -- they may or may not be documented in a future version.

Larry Linson
Microsoft Access MVP

 

[Guest]

Larry, at least your answer s useful in so far as it confirms what I thought/
feared... Many thanks for that.

Thread ends.

 

[Larry Linson]

You are welcome.

One rather well-documented "undocumented feature" has been around for many
versions -- it is the "/DECOMPILE" command line parameter. Some would say it
is "semi-documented" because it has been mentioned in some Knowledge Base
articles.

If you hear about some such feature, get as much information as you can, and
try Googling, either on the web at http://www.google.com or in the newsgroup
archives at http://groups.google.com. It's surprising how much informal
documentation exists.

And, what I described about undocumented features is just "industry
standard" information -- not specific to (but applicable to) Microsoft
software.

Larry Linson
Microsoft Access MVP


Larry, at least your answer s useful in so far as it confirms what I
thought/
feared... Many thanks for that.

Thread ends.