Search results

Thanks for the info. They are only to be on this system for about 18 or more months, and I feel they are not going to want to invest further.

UPDATE: Management is deciding what they want to do. We can open the files just fine, just can't save and/or create any new ones. Thanks all.

The very higher ups for the company I contract for, have decided that the new 'server' that handles the Progress ERP will not have Office 365 installed. What that means is that is any application developed that makes calls to read / write to an excel sheet will not work w/o asking for a log in I...

Thanks for the info. The system I am using does not have the COM viewer installed. I think I can use what you had from the screen shot to get what I need. I'd had seen those 'values' before, just didn't have a clue as to what the parameters were. Trying to just use the macro as a source if very...

I was wondering if there is a document here that fully explains how to properly use some of the functions in excel? Take for example the function (?) autofill, it is looking for 2 or so parameters, but no real reference on what or how. I've seen the codes from the xs-web site for things like...

The problem I am now having is that the macro I want to run is stored in personal.xlsb, and if I use the standard progress code, it is not pulling in that file. If there is no way to have progress load that info, the ability to run a macro becomes extremely limited. In as much as this test macro...

I just saw this older post and if I works for what I need, go grab yourself a beer and send me the bill. -Dennis-

Greeting all! I am trying to determine if there is a method to call a stored macro (excel) from a program? From what I have read, I could use the code from the macro and embed it into the .p / .w, but some of the sheets I work with will change and it is just easier to modify the macro then try...

On the ribbon bar there is a drop down of 5 or so values.. The user would select one, hit a button that would walk thru records and apply that value to the a field in the column for each row on the current browse. You can determine row ID value of a row in a browse and you can do a trigger that...

I believe including the actual query build code is in order. That way you can see just how complicated the query is. While I'm uploading this as a .p, in fact it is an internal procedure within the .w program. In short, is scans all the 'filters' , which are drop-downs, and builds and executes...

Thanks for the info, but I already have a very complicated multilevel search procedure written. What I was trying to do is to use the query and reset on of the fields in the querred temp-table to a pre-defined value. So all the rows in the frame are results of the query, but the question then...

Thanks for responding. I am trying not to have to do that as the actual query build is very long. There are maybe 9 different filters that are used and need to be tested. So, for example, I'd have to test each screen-value with something like " assign " and if x:screen-value <> ""...

Hi all, hoping all are doing well. I have a query, freeform, that is built dynamically based of values set from a group of drop down values. This allows, much like excel, for the user to build their own query on the values they need to filter by. Works great. However what I'd like to do now is...

This could very well be what I need to build the function. There up to 38,000 items in the browse, but only really about 15 to 20 different types of case-packing. I'll have to try that later this week as I've got a few other items that need correcting first. Thanks for the info.

For years most of my work was with the back end in progress, with some GUI. So I am building a completely new GUI interface and have a question regarding the use of a combo box. I understand how to populate it, done it many times on screens, but never within a browse. So lets say there 4 values...

So far, working good. For sorting, the drop down will pass the field name to a trigger with the following type of code: on select of the sub-menu do routine for that, i.e. ASSIGN cSort = 'xxxxx' then Run IP-BRSort (input cSort). Or that's the plan.

So true, but what I did find is that I can add on the c-win ribbon a drop down that will work just fine. I have plenty of space there. Actually, two right now, one for filter selection, the other for sort. And there's always the popup option which I used with another company years ago. Thanks...

Thanks for all the info, and it just got worst! (LOL), I'll give those a try, and I like that I may be able to build from a radio-set or whatever. I hope that I can place the values on the default-frame as space is an issue.

Needing some help in understanding what I need to do if I want to change a QUERY that is used in a browse. But first here is the layout. I have a C-Win that has the default-frame, a Frame-A and a Frame-B, Both are the same size and are not connected thru any handles. Frame-B contains the...

Funny thing, I tried that last night, and I won't go over the hours spent trying to track it down, but this morning for kicks I put enable all, and it worked. So then I tried a single field and again it worked. Getting back to last night, it might have been I did not have a CRLF after each...