Prevent Access from minimizing when open a document from the HyperLink field type

[Dmitri Shvetsov]

Hi All,

Does somebody know about this problem?

We create a new table with a Hypelink field type, then enter a link to a
WinWord document in this table cell. When we click at this document it
should be opened and we can edit it, etc. The problem is that when we open
the document from clicking at this link the Access current window gets
minimized and we need to find it on the Taskbar and open again and again.
Imagine if we're having few thousands of documents...(((

How can we prevent this Access from Minimizing when we open a document from
the HyperLink field type?

Dmitri.

 

[Van T. Dinh]

My Access 2002 is *not* minimized when I open a Hyperlinked doc from Access.

OTOH, you should only have a few docs open at any time. You can also use
Alt + Tab to switch windows fairly quickly.

 

[Peter Hoyle]

How can we prevent this Access from Minimizing when we open a document
from

the HyperLink field type?

Hi Dmitri,

The following code shouldn't work but it does on my machine!

Private Sub ctlHyperlink_Click()
DoCmd.MoveSize 0, 0
End Sub

Someone may be able to advise why it shouldn't be used,

Cheers,
Peter