Accessing Access

S

shannondbaker

Board Regular
Joined
Sep 25, 2003
Messages
121
I would like to find a code that not only opens up access from Excel's VB, but specifically opens up a certain form or query. I'm using the shell comand to open up access at this time, but don't know what commands to use to go further. In addition, as an fyi, in case needed, I have linked onto the reference for Access in vb.

Shannon
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
Sort by date Sort by votes
The Or. Its actually just acting more like a link for a sheet. It will do nothing more than open up access and one of the forms or queries within. Once opened, the user will decide what to do with the form (enter data, look at results, etc.)

Shannon
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Querying access db from excel - 32 bit to 64 bit conversion
Replies
2
Views
596
JEC
JEC
S
  • Solved
Can't open Excel XLSM file due to recent VBA Reference failing
2
Replies
16
Views
1K
SixSigmaGuy
S
pcc
  • Solved
Conversion of special characters
Replies
6
Views
674
JEC
JEC
T
  • Question
VBA PDF Print
Replies
2
Views
802
Fluff
Fluff
AndyTampa
  • Solved
Limit Quick Tasks macro to a specific worksheet
Replies
4
Views
289
mumps
mumps

Forum statistics

Threads
1,221,683
Messages
6,161,264
Members
451,692
Latest member
jmaskin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top