On 8 May, 01:23, Ruben <rubenfmu...@[EMAIL PROTECTED]
> wrote:
> Hello,
>
> I am using the "Application.FollowHyperlink strFilePath, , True" line
> of code from within access forms to launch any file type I want (e.g.,
> xls, doc, pdf, etc.). =A0The files open up okay, but open up in the
> background. =A0How do I make them open in front where they are visible?
> I have tried various things like =A0"Appliction.Visible=3DTrue / False"
> and "Screen.ActiveControl.Visible=3DTrue / False" but have not been able
> to figure it out.
>
> Anyones help with this would be very much appreciated.
>
> Regards,
>
> Ruben Munoz
Instead of using FollowHyperlink have you considered using the Shell
command?
e.g
Shell("C:\MSOffice\OFFICE11\WINWORD.EXE C:\Somedir\..\..
\somefile.doc", vbMaximizedFocus)
this will open the word doc somefile, maximised on top of all other
windows.
Regards
Richard
|
