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. gstrenio

    Flexibility: how to get to code when computer freezes when form opens

    Hello forum: I have been working on a Flexibilty module where I have a "SendKeys" VBA statement on the Got focus event of the first field that receives the focus when the form opens. I had used "SendKeys" with no parameter, but tried "SendKeys, True" to see if...
  2. gstrenio

    ADO can't open table

    Thanks for the help, Don and Chad. To my chagrin I find that I've been using the wrong name for the table: it is APTRXDST not APTRXDIS. Why ACCESS and Xtal Reports worked was that I was dragging the table from a list rather than typing the wrong name in. APTRXDST behaves normally when I use ADO...
  3. gstrenio

    ADO can't open table

    Thanks Chad. My E-mail is nabla@erie.net. But why does ADO work with APTRXFIL but not with APTRXDIS?
  4. gstrenio

    ADO can't open table

    Hello forum, I am making a simple Flex application that saves the values in tables APTRXFIL_SQL and APTRXDIS_SQL to an ACCESS database before these tables are deleted when the AP distributions are posted and report printed. I retrieve the values using ADO. I can get the APTRXFIL_SQL values OK...
  5. gstrenio

    Linking Tables

    Hello Don, Your idea would be to make a bill of material "on the fly", so to speak? This would still require an interface between the VBA part number interpreter and MACOLA input screens, wouldn't it? And this would require Flexibility? At this point the client is considering the costs...
  6. gstrenio

    Linking Tables

    Thank you for information. Client does not currently have Flexibility module as part of their MACOLA package and I want to be sure that it will allow them to do what they want done (with the proper programming) before recommending that they purchase it.
  7. gstrenio

    Linking Tables

    No, I am not a reseller and I haven't spoken to Exact yet. I have a client for whom I've written Crystal Reports and ACCESS databases that read and use data FROM MACOLA. Some of their tasks would be made easier and less error-prone if data could be entered TO MACOLA from ACCESS database via VBA...
  8. gstrenio

    Linking Tables

    Thank you for quick reply. Rather than manually selecting options for a feature group, client would like to enter long part number which contains information denoting what options are desired. The external VBA routine would use this number (now entered in a comment field on line item order entry...
  9. gstrenio

    Linking Tables

    Will the Flexibility module allow the creation of routines in VBA that can be used to input data into MACOLA and can be used instead of the MACOLA input screens? I have a client who uses features/options screen to select the various options after interpreting a part number. I have written an...

Part and Inventory Search

Back
Top