Hi Everyone,
I've only been using Access for a little while now, and until last week I had an Access guru sitting beside me who would just do anything that I struggled with (but didnt teach me anything
).
Now he's gone and I'm struggling
Basically, I have a table with 2 columns which need to be inserted into the following script until it reaches the end of the list. This is a script for an AS400 mainframe system.
FunctionKey (CLEAR)
WaitFor (UNLOCK)
WaitForCursorPos (12, 33)
TypeString
("***CELL A1***")
FunctionKey (ENTER)
WaitFor (UNLOCK)
WaitForCursorPos (22, 20)
TypeString ("479")
FunctionKey (ENTER)
WaitFor (UNLOCK)
WaitForCursorPos (8, 17)
TypeString
("***CELL B1***")
FunctionKey (ENTER)
WaitFor (UNLOCK)
WaitForCursorPos (15, 46)
FunctionKey (ENTER)
WaitFor (UNLOCK)
So, once it has done this, I would want it to do Cell A2 and Cell B2, and repeat itself until it reaches the end of the list.
I wouldn't even know where to start searching on the forum (I have tried), so if someone could point me in the right direction I'd be eternally greatful.
Cheers,
Earthmover.