Group:  Microsoft Access ยป microsoft.public.access.macros
Thread: Delete from Most Recently Used list

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

Delete from Most Recently Used list
Rey 01.03.2006 12:04:31
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


--
Rey
RE: Delete from Most Recently Used list
Rey 09.03.2006 03:19:28
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?
--
Rey


"Rey" wrote:

[Quoted Text]
> 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
>
>
> --
> Rey

Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net