>Thanks George, you're suggestion seems to work great. However, when I use database fields for my path and filename it doesn't work - lnresult returns 2.
>
>WORKS:
>lnresult = ShellExecute(0,'open',"wmar-100.dwg","","s:\drafting\acts\98202", 9)
>
>DOESN'T WORK:
>lnresult = ShellExecute(0,'open',vacancies_view.fp_name,"",vacancies_view.fp_path, 9)
>
>Any suggestions?
Maybe this should work:
nresult = ShellExecute(0,'open',trim(vacancies_view.fp_name),"",trim(vacancies_view.fp_path), 9)
I've had things like this when I tried to use table fields as filenames - trailing blanks just ruin your day.