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
|