So I have been slowly creating a database to make my users input their time in a report and it currently askes them if they have entered it in a special program. I am having a problem when they answer no it will not open the program. I have this all in VBA format currently and can not for the life of me find a code that will work to open the file currently it looks like this:
Private Sub Add_Click()
Dim Response As Integer
Response = MsgBox("Did you add this in Vista?", vbYesNo + vbQuestion, "Enter in Vista?")
If Response = vbNo Then
'User answered "No"
Else
'User answered "Yes"
DoCmd.RunMacro "AddNew"
End If
End Sub
I want to enter something under no for it to open this program...maybe have it open the .bat file I have for it....but i dont know how!! HELP!:banghead:
Private Sub Add_Click()
Dim Response As Integer
Response = MsgBox("Did you add this in Vista?", vbYesNo + vbQuestion, "Enter in Vista?")
If Response = vbNo Then
'User answered "No"
Else
'User answered "Yes"
DoCmd.RunMacro "AddNew"
End If
End Sub
I want to enter something under no for it to open this program...maybe have it open the .bat file I have for it....but i dont know how!! HELP!:banghead: