Follow Hyperlink

[Guest]

I am using Application.FollowHyperlink to launch another
application/document. WHen I do so, however, the other app loads in a
minimized view (not fully minimized, but it shows up in the bottom half of
the screen).

Is there a way to ensure that the new application will maximize when called?

I wanted to use FollowHyperlink since the document may be of a variety of
formats (PDF, Excel, Word, PPT, etc.)

Thanks,

Rick

 

[fredg]

I am using Application.FollowHyperlink to launch another
application/document. WHen I do so, however, the other app loads in a
minimized view (not fully minimized, but it shows up in the bottom half of
the screen).

Is there a way to ensure that the new application will maximize when called?

I wanted to use FollowHyperlink since the document may be of a variety of
formats (PDF, Excel, Word, PPT, etc.)

Thanks,

Rick

If both your application and your current form are maximized, the new
document, spreadsheet, etc. will also be maximized.

Assuming the Application window is already maximized:

' Maximize the current object
DoCmd.Maximize
Applicaton.FollowHyperlink "Path etc"

 

[Guest]

Thanks Fred - unfortunately that did not seem to work. My access application
is maximized and the form that issues the FollowHyperlink statement is also
maximized. Any other ideas?