Sorry Larry
I try to make my questions simple, yet thorough, that a message isn't
needed. Brevity you know. But the folks inthe group are opening the
posts anyway, I may as well use the white space. Point taken.
Anyway, I've already got the hyperlink method working, with a button.
Works fine. And while this does work, and it is simple to do, I was
looking for a way to do it elegantly (i.e. more work; but this is a
way for me to learn VBA as well).
Anyway, I have a need, while the user is entering/viewing data in a
form, to have, on that form, a cbo with a series of "document" names
(they may be Word, Powerpoint,graphics, excel, inhouse apps). Choosing
the document name brings the document up in a associated window (a
subform). All the app formats in question are part of a company-wide
install, they should be installed. In my business, data are
frequently photomicrographs, DNA sequence maps, Word documents of SOPs
and ISO9000 Procedures and Work Instructions, iGrafx flowcharts; not
that I intend to use all of these file formats in this way, but as way
of example.
It not as elegant to open an entirely new window for the document, as
that detracts from the immediacy of viewing the structured data in one
subform, and the unstructured data in the other form. One thing I
wonder about is that the subform window might be so small that the
document would not be able to be viewed effectively anyway.
How does Access handle two monitors?
Maybe one could view structured data in a form/subform, click on a
hyperlink to a document, and open the latter in a window in the other
monitor...hmmm. Interesting idea ! Many of use have two monitors per
machine because of the work we do.
Jerry
In every newsreader I've used, there's been this large area of white space
for posting your inquiry. It's a really good idea to use it instead of
putting your question in the Subject -- that almost always means you have
shortened it too much, and some news readers may not display it in full.
You can use a Bound OLE Frame to embed an Excel Spreadsheet (the user will
have to have Excel installed) or you can use the SHELL function to start up
Excel or you can hyperlink to the Spreadsheet. Thus, strictly speaking, you
cannot just open an XLS file as a subform, you can work with an XLS file
from Access.