VBA Shell command

[Guest]

I'm using the Shell command to open the application Adobe Acrobat from within
an Access form to display a PDF document. This works fine, except that the
program is minimised as soon as it is opened. Any ideas how I can stop
happening and see the document in a full screen?

 

[Graham Mandeno]

Hi Malc

Instead of Shell, try this:

Application.FollowHyperlink <full path to pdf file>

 

[OfficeDev18 via AccessMonster.com]

Hi, Malc,

The Shell command has a second argument, which is the WindowStyle argument.
It includes various window sizes. See the Shell Function in the Help file for
details.