If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open another db from VBA
I have a tracking database in MSAccess which runs nicely.
Now I wish to launch this from within another MSAccess database in response to a button click (using VBA, I guess). - ideally, the first db would close itself after opening the tracker - I experimentated with various code, best was Application.FollowHyperlink ("filename"), but I am not sure how stable the thing is, or what problems this might create. - Should this come before or after DoCmd.Close ? |
#2
|
|||
|
|||
Open another db from VBA
On Wed, 13 Aug 2008 07:32:00 -0700, David C wrote:
I have a tracking database in MSAccess which runs nicely. Now I wish to launch this from within another MSAccess database in response to a button click (using VBA, I guess). - ideally, the first db would close itself after opening the tracker - I experimentated with various code, best was Application.FollowHyperlink ("filename"), but I am not sure how stable the thing is, or what problems this might create. - Should this come before or after DoCmd.Close ? What does this question have to do with TableDesign, the topic of this newsgroup? Application.FollowHyperlink "c:\YourFolder\YourDatabase.mdb" DoCmd.Quit -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
Open another db from VBA
Thanks Fred
{A little aggressive there?} I posted this, I thought, to the MSAccess Database design group, which is where the header says it resides. If you cannot help, please advise me where best to seek answers. "fredg" wrote: On Wed, 13 Aug 2008 07:32:00 -0700, David C wrote: I have a tracking database in MSAccess which runs nicely. Now I wish to launch this from within another MSAccess database in response to a button click (using VBA, I guess). - ideally, the first db would close itself after opening the tracker - I experimentated with various code, best was Application.FollowHyperlink ("filename"), but I am not sure how stable the thing is, or what problems this might create. - Should this come before or after DoCmd.Close ? What does this question have to do with TableDesign, the topic of this newsgroup? Application.FollowHyperlink "c:\YourFolder\YourDatabase.mdb" DoCmd.Quit -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
Open another db from VBA
On Thu, 14 Aug 2008 00:06:01 -0700, David C wrote:
Thanks Fred {A little aggressive there?} I posted this, I thought, to the MSAccess Database design group, which is where the header says it resides. If you cannot help, please advise me where best to seek answers. "fredg" wrote: On Wed, 13 Aug 2008 07:32:00 -0700, David C wrote: I have a tracking database in MSAccess which runs nicely. Now I wish to launch this from within another MSAccess database in response to a button click (using VBA, I guess). - ideally, the first db would close itself after opening the tracker - I experimentated with various code, best was Application.FollowHyperlink ("filename"), but I am not sure how stable the thing is, or what problems this might create. - Should this come before or after DoCmd.Close ? What does this question have to do with TableDesign, the topic of this newsgroup? Application.FollowHyperlink "c:\YourFolder\YourDatabase.mdb" DoCmd.Quit -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail I did help. I gave you the answer... Application. FolowHyperlink followed by DoCmd.Quit. Your topic has to do with VBA and would have better been posted in either microsoft.public.access.formscoding or microsoft.public.access.modulescoding or microsoft.public.access.modulesdaovba I wasn't, and am not now, being 'aggressive'. Our time is valuable, just as yours is. I think it makes sense to have your question (and it's answer) placed where it will be seen by others with a similar problem, so that we will not have to soon re-answer the same question for some one else. That's why there are so many different Access newsgroups. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|