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