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