Can Access 2010 create an interface to Windows download?

[John_G]

It's easy enough to have Access download and open a file by treating the file name as a hyperlink, like this:



LINKFILE = DOCUMENTROOT_E & DLookup("Doc_name_en", "web_mos_document_test", "MOS_ID = " & [MOSID])
Application.FollowHyperlink LINKFILE, , True


But is there a way to hace Access use the Windows 7 interface (attached), to give users the option of saving or opening the file?

Thanks

[rpeare]

I don't think there is anything in followhyperlink to allow that prompt to show. If you find a way please post it, I had always assumed followhyperlink assumed you wanted to open the file and I can't find any switches that say otherwise.