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?

On Sat, 9 Jan 2010 21:00:01 -0800, VWP1
<VWP1@discussions.microsoft.com> wrote:

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

-Tom.
Microsoft Access MVP


>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?

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

> 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?

Here is one method:
Application.FollowHyperlink "c:\PathToDatabaseFolder\MyDatabase.mdb"
-- 
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail