lorenambrose
Apr 4 2012, 02:41 PM
I am looking for some VBA for a button in an Access 2007 db that when clicked will copy a SHORTCUT icon from:
"P:\QMS DATABASES\Shortcuts"
the icon is the "Shortcut to Record Retention Schedule"
The user then can "paste" it anywhere the like.
pere_de_chipstick
Apr 4 2012, 02:55 PM
Hi
You could try:
FileCopy "P:\QMS DATABASES\Shortcuts\Shortcut to Record Retention Schedule.lnk", "SomePath\Shortcut to Record Retention Schedule.lnk"
Replacing 'SomePath' with the folder path where the user wants to save the shortcut.
hth