Adding a STRING result to open an Access file in a SHELL exe Command

[sandman]

I have a Form button on an access DB, that when selected opens another Access Database using the Shell command.

This line of code works fine :

Shell ("C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.exe J:\AccessDatabase\mydatabase.accdb"),vbNormalFocus


Problem with the above its fixed and cannot change!



I want to substitute the file path as a string based on a query result. so basically "strPath" is the result of that Query

Dim strPath As String

strPath = J:\AccessDatabase\mydatabase.accdb (result of the Query)

Shell ("C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.exe """"" """ & strPath & """"), vbNormalFocus

it returns File not found


I can also get this to work using this:

'Shell "cmd.exe /c start """" """ & strPath & """", vbNormalFocus


Problem with this line is there are too many flashing screens.



Ive also tried several variations on this line and get the same problem Can anyone spot the error ?


Shell ("C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.exe """"" """ & strPath & """"), vbNormalFocus

[June7]

What do you mean by "result of the query"? How are you obtaining value for strPath?

[Welshgasman]

See if this helps
https://www.access-programmers.co.uk.../#post-1790013

[Micron]

Put your entire path in a variable then debug.print the variable to the immediate window. You should be able to spot what is wrong with your path. It might only be a missing slash, or you have spaces that need to be wrapped in quotes. That's troubleshooting 101.

When you don't put code/sql in code tags (# on forum posting toolbar) it's very hard to distinguish a whole whack of quotes like that. Plus, the forum will interject spaces after about 50 contiguous characters, then everyone is questioning spaces that don't seem to belong in what you posted.

[sandman]

June7
Im using Dlookup to get the result from the query.

Micron
Ive run it in the immediate window, all it returns is C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.exe
it completely misses anything after .exe

[sandman]

Thanks for all the input.
Suggestion from Micron was key.

I fiinally got it to run using this:

Dim strPath as string
strPath = 'using a dlookup for specific query results

Shell ("C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.exe" & " " & strPath & ""), vbNormalFocus

[Micron]

I've played with it using shell but I get a strange error re 'a switch Access doesn't recognize'. It's getting late so I must quit for now but am thinking of creating a shortcut to see if it accepts the same syntax. However, there are other ways to open an Access db that don't involve Shell. Perhaps that would be better? Your situation might be due to spaces in file path. Whenever I create files/folders I never use spaces.