Delete from Most Recently Used list

R

Rey

I am running Offcie Professional Edition 2003 and want to clear the MRU for
ACCESS 2003. I go through the procedure of unchecking and checking the
Recently Used File checkbox suggested in the Knowledge database. The same
list reaapears that was there before.
In Word2003 I can do a macro to select what to delete (see below). Is there
a way in Access that I can either delete a single file from the MRU as I do
in Word or delete all the files in the MRU, not just hide them. I want them
gone so that when I check the Display Recently USed Files they are gone but I
can see future files I open.
This Macro does the trick in Word 2003 can I do the analogous in Access2003?:

Sub TEst()
For Each rfile In RecentFiles
fname = rfile.Path & "\" & rfile.Name
RTN = MsgBox("Do you want to delete" & Chr(10) & fname & Chr(10) &
"from the recent files?", vbYesNo + vbDefaultButton2)
If RTN = vbYes Then
rfile.Delete
End If
Next rfile

End Sub
 
R

Rey

Is there no one out there that can answer this question? I have in the
intervening week figured out that if I go on regedit to HKEY_USERS\CURRENT
USER\Software\Microsoft\Office\11.0\Access\Settings and null out the data for
the MRU1-9 that will do the trick. However, I truly prefer not top mocking
around with Regedit and would much more like to be able to run a macro like
the one below for Word. Anyone out there know how I can do that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top