#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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.
|
Tags |
acccess, button, toolbar |
|
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 |