CreganTur
10-27-2008, 07:16 AM
One of my databases houses a lot of automation that uses Attachmate X-Treme to emulate some 3270 terminals that the company I work for uses. I use VBA to automate data retrieval and entry tasks. All of that works perfectly.
The issue is that when my forms load a MsgBox appears asking the User if they want Attachmate launched. In Word I can use 'If Not Tasks.Exists("SESSION2 - EXTRA! X-treme") Then' to detect if Attachmate is not currently open, that way the MsgBox only appears if the session of Attachmate isn't already open.
The problem is that Access does not support this functionality (Tasks.Exists). I know that I could just set a reference to the Word object library, but that seems like a waste of resources to me. Is there a similar method in Access?
The issue is that when my forms load a MsgBox appears asking the User if they want Attachmate launched. In Word I can use 'If Not Tasks.Exists("SESSION2 - EXTRA! X-treme") Then' to detect if Attachmate is not currently open, that way the MsgBox only appears if the session of Attachmate isn't already open.
The problem is that Access does not support this functionality (Tasks.Exists). I know that I could just set a reference to the Word object library, but that seems like a waste of resources to me. Is there a similar method in Access?