Thread: [Solved] Making a button to open an Access Dbase
View Single Post
 
Old 04-07-2010, 07:34 AM
aubreylc aubreylc is offline Windows 7 Office 2007
Novice
  
Join Date: Apr 2010
Posts: 2
aubreylc is on a distinguished road
Default Making a button to open an Access Dbase
I made a button in my Outlook toolbar that will open an Access Dbase.The code works, but is there an alternative way to only open the file -any file for that matter- as apposed to first running the Access application and then pointing to the file I want, like the following VBA suggests?

Code:
Sub newmac()
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.Visible = True
appAccess.Application.OpenCurrentDatabase ("T:\MaterialsManagement\VendorQA\RevisedORderIssues3_16_10.accdb")
 
End Sub
Reply With Quote