thanks for the prompt reply.
At this point I am willing to try anything, but does this setting need to be added to the "Target" databases? That adds a complication due to the sheer number. I was hoping for a solution that would involve manipulating the automation system code only.
there are probably many better ways to do this, but the way I solve this issue is:
1) create a query that will display the related information you want to display - use the combo box as the criteria in the query.
2) create text boxes whose control source is the query fields made above.
3) Use...
Ok my issue:
I have an automation system built on VBA code that opens various access databases and performs updating macros/procedures in each. It does this at 5am so my user group will have updated info when their day starts. My problem is most of these target databases have linked ODBC tables...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.