Hi All,
Hoping someone can help with following prob...
I'm not necessarily new to access but am new to VBA and simply CANNOT get my head round a particular line of code.
I'll explain:
- I have a link that should, when clicked, minimise the active form ( a dialog box w/dropdown ) and launch an external, pre-saved MSWord doc.
Am writing it as follows:

DoCmd.Minimize
Shell ("D:\IT\Display Outlets 2004\merge4access.doc")

...Is it me or am I just not writing this properly? The result is the standard debug/end error popup.
I then typed w/out the preceding 'DoCmd' - this was also unsuccessful.
Every example of the shell command I've looked at is written like this. What am I doing wrong?
Thanks...

I suspect that you need to add the path to the Word program as well:

i.e. Shell ("C:|Program Files\.....\Word.exe" "D:\IT\Display Outlets 2004\merge4access.doc")

Cheers Ray

Hi,
Thanks for your response but I still don't know how to write this line.
It's asking for a separator.
How do I differentiate between the path to the app, THEN the path to the file?
Confused.
Thanks again!

Have you tried putting a space between the program and file/path like this?

Shell ("C:\Program Files\.....\Word.exe D:\IT\Display Outlets 2004\merge4access.doc")

Hi,

   I am not sure what part of this you are having a problem with still. I wrote this code sample and it does the following:
Minimizes the FORM, not Access
Opens Windows Explorer to the link specified.

Maybe your answer is somewhere here...

Private Sub btn0_Click()

    Dim objExplorer
    Dim stLink As String

    stLink = "http://www.msn.com"

    DoCmd.Minimize

    Set objExplorer = CreateObject("InternetExplorer.Application")
        objExplorer.Navigate stLink
        objExplorer.Fullscreen = True
        objExplorer.Visible = 1

End Sub

 I think you need to create an instance of Word. I think you need the object model for Word. I only have the model for IE.

P.S. Omit the Full Screen command since it opens IE and hides the taskbar, menus and close button.
P.P.S. It is not a shell script, that is only used in cmd.exe (e.g. batch files) so don't use shell command references. If this is not a VBA question, then seek the more pertinent forum.:D



mmcdonal