Is there a way of opening a second database using VBA from within the first database? Thanks
R RevJeff Registered User. Local time Today, 01:01 Joined Sep 18, 2002 Messages 125 Jul 9, 2020 #1 Is there a way of opening a second database using VBA from within the first database? Thanks
June7 AWF VIP Local time Yesterday, 21:01 Joined Mar 9, 2014 Messages 5,471 Jul 9, 2020 #2 Yes. Do you want to open it and let user have control or do you want code to do something with the db then close it?
Yes. Do you want to open it and let user have control or do you want code to do something with the db then close it?
R RevJeff Registered User. Local time Today, 01:01 Joined Sep 18, 2002 Messages 125 Jul 9, 2020 #3 June7 said: Yes. Do you want to open it and let user have control or do you want code to do something with the db then close it? Click to expand... Just open it and let the user have control.
June7 said: Yes. Do you want to open it and let user have control or do you want code to do something with the db then close it? Click to expand... Just open it and let the user have control.
June7 AWF VIP Local time Yesterday, 21:01 Joined Mar 9, 2014 Messages 5,471 Jul 9, 2020 #4 You want either FollowHyperlink or Shell. Review and pick one https://www.devhut.net/2018/01/21/ms-access-vba-open-another-database/
You want either FollowHyperlink or Shell. Review and pick one https://www.devhut.net/2018/01/21/ms-access-vba-open-another-database/
Isaac Lifelong Learner Local time Yesterday, 22:01 Joined Mar 14, 2017 Messages 8,777 Jul 9, 2020 #5 Also to open the database using a new Access instance: Code:Copy to clipboard dim AccessApp as Access.Application set AccessApp = createobject("Access.Application") AccessApp.OpenCurrentDatabase "path to access database file"
Also to open the database using a new Access instance: Code:Copy to clipboard dim AccessApp as Access.Application set AccessApp = createobject("Access.Application") AccessApp.OpenCurrentDatabase "path to access database file"