Bill Marriott
bill.marriott09 at gmail.com
Sat Oct 2 21:13:54 CDT 2010
> > Hi Group, > I am running Access 2010 on Win 7 I would like the user to click on a hyperlink to open the appropriate app with the correct file and have the Access minimized while the user can view 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