aunching another database from within a database.

[martinreed]

Hi everyone,
I have a series of unrelated access databases and I would like to have one 'super menu' where i can click a button to go to different databases.
I'm no VBA expert so would appreciate a 'answer for a dummy' reply.


Thanks

[Ruegen]

Hi everyone,
I have a series of unrelated access databases and I would like to have one 'super menu' where i can click a button to go to different databases.
I'm no VBA expert so would appreciate a 'answer for a dummy' reply.
Thanks

What's the general purpose?

Are you working on one database and then closing it and then opening a totally different business/database?

[Ruegen]

I believe you would need to use Application Object.

Ideally you are asking via VBA to create an object (that being Access) and use it to run the set task.

So make object A = Access program

then tell A what to do (you don't actually type this - I am giving a basic example to help you understand).

To read on this

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

just guessing here because I have never tried it but

I would:

1. make a string to store the name of the path where the database file is.
2. create an object
3. have it open to a form

so

dim strPathOfData as string 'text of the path will be a string

Dim appAccess As Access.Application 'this will be telling what appAccess will be in this case - access 

strPathOfData = c:/filelocation/databasefile.accdb 'telling what the string will be - get your file path (a place where the file will never move from)

appAccess.NewCurrentDatabase strPathOfData 'one of the the possible processes you can use - in this case you are asking the application Access  *which is appAccess to .NewCurrentDatabase - open string path.

Might not work if you just paste it but that is how I guess it would work.

[June7]

What do you mean by 'go to'? Do you just want to open another Access file? Are these other dbs all-in-one (tables and forms, etc.)? Or do you want to link to tables in other Access file?