Making a button to open an Access Dbase

aubreylc · #1 04-07-2010, 07:34 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access 2007 Upgrade After Initial Install - Access 2003 Won't Remove	wcb	Office	1	01-25-2010 04:08 AM
Help making a coupon	mindy sue	Office	1	01-23-2010 02:23 AM
Making many documents one	shikaku	Word	0	04-07-2008 07:12 AM
Making Forms I need help!!	kellgirl	Word	0	02-09-2006 02:54 PM
print vba button in access causes program crash	de_la_espada	Office	0	09-20-2005 04:46 AM