Hi All.
I have taken over a database which the code was written for many years ago.
One of the forms contains 2 buttons that open a .exe file. One button opens the .exe that is stored on the user's home drive, and the other opens the .exe that is stored on their C: Drive. Around 4 weeks ago, the buttons stopped working for some users, and have slowly started to affect everybody. I imagine that some updates performed by our IT Department have caused this issue. I have had a similar issue in the past when they have issued a new version of Adobe's PDF Reader, and the .exe file name has changed. However the file location or name have definitely not changed.
When opening the home drive .exe I get the following error:
The expression On Click you entered as the event property setting produced the following error: Invalid procedure call or argument
The code that is behind the home drive button is:
Rem On Error GoTo Err_CommandQA90Home_Click
Dim stAppName As String
Dim stHomepath As String
stHomepath = CurDir
Rem stAppName = stHomepath & "\QA90PRO32\Qa90pro.exe"
stAppName = "H:\QA90PRO32\Qa90pro.exe"
Call Shell(stAppName, 1)
Exit_CommandQA90Home_Click:
Exit Sub
Err_CommandQA90Home_Click:
MsgBox Err.Description
Resume Exit_CommandQA90Home_Click
Does anybody have any tips as to why these errors may be occurring?
Thanks
I have taken over a database which the code was written for many years ago.
One of the forms contains 2 buttons that open a .exe file. One button opens the .exe that is stored on the user's home drive, and the other opens the .exe that is stored on their C: Drive. Around 4 weeks ago, the buttons stopped working for some users, and have slowly started to affect everybody. I imagine that some updates performed by our IT Department have caused this issue. I have had a similar issue in the past when they have issued a new version of Adobe's PDF Reader, and the .exe file name has changed. However the file location or name have definitely not changed.
When opening the home drive .exe I get the following error:
The expression On Click you entered as the event property setting produced the following error: Invalid procedure call or argument
The code that is behind the home drive button is:
Rem On Error GoTo Err_CommandQA90Home_Click
Dim stAppName As String
Dim stHomepath As String
stHomepath = CurDir
Rem stAppName = stHomepath & "\QA90PRO32\Qa90pro.exe"
stAppName = "H:\QA90PRO32\Qa90pro.exe"
Call Shell(stAppName, 1)
Exit_CommandQA90Home_Click:
Exit Sub
Err_CommandQA90Home_Click:
MsgBox Err.Description
Resume Exit_CommandQA90Home_Click
Does anybody have any tips as to why these errors may be occurring?
Thanks