I spent some time asking some people about my problem, and none of them had a clue what to do. So i ask my question to anyone who thinks they can answer it. First, let me fully explain what i am doing.
I have a an access database that store information. Part of this database, though, is a VB .exe file. When i click on a button in my form, the program begins to run through a series of questions. When the program has ended, it needs to return ONE peice of information to access for access to put in a form.
NOW, my question to you is this. I know i can use the shell() command to lauch the application, but i wanted to know if a VB application i built can be automated. This would enable me to lauch the application easier. Also, i could create an object in my VB code that stored this peice of information that the VB program finds, and access could get that information directly.
My other option is to write this peice of information to a text file of some sort, and let access read it. In the instance that i have to do that, do any of you have any suggestions on how to write that VBA script? My strong suit is C++, so VB is rather new to me, and i am trying to learn the language as quickly as possible.
Thank you for your time,
Christopher Timko
