Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-17-2014, 10:28 AM   #1
MandiC
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"

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!

MandiC is offline   Reply With Quote
Old 04-17-2014, 10:52 AM   #2
MandiC
Newly Registered User
 
Join Date: Apr 2014
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
MandiC is on a distinguished road
Re: Button to open .r2w or a .bat file

Found an answer with a great thread that I can't even post on here yet
MandiC is offline   Reply With Quote
Reply

Tags
button , form access , vba

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
button to open file path unclefink General 1 07-22-2012 07:11 PM
Need button to open HTML FAQ file eepok General 1 11-08-2007 11:40 AM
Open A File Using Command Button Daryl Modules & VBA 1 09-06-2006 12:05 PM
Help with a command button to open a file ladivapr Forms 2 02-13-2004 08:56 AM
Open excel file using button CraigBFG Forms 4 11-19-2003 10:23 AM




All times are GMT -8. The time now is 12:27 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World