Open access file with button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I sued the buttong wizard to build this code. I'm trying to open another
access file by having the user click a button on a form.

When i try it I get this message.
"Ivalid procedure call or argument"


Dim stAppName As String

stAppName = "M:\Reports 2006.mdb"
Call Shell(stAppName, 1)
--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003
 
I found the answer in another post



Private Sub Command1_Click()
Shell """C:\Program Files\Office2K2\Office10\MSAccess.exe"" " & _
"""D:\AccessTests\A2K2_MyTest\Test01.mdb""", vbNormalNoFocus
End Sub



--
Billy Rogers

Dallas,TX

Currently Using SQL Server 2000, Office 2000 and Office 2003
 
Back
Top