charlie_301
asked on
Open second Access database from within first.
We use Access 2010 to run a database containing customer orders created by our sales staff. Some of the customer information is also used in a second database for a different purpose.
I would like to provide a command button, or similar, on the customer order form which would launch the second database and open the appropriate form, pre-populated with the customer details from the first form.
I appreciate that the easiest solution would be to merge the two databases, but there are a number of reasons why they are best kept separate.
I've managed the first step. A command button runs an append query which imports the relevant information to the second database. Is it possible or advisable to extend the VB code behind the command button to launch the second application and open the form?
Any advice would be much appreciated.
I would like to provide a command button, or similar, on the customer order form which would launch the second database and open the appropriate form, pre-populated with the customer details from the first form.
I appreciate that the easiest solution would be to merge the two databases, but there are a number of reasons why they are best kept separate.
I've managed the first step. A command button runs an append query which imports the relevant information to the second database. Is it possible or advisable to extend the VB code behind the command button to launch the second application and open the form?
Any advice would be much appreciated.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be deleted for the following reason:
old question
old question
"old question"
Do you mean it's no longer a question for you and you've moved on? was anything here helpful?
I ask only as a way of pointing out that you will only get the full benefit from EE if you, just as much as the experts, work at a question.
Everyone gets busy or sometimes a problem just goes away, but you asked a question and got three responses. Coming back a month later and asking for a delete with "old question", doesn't help anyone.
Jim.
Do you mean it's no longer a question for you and you've moved on? was anything here helpful?
I ask only as a way of pointing out that you will only get the full benefit from EE if you, just as much as the experts, work at a question.
Everyone gets busy or sometimes a problem just goes away, but you asked a question and got three responses. Coming back a month later and asking for a delete with "old question", doesn't help anyone.
Jim.
I'm objecting to this, since you were presented several methods to do what you were asked. In specific, https://www.experts-exchange.com/questions/27836764/Open-second-Access-database-from-within-first.html?anchorAnswerId=38319154#a38319154 was a valid solution, and https://www.experts-exchange.com/questions/27836764/Open-second-Access-database-from-within-first.html?anchorAnswerId=38317115#a38317115 and https://www.experts-exchange.com/questions/27836764/Open-second-Access-database-from-within-first.html?anchorAnswerId=38317304#a38317304 were also valid.
And you obviously took this action to remove the automated question lock, since you immediately asked this new question:
https://www.experts-exchange.com/questions/28521724/Review-of-receive-connector's-settings.html
And you obviously took this action to remove the automated question lock, since you immediately asked this new question:
https://www.experts-exchange.com/questions/28521724/Review-of-receive-connector's-settings.html
ASKER