Opening another Access Database file with VBA

V

VWP1

I am in one of my Access database files, and wish to use a command button to
open another database file. How is this done?
 
T

Tom van Stiphout

On Sat, 9 Jan 2010 21:00:01 -0800, VWP1

There are several ways. Perhaps the simplest is using the Shell
function. Check the help file.

-Tom.
Microsoft Access MVP
 
F

fredg

I am in one of my Access database files, and wish to use a command button to
open another database file. How is this done?
Click to expand...

Here is one method:
Application.FollowHyperlink "c:\PathToDatabaseFolder\MyDatabase.mdb"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening Another Access Database onClick 8
Calling Access 'form' from other applications 0
How To Open Another Database from my Application? 4
Access Importing csv daily files into access 2007 1
Access Command to run access, open to specific form and specific record 1
Transferring Control From One Database To Another Using Access 2007 Runtime 2
Opening an Access db within vba 1
Import multiple forms, queries from another database 1

Top