Access Runtime Hyperlinks

[bigsich]

I'm building a database which will be deployed with clients using access runtime. One of the requested features is to be able to link appropriate files from the server (i have mapped all the drives to each computer) to each project (i.e. autocad drawings, POs,...). You can't right click in access runtime, and there's no way I'm going to be able to get them to manually type in the file path. Is there a way to open up the edit hyperlink dialog box so they can select the file path to insert into the record?

[June7]

Everything I read says hyperlink dialog doesn't work in runtime. So alternative is maybe to not use hyperlink field type. Save path in text field and use code to treat the field as a hyperlink http://allenbrowne.com/func-GoHyperlink.html

Maybe Windows FileDialog will work in runtime http://msdn.microsoft.com/en-us/libr...ffice.11).aspx