View Single Post
Old 04-17-2014, 10:28 AM   #1
Newly Registered User
Join Date: Apr 2014
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
MandiC is on a distinguished road
Exclamation Button to open .r2w or a .bat file

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"

'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!

MandiC is offline   Reply With Quote