[AccessD] minimize wont stay minimized

Bill Marriott bill.marriott09 at gmail.com
Sun Oct 3 01:12:24 CDT 2010


>
> Hi Group,
>

I am running Access 2010 on Win 7
I would like the user to click on a hyperlink in an access form to open the
appropriate app (eg Word) with the correct file and have the Access
application minimized while the user views the hyperlinked file.

The following code works but after minimizing the Access App' for only a
second and opening up Word with the correct file Access opens up again on
top.

Private Sub txtCV_Click()
  If Not IsNull(Me.txtCV) Then
    'ActiveWindow.WindowState = wdWindowStateMinimise  'tried this and
    FollowHyperlink Me![txtCV], , True
   DoCmd.RunCommand acCmdAppMinimize                      'tried this as
well
  End If
End Sub

Does anyone know why?

thanks

Bill



More information about the AccessD mailing list