I would expect that the MRU File List is kept in the registry, so it should
be possible to clear it using API calls.
However, this is also an option setting which is shared across all MDBs on
that PC. So a user attempting to open another Access database from that MRU
might not be happy if your program has deleted his entries. If I were such
a user, I certainly wouldn't be happy.
Perhaps you could explain a bit more about your need for this feature?
- Turtle
"Nathan Bloomfield" <na**************@hotmail.com> wrote in message
news:4b**************************@posting.google.c om...
Hi Turtle,
Thanks for your response, I have not yet tested but sounds like it
will work well.
Do you know of any ways of programatically clearing the MRU File List
instead of disabling it?
Cheers,
Nathan
"MacDermott" <ma********@nospam.com> wrote in message
news:<z1****************@newsread2.news.atl.earthl ink.net>...
Try this line of code:
application.setoption "Enable MRU File List", false
Most Access Options are available programmatically through SetOption,
rather than through the CommandBars object.
Note, however, that if you turn off this option programmatically, it
will stay off for any database on that PC - I'd want to be sure that was what
my users wanted before I programmed that!
HTH
- Turtle
"Nathan Bloomfield" <na**************@hotmail.com> wrote in message
news:4b**************************@posting.google.c om... Hi there people,
Is it possible to turn on/off functions in the "options screen" using
the "CommandBars" reference?
If it is possible, I cannot work out the syntax, but I assume it is
something along the lines of the following example:
CommandBars("Menu Bar").Controls("Tools").Controls("Options")....
.enabled = false
The main function I am looking to alter is to turn off "recent files
list"
I hope someone out there can assist.
Regards,
Nathan
Brisbane, Australia