[AccessD] Doc Merge from Access

Bill Marriott bill.marriott09 at gmail.com
Mon Oct 4 03:05:56 CDT 2010


Yes Charlotte I  tried that to no avail.
I ran the debugger and there did not appear to be any more code running in
Access after the DoCmd.RunCommand acCmdAppMinimize
However Access keeps popping up in my face like a recalcitrant Jack in the
Box when it should stay minimized?

Bill

On Mon, Oct 4, 2010 at 3:52 AM, Charlotte Foust
<charlotte.foust at gmail.com>wrote:

> Just as SWAG but I suspect the problem is that when you click on the
> Word Doc, the Access window is no longer the active window, so you're
> spinning your wheels.  Have you tried using the RunCommand to minimize
> before you follow the link (which I presume is to the Word doc)?
>
> Charlotte Foust
>
> On Sat, Oct 2, 2010 at 7:13 PM, Bill Marriott <bill.marriott09 at gmail.com>
> wrote:
> >>
> >> 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
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



More information about the AccessD mailing list