Hi Guys' help!!!
I ma having trouble trying to work this out when it should be simple !!!!, i have similar working ok on another db, can't get this one working though
on my PC my Google Chrome path is in Program Files (x86)
ON another PC Google Chrome isn't in the same path so when i change Front end DB to the other machine, it won't work unless the correct path is located, this is what i have but debugging on bold line
Code:
Dim stAppName As String, myURL As String, OpenChrome As String, myApp As StringDim stPathName As String
OpenChrome = """C:\Program Files\Google\Chrome\Application\chrome.exe"""
stFilePath = "https://onedrive.etc etc..........."
If Len(Dir(OpenChrome, vbDirectory)) = 0 Then
OpenChrome = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""
End If
Shell (OpenChrome & stFilePath)