×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MES FLEX -help adding search to an entryfield added to Macola screen

MES FLEX -help adding search to an entryfield added to Macola screen

MES FLEX -help adding search to an entryfield added to Macola screen

(OP)
I am working with one of our developers to add a custom field to PP0301M.  He has the code written so that when we manually enter a value it writes back to the appropriate field in the ppordhdr_sql.  However, we want to add a Macola search to the field but have not been able to do so.  Just linking the search up to the field through screen designer does not do anything.  I had him reference doc 17.513.795 in te customer portal but in the doc it states that there should be a "click event" available in the VBA where the code to call the search can be added, but he does not see this as an option for the entry field that we added.  Also, when setting the tab order of the screen the entryfield will never set focus.  You have to manually click on it and then if you click on the search the focus moves to the next field.  I'm not sure if that is related or not.  Any insight into what we are doing worng would be greatly appreciated.

RE: MES FLEX -help adding search to an entryfield added to Macola screen

You should not add an entry field, you should unhide one of the user defined fields.  There will be no special code required to save that data to corresponding field in the ppordfil_sql (there is no ppordhdr_sql table) and you will be able to set the tab order.  I do not have time to test this but I am about 95% sure this is your problem.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: MES FLEX -help adding search to an entryfield added to Macola screen

(OP)
Hi, thanks for your response (and sorry for my mistype on the ppordfil_sql table, I think I had POs on the brain at the time).  Without getting into a ton of the details we don't want to use a user def field because (and it definately will work with the searches) as a majority of our user fields are already being and what we are doing is writting the value imputed into the entry field to the cus_no field.  I know is is against normal Macola functionality and this should be filled in from OE on a pulled item, but we need this data to work with our label printing system.  If we use a user def field then we will have to either trigger it into the cus_no or do something in Flex to do an extra copy and move it to the right field.  Is there maybe a different way to accomplish this?

Thanks for the help!  

RE: MES FLEX -help adding search to an entryfield added to Macola screen

Looks like you are stuck with writing flex code.  I am 99% sure you cannot set tab order or attach searched to VBA entry only fields.  You are going to have to use a user defined field for this.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports.  Check out our Macola tools:
www.gainfocus.biz/exceladdin.html

RE: MES FLEX -help adding search to an entryfield added to Macola screen

(OP)
Thanks for your help. We ended up having to add a button to the form and call the Macola search from the button then write the returned value to our field.  And it looks like you are correct about the tab order.  No matter what we tried we couldn't get it set.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close