Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2010, 07:34 AM
aubreylc aubreylc is offline Making a button to open an Access Dbase Windows 7 Making a button to open an Access Dbase Office 2007
Novice
Making a button to open an Access Dbase
 
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
  #2  
Old 04-07-2010, 11:37 AM
CGM3 CGM3 is offline Making a button to open an Access Dbase Windows XP Making a button to open an Access Dbase Office 2003
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

You can create an icon on your desktop that targets an Access database file. As the file type is associated with the MS Access application, clicking on the icon launches Access and opens that database in one step.

As a quick-and-dirty alternative, find the file you want to open with Windows Explorer and double click on it. That also launches the associated application (Word, Access, Excel, etc) and opens the file.
Reply With Quote
  #3  
Old 04-07-2010, 12:53 PM
aubreylc aubreylc is offline Making a button to open an Access Dbase Windows 7 Making a button to open an Access Dbase Office 2007
Novice
Making a button to open an Access Dbase
 
Join Date: Apr 2010
Posts: 2
aubreylc is on a distinguished road
Default

When you have to train 20 cs reps a month and trying to get them to go to this icon, go to that icon, click here for this, click there for that, it becomes cumbersome. I have a prebuilt toolbar for all reps, and like I mentioned earlier, The code above works fine. I was just wondering if there is an alternative "VBA" method.
Reply With Quote
Reply

Tags
acccess, button, toolbar

Thread Tools
Display Modes


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
Making a button to open an Access Dbase 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft