Search results

  1. O

    Conditional Formatting in MS Excel

    I am not sure, but I wonder if the problem is you have only added one FormatConditions, which explains why FormatConditions(1) is okay but not FormatConditions(2)?
  2. O

    Conditional Formatting in MS Excel

    Yes, the macro code helps to a degree but the actual solutions may have to be found online. To convert this code: Selection.FormatConditions.Add Type:=xlExpression, Formula1:="=""ah3 > 0""" Try this site: https://learn.microsoft.com/en-us/office/vba/api/excel.formatconditions.add Where you...
  3. O

    Conditional Formatting in MS Excel

    Does this help?: https://community.progress.com/s/article/P189645
  4. O

    Progress installation Java version

    Although version 9.1E you may find some help here: https://docs.progress.com/category/openedge-archives https://documentation.progress.com/output/ua/resources/OpenEdge/91D/oe-91d-pdfs.zip
  5. O

    Question Change color for the loading progressbar

    It seems it is locked to that color and although it is possible to change color not a natural thing to do: https://stackoverflow.com/questions/778678/how-to-change-the-color-of-progressbar-in-c-sharp-net-3-5
  6. O

    Copying Data from ttCustomer to ttContacts

    It seems you have quite a few errors - could be in the include files - and not easy to see the problem as there appears to be missing datasets/function names and some code lines not being quite correct as similar to the GUID error in the () being used for GENERATE-UUID. Maybe an idea to create...
  7. O

    Copying Data from ttCustomer to ttContacts

    I think this line is the problem: ttContacts.ContactID = STRING(GUID(GENERATE-UUID())). /* Auto-generate ContactID */ If you change to this instead it compiles: ttContacts.ContactID = STRING(GUID(GENERATE-UUID)). /* Auto-generate ContactID */
  8. O

    problem with multiple power bi connections causing error broker

    As Rob has posted the "the gateway" could be the cause, but if a Power BI issue then a bit of extra information. When we added Power BI we encountered the exact same problems reported in this thread despite the number of connections/servers/brokers settings being what we thought was high...
  9. O

    Resolved Show value when loading progressbar, in richTextBox1

    Can duplicate the problem and think I know what you require. Put this extra line in the setrichTextBox1value method: THIS-OBJECT:Refresh()..
  10. O

    Resolved Show value when loading progressbar, in richTextBox1

    That seems to suggest that something extra is happening that is clearing the rich text box. It could be the components are being reinitialized or the setrichTextBox1value method is being called again by something else which is passing a blank value. From what you have posted neither of these...
  11. O

    Resolved Show value when loading progressbar, in richTextBox1

    I am not sure of the actual problem as it appears you are showing the value in the rich text box:- THIS-OBJECT:richTextBox1:Text = ipvalue. Is the problem that you want to show all the previous values because currently it is only showing the previous value passed? If so, then does something...
  12. O

    I don't want window code rearranged

    Yes, as you can see from here, Thomas Wurl from Taste IT Consulting identified the problem and a fix and a case was opened but as yet still no official fix: https://community.progress.com/s/question/0D74Q000008HoP7SAK/detail
  13. O

    Get month name when input month number

    Cecil, for a .NET solution your example is a good one as it shows it can be achieved with just a single line of code: MESSAGE System.Globalization.CultureInfo:CurrentCulture:DateTimeFormat:GetMonthName(3) VIEW-AS ALERT-BOX INFORMATION. I had previously been using something similar to this...
  14. O

    Upgrade from 9.1E to 12.8 (Windows)

    As far as I know the operation of temp-tables has not changed much/at all between versions 9 and 12, and the error you are getting is expected as the temp-table names are both the same. It may have been allowed in version 9 but not later versions. Change the name for the new defined temp-table...
  15. O

    How to use font after creating it at runtime

    The only options I know of is as per this article: https://community.progress.com/s/article/18493 Or something similar to this very old code snippet from many years ago: DEFINE VARIABLE Font1 AS INTEGER INITIAL 1. DEFINE VARIABLE Font2 AS INTEGER INITIAL 2. DEFINE VARIABLE FontSelect AS...
  16. O

    Question How do I use Windows Hello Authentication (Windows.Security.Credentials)

    Yes, this seems to be hidden deep as there is no indication of where it can be found. I do not know if what is posted here is any help: https://stackoverflow.com/questions/44093544/how-to-install-windows-security-credentials-c-sharp-net-vs-2017
  17. O

    SELECT-NEXT-ROW returns true when on last row of browse

    These things are never easy! So I am guessing the problem is that the CTRL-TAB is only applying to the master window and not others? Is it possible in the master window you can get a handle to either the procedures, window or browse and if so set a CTRL-TAB specific trigger to the handle...
  18. O

    SELECT-NEXT-ROW returns true when on last row of browse

    For a generic context you could iterate through the browse columns and check that way: DEFINE VARIABLE brws-col-hdl AS HANDLE NO-UNDO. DEFINE VARIABLE browse-hdl AS HANDLE NO-UNDO. DEFINE VARIABLE i AS INTEGER NO-UNDO. browse-hdl = BROWSE bwsItem:HANDLE. DO i = 1 TO browse-hdl:NUM-COLUMNS...
  19. O

    SELECT-NEXT-ROW returns true when on last row of browse

    Never used SELECT-NEXT-ROW so not sure the best solution. One idea is to check what has focus and if a cell then remove focus. A really rough example only but hopefully it gives some ideas: ON CHOOSE OF cmdSelectNextRow IN FRAME fMain /* SELECT-NEXT-ROW */ DO: DEF VAR rv AS LOGICAL NO-UNDO...
  20. O

    OS-COMMAND Won't Run With a Variable Path

    Use the VALUE function: OS-COMMAND SILENT VALUE(cDir4Control + "HT\Website.bat").
Back
Top