undocumented VBA features

  • Thread starter Thread starter pvp
  • Start date Start date
P

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.
 
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.
Click to expand...

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
 
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
 
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...
Click to expand...

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
 
Back
Top