Button in form to open Windows Calculator

[Aosmond]

Hello,


I would like to know how to create a button in form to open the windows calculator. I have MS Access 2003, and running Window XP.

Thank you

Adam

[orange]

see
http://blogannath.blogspot.com/2011/...s-opening.html

[alansidman]

I am running on a WIN7 machine. You may have to change the path for wherever your calculator is located.
Put this in the on click event for a command button

Private Sub Command0_Click()
Dim RetVal
RetVal = Shell("C:\windows\system32\calc.exe", 1)
End Sub

edit: Jack types quicker than me.

[Aosmond]

Thank you.

I am running on a WIN7 machine. You may have to change the path for wherever your calculator is located.
Put this in the on click event for a command button

Private Sub Command0_Click()
Dim RetVal
RetVal = Shell("C:\windows\system32\calc.exe", 1)
End Sub

edit: Jack types quicker than me.

[Aosmond]

I used the code below for a button on a form to open Window calculator, but it did not work in my Window XP Access 2003, but the same code worked in my Window 7 Access 2010. What am I doing wrong. I checked the path of the calculator in the XP and it is C:\windows\system32\calc.exe


Private Sub Command0_Click()Dim RetValRetVal = Shell("C:\windows\system32\calc.exe", 1)End Sub

[June7]

The code works in Access 2007 under Windows XP Version 5.1 SP3.