-
-
-
-
-
ASAP-Utilitites (http://www.asap-utilities.com/) is the BEST and free
download that can do this for you as well as a zillion other cool tricks. What you’re looking for can be found in the Columns/Rows menu. Do a conditional select, and fill with the color of your choice. You might even be able to insert empty rows…I got a runtime error when I tried it. -
BRILLIANT! Works like a charm…
If only this company was giving raises this year !
At least I have the satisfaction of a job well-done AND impressing people who don’t have the wisdom to hang out at Woody’s Lounge.
-
I’m wondering if this function could work for what I need. We have a clunky software that queries the AS-400. Very, very basic. Most of the time I copy and paste the results to Excel and manipulate from there.
To my extreme dismay, the account’s name and account number are concatenated. (Let’s not get into why, because I don’t think any one knows the real answer) Thus, when I want to use the account number for a VLOOKUP, I have to manually type the number in an adjacent cell. The string is text with the account number in parentheses ex : Your Place (90050). The account number is anywhere from 3 to 7 digits. We have over 36,000 accounts. Any ideas? This could change my life.
-
Am I glad you showed up! I have been wrestling with MSQuery for the last 4 months, since the meanie IS guy won’t give me access to the AS400 query library. I am wading chest deep in @#$!% trying to get the information I need in a timely manner. What I’ve found is there really isn’t a “book” about MSQuery. There are all kinds of programming books about IBM Client Access, but there ain’t no “Dummies” version out there for those of us who want a quick answer. I’ve forwarded Han’s reply to myself at work and intend to try it ASAP. Have you? Please let me know.
If you haven’t, and are still wandering around lost, here’s some stuff I’ve done:
Take an hour and just look through the tables that are available by clicking on them and seeing the fields. There’s a button that you can click on to “Preview Now”, and then you can scroll down through the table’s field. If you see anything you might like, run a query on an item/customer/ whatever you know thoroughly by filtering the query….I like to do screen shots of the file I think the table applies to, to compare once I put it into Query. Once you’ve explored it in the MSQuery mode…be sure to include EVERY field, you never know what will show up and you might think about later, put the query into Excel.
Then, do a “Ctrl +A”, “Ctrl+C” and open what wil be your bible…a workbook with all the tables you might possibly be interested in. It’s a simple workbook, one you have given a loving name because it will serve you well.
I like to use a different worksheet for every table I find curious. MAKE YOUR LIFE SIMPLE and use Paste Special to transpose the fields (it’s on the bottom right of the Paste Special options)_…that way everything goes down, down, down, rather that having to fight the across syndrome. Then, you simple look at what the geeks in IS have named the fields and match them up to what you see in your screen shot…add a column, put in your own references. You will be thought of as brilliant by everyone outside of group services, and a pain in the neck by those within because you will start to understand the process and question their oblique references to common items.
By the by, Access is a blast if you get the right teacher…it’s like being your own Porsche mechanic. First you start with changing the oil, then a tune up….personally, I’m getting ready to learn how to adjust the carburetor and I’m pumped!
-
Viewing 9 replies - 1 through 9 (of 9 total)
Author
Viewing 9 replies - 1 through 9 (of 9 total)
