Controlling RUMBA 3270 Session from MS Access

Posted on 2008-02-05
Medium Priority
Last Modified: 2013-11-27
Hi, I have been trying to Control and Screen Scrape a Rumba 3270 Session from a MS Access Form using the ObjectXMFDisplay Control Object.

I've had some limited success:
   Connecting and disconnecting the session using .Connect and .Disconnect.
   Sending keystrokes into the session using .SendKeys  
and retreiving screen text using .GetScreen2

My problem is getting my VB code to wait when I've sent and enter keystroke  - @E - for the next screen to be ready.  I've written some code that forces a pause for a second or two after each Enter Key, which sort of works, but there must be a better way.  Any suggestions?  Thanks
Question by:greep
LVL 27

Expert Comment

ID: 20823923
There's discussion of this and VB code samples (not Access specific) here: http://supportweb.netmanage.com/ts_rumba/solution/pdf/Tools/3601.pdf
LVL 50

Accepted Solution

Lowfatspread earned 1500 total points
ID: 20981967
its been a while since i wrote/worked with a scraper..

but i believe you have 2  basic choices...
1)  have a pause as you suggest
2)  identify a unique area per screen which identifies each "page" returned
     and loop checking it ...


Expert Comment

ID: 23248911
greep I am stuck working on a project that requires connecting to Rumba and was wondering if you might be able to provide any insight on this.  Did you ever get the results you were after?

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Implementing simple internal controls in the Microsoft Access application.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question