Flex - VBA only

[kbieber]

I am trying to add a simple check box to a Macola screen (PO Line Item). One of the properties of the checkbox is that it is VBA only, which apparently means, among other things, that the tab order of the screen is now screwed up. When I change the value of the checkbox and press enter to save, the cursor moves to the OK box in the upper left of the screen instead of to the line item box. I have to tab twice to get the cursor back to the line item box, where the update routine occurs (because the post save event doesn't work, but that's another story). I've tried to change the tab order of the screen, but because the checkbox is VBA only, it cannot be included in the tab ordering function of the screen designer. This should be a ten-minute change, but I've got several hours into it, trying to figure out to make this work. Any ideas?

 

[vbajock]

I tried to look at this for you, but I ended up confused by a couple of things. Did you say the check box was added to the PO line item screen ? I don't seem to have access to the Po line item screen from the screen designer or Flex, although I do have it on the initial header screen.

 

[dgillz]

Vbajock-

PO0111 is the screenset you need, you have to go to the screen designer in System Manager to design this screen, you cannot do it from the Macola menu option of enter Purchase Orders.

However, I just played with this for a few minutes and I cannot get this to work either. I have asked Macola tech Support for a resolution, I suspect there is none. I will keep you posted.


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[vbajock]

I hope they can help you. If you can't get at the underlying code module for the screen, it is going to give you a major problem, because the cure for what you are describing is to kick off a field.setfocus to the line item field from the checkbox change event. Let me know how it works out.

 

[kbieber]

I probably should have been more specific in my original post. This was attempted through screen designer using PO0111. Right-clicking on the screen area displays a pop-up window. Select Special, then Add a Check Box. I positioned the check box on the 4th line of the form, between ratio and vendor item fields. When the checkbox is modified, pressing enter will take the cursor to the OK box in the upper left. Thank you.

 

[kbieber]

Forgot to mention, I did try to initiate the field.setfocus from the macform_save event to the line item field and it did not work.

 

[kbieber]

As so often happens, I thought of the answer while typing my replies to the thread. vbajock mentioned it - use a setfocus to another field from the click event of the check box. It still doesn't allow the user to tab directly to the checkbox, they will have to click on it with the mouse. Not the best solution, but it will do for now. Thanks for the help everyone.

 

[vbajock]

As far as I know, in the "macform" Macola VBA does not give you access to tab order properties and does not allow setting a control tab stop to true or false. All of this has to be done in VBA by got/set focus coding. As I have said before, Mac VBA is very limited compared to other ERP VBA implementations when it comes to exposing events or properties of Macola itself.