I have a container field which can display a reference to a Word document--right click, Insert File. I would like to click a button (run a script) which would launch Word and load the document. I've tried the Send Event function but it will either launch Word without loading the document, or do nothing. I can't figure it out. Thanks in advance.

I'm working toward a similar script solution in one of my databases and would be interested in hearing a possible solution to this issue too.

Unfortunately, from all of my investigation, this sort of thing isn't possible. The only way I can find to open a container object (document, spreadsheet, etc.) is by double clicking the container field itself.

What about

Go to Field [select/perform]

Vaughan,

You're a genious. Sometimes, it's the simplest things than slip past me. That works like a charm.

Mucho thanks.

Call me stupid, but it doesn't work here.

I made a container field in my database.

I inserted a file (document.doc)

It appears in the containerfield with a Word icon.

If I doubleclick the field, nothing happens.

Made a button.

Attached functions "Go to field[select/perform]" to the button.

Back to browse mode: click the button.. the document is not opened in Word. The only thing happening is that the containerfield gets the focus (so "select" works ok.)

Any ideas? Thanks in advance...

You need to have the document stored as a reference to a file.

[strangely, with IWP, you need to have the file internally stored to open the document over the web.]

I have the full document stored in the container as well. In my case, it's an MSC file (Microsoft Management Console) for a server information database.

The scripted opening method works as well as double clicking the container.

Now, I stored the document by simply dragging and dropping it from the desktop into the container field. I did not copy/paste it into the container. Maybe that has something to do with it.