Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nablainc

    ACCESS Append queries

    Thank you for the quick and informative reply. We were trying to add additional locations to the IMINVLOC table after a batch of new items had been added to the database. The production manager discovered how to do this using MACOLA's input screens. We were curious because we had taken care not...
  2. nablainc

    ACCESS Append queries

    Hello forum members, A client is using MACOLA ES 9.5.700. We sometimes use Microsoft ACCESS Update queries to make wholesale changes to certain fields such as prices or costs when there is no convenient method available using MACOLA screens. On occasion we have tried using Append queries to...
  3. nablainc

    Uses of Flexibility

    Hello SamW41, We use Flexibility to do such things as: 1. Get a part number from an ACCESS database, enter it into the ItemMaster table, then construct the BOM for this item from information in an ACCESS table. We do this by using Sendkeys to simulate a "phantom" user sending data to MACOLA...
  4. nablainc

    SendKeys stopped working when upgrading from 7.6.200 to 7.6.300

    We have some Flexibilty code behind a Bill Of Material module form (Product Structure File Maintenance). In that routine SendKey ("{enter}") works OK. Jerzy
  5. nablainc

    SendKeys stopped working when upgrading from 7.6.200 to 7.6.300

    My client intends to continue the upgrade process up to the latest version. He wants to be sure his installation is stable with one version before going to the next higher version. One thing that bothers us: when the Flexibilty client module is updated, the opening splash screen displays...
  6. nablainc

    SendKeys stopped working when upgrading from 7.6.200 to 7.6.300

    We have had trouble with the Visual Basic Sendkeys not working consistently in this application, so we bought a routine several years ago from M8 Software that replaces the Visual basic Sendkeys with a routine called "SendKey". This routine has worked flawlessly until the upgrade to Progression...
  7. nablainc

    SendKeys stopped working when upgrading from 7.6.200 to 7.6.300

    It would probably be more accurate to say that SendKeys fails in some lines of code but appears to work in other places. Tomorrow I'll try adding the "Wait" parameter = true to see if that helps. Jerzy
  8. nablainc

    SendKeys stopped working when upgrading from 7.6.200 to 7.6.300

    A client has begun to bring his MACOLA installation more up to date and has upgraded from Progression 7.6.200 to 7.6.300. (Running MS SQL). Flexibilty routines seem to start but the Sendkeys function does not work. (The Flexibilty server and clients have been updated.) Has anyone any ideas...
  9. nablainc

    Null values in MS SQL after converting from Pervasive SQL

    I have a client who recently upgraded from Pervasive SQL to MS SQL. It seems that fields in MACOLA tables that previously had empty strings denoting "no value" now are null. I have had to modify Flexibility routines to allow for the null values, and many of their Crystal Reports require...
  10. nablainc

    Update a user defined field from Order entry screen

    I have got the routine to do what I desired (update the user_def_fld_5 when a license is required) by a modification of Andy Baldwin's suggestion. I could not get the postsave event to trigger, but I triggered the update query on the type1(order type) got-focus event. This was suggested by...
  11. nablainc

    Update a user defined field from Order entry screen

    Hello Andy, The Postsave event does not seem to do anything: the only three events of the macform object that seem to work on my client's installation are the Initform, Save, and Close. (I test by putting a message box in the event to see if it triggers). Putting the order number in a global...
  12. nablainc

    Update a user defined field from Order entry screen

    I tried finding the macform.connifo.openadoconn object but could not: ConnInfo has 4 or 5 properties, but OpenADOConn is not among them. I looked at some of my ADO references and realized that the connection parameter is optional in the openrecordset method: if it is not specified, the active...
  13. nablainc

    Update a user defined field from Order entry screen

    Hello NEmacGuy, I think you might be on to something with your thought about the connection being used: I opened a new connection, rather than using the opened connection being used by macForm. I wasn't sure how to access the connection being used. This could explain the "locked-record"...
  14. nablainc

    Update a user defined field from Order entry screen

    Hello Don, That is what I'm doing: setting a global variable on an event triggered by an earlier field, then setting focus to the user defined field, then on the got-focus event trying to set the user defined field's value to the global value. Similar methods have worked on other Flexibility...
  15. nablainc

    Update a user defined field from Order entry screen

    Thanks for your efforts, Don, in looking into this. I get "Btrieve error 84" as the record-locking error message. I continue to work on the other approach: having Flexibility update the value for the user defined field, but I cannot get the code to trigger on the got_focus event. I either get...
  16. nablainc

    Update a user defined field from Order entry screen

    Hello Don, It is on Pervasive. The client is updating to SQL within the next month, however. Thanks for reply. jerzy
  17. nablainc

    Update a user defined field from Order entry screen

    My client has certain products that need an export license when shipped to certain counries. They want a message printed on the Pick Ticket when such a license is required with no user action required. I have made routines that determine when such a license is required using Flexibility on the...
  18. nablainc

    Flex code question - Sendkeys

    Hello Don, I wasn't able to view the actual code, but I found an old listing and I think no parentheses are needed: that is, try SendKeys "{ESC}" the double quotes were used. jerzy
  19. nablainc

    Flex code question - Sendkeys

    I see I mixed up curly braces and square brackets: should be SendKeys("{ESC}")
  20. nablainc

    Flex code question - Sendkeys

    Hello Don, Try putting double quotes " around {ESC]----- making it SENDKEYS("[ESC]"). I have a client using SENDKEYS in a Flex application and I will check their code later today to verify this, but it's worth a try. jerzy

Part and Inventory Search

Back
Top