Announcements
55
Im running a macro to update inventory in our system
its over 300 lines its getting stuck by row number 39 because the window need to scroll is there any way to make the window should scroll down
I don't know SQL just regular macros in GP I think its GP 2010
Thanks
*This post is locked for comments
Thanks Leslie Vail
it worked
You can absolutely use the macro language to scroll the window down. If you have 39 records visible, someone must have increased the height of the window.
On my system, the default number of records displayed is five (I expanded the rows to display both lines of the record). Given these assumptions, my macro will only be able to refer to records 1 through 5 and then it will need to scroll down to display the next line. In this scenario, each newly exposed line will still be record 5. For example, when you finish populating the 4th record, the following code will be included in your macro to advance to record 5:
TransLinePrepare scrollwin 'IV_Transaction_Scroll'
When you get to line 5 (the last record displayed) you will need to scroll down to display the next record. This new record will also be record 5, but to get the window to scroll down, you would need to include code such as this:
TransLinePrepare scrollwin 'IV_Transaction_Scroll'
ScrollByLine down scrollwin 'IV_Transaction_Scroll'
The secret is to include the words " ScrollByLine down scrollwin 'IV_Transaction_Scroll' " in order to bring a new record into the scrolling window.
Kind regards,
Leslie
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
