Recent content by ColumbiaDiver

Skip, Awesome. I'm working on it now. Thanks again. I'll let you know how it work out. I think I need to add a byline with your name on it for the process for all the help ypu've given me on this. :-) Gordon

Hi Skip, Thanks a bunch for getting back to me. The data in the User tab on the worksheet is pulled from a MS-SQL database using a select statement similar to the example below, but since I was uploading an example I just copied a sample of the actual data to the to the User tab since it...

Hi Skip & Andrzejek, Well I finally got back to the terms and was able to get it to work after a manner of speaking. I am pulling the user profile data from MS-SQL and saving it in another tab of the spreadsheet, (it updates each time the template is opened). It's not as versatile as other...

Hi Skip & Andrzejek, Just wanted to touch base to let you know I am still working on/looking at this. Work deadlines have shifted my focus a bit. I'm hoping to spend so more time on it today and hopefully nail it down. I'm accumulating a lot of terms so I need to get this working or do another...

Hi Skip, OK let me see if I can clarify. Some of what your referencing is going over my head a but I’ll try to give it a whirl. 1. Where do you address the specific databases for each user? In the test sheet that I created I used DataForm Other SourcesFrom Microsoft Query<New Data Source> I...

Hi Skip, Not sure I follow you, but then I'm fairly new to MS-SQL, (I know just enough to be dangerous), an example would be great. I've also attached a screenshot of the test sheet I setup and the template sheet to give you a better idea, (names were changed to protect the not so innocent)...

Hi All, Hoping someone can point me in the right direction in respects to a question I have in querying an MS-SQL database from Excel 2010. I work for a large company and we don’t have a method in place to track what users have access to what systems, (350 at last count). So what happens when...

Guys, FYI I spent a lot of time trying to make sure the formatting on the code and checks were easily readable but when I submitted the post it went wonky. Sorry. Gordon

Guys, Warning, Warning: Long post, so if you want to read the details of my RPG misery then read on, otherwise skip to the last paragraph [cry] Thanks for the help and suggestions, really useful. Tom yes it's old. The issue is that way back when my company bought the financial system...

Tom, Thanks I'll take a look. I do have one question. Since an indicator can be whatever the programmer wants it to be, how to I tell what the programmer set the indicators to be? I've searched through the source code to see if I could find someplace where the programmer has said indicator *x...

All, I am in the process of updating an older RPG program and being fairly new to RPG programming, (but not programming in general) I am having a difficult time understanding indicators and their place and purpose in RPG. I know that the recommended programming is to not use the numeric...

Hi All, I have an old customer that is still running Paradox 7 and they asked me to make a few changes for them on a application I wrote for them. There is a field defined that basically says if the value of this field = YES then update the following fields with the specified data. They wanted...

Tom and Francis, Excellent. That's exactly what I was looking for. I really appreciate your taking the time to help me out. Take care. Gordon

All, I have a quick question that I hope will have an equally quick answer. I have an RPG program that is used to run part of our payroll process. The RPG program populates a data file that gets transmitted to the company that maintains our retirement. The vendor process for our regular payroll...

Hi All, Hoping someone can help me with an issue I am having with a report I wrote for one of my departments. The report is an audit report to verify that all that all the records for players in a charity golf tournament are being pulled correctly by the application before the user moves onto...