rescheduling Shop Orders - VBA

[fabyouless]

As a technical user, i am instructed to make no direct changes to the tables in Macola. I'm using VBA to populate Shop Order information in the Shop Floor Order Entry screen and using SENDKEYS to "click" the Reschedule button. By doing so, i only have to push the spacebar once to acknowledge the "Scheduling Complete" message box for each Shop Order.

The question is, while i'm pulling the information from an Access form, is there a way to programmatically acknowledge the popup? Is there a better way to reschedule a batch of Shop Orders?

Thanks,
BLS

 

[fabyouless]

I've been scouring what i think are relevant forums for an answer. Please pardon me if i've posted in the wrong forum. If so, please also tell me which is the more appropriate place to find an answer.

I have other questions along the same lines and want to be in the right place and in everybody's good favor. Thanks for any direction.
BLS

 

[abaldwin]

I would have to say that NO there is not a better way given your criteria.

If I was to try and do this I would write the complete reschedule process in VBA (access I assume) and test it completely in a test environment to get it approved for use.


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.