Hi,
I have two applications: 1) a MS Access database with lots of forms and VBA and 2) a VB6 application that interacts with hardware and sends the data to the Access database. Currently, I only interact with the Access database from the VB6 app, but based on certain criteria, I would like to select an option in a dropdown menu in the VB6 application from the Access database using VBA. Is it possible to interact with a VB6 application from the Access database and if so, any pointers on how to do this? The VB6 application is called "Hardware_Interface.exe", the dropdown I want to manipulate is called "Type", and the value I want to select in the dropdown is "Gear 1".
Thank you
I have two applications: 1) a MS Access database with lots of forms and VBA and 2) a VB6 application that interacts with hardware and sends the data to the Access database. Currently, I only interact with the Access database from the VB6 app, but based on certain criteria, I would like to select an option in a dropdown menu in the VB6 application from the Access database using VBA. Is it possible to interact with a VB6 application from the Access database and if so, any pointers on how to do this? The VB6 application is called "Hardware_Interface.exe", the dropdown I want to manipulate is called "Type", and the value I want to select in the dropdown is "Gear 1".
Thank you
