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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: ps40life
  • Order by date
  1. ps40life

    Excel-look up factor based on two variables

    OK, great. I normalized the data and it looks good. Great tip! Now, when you say simple lookup, a vlookup only can use one factor. I have heard you can use Index and Match to do a multiple variable lookup, but that is usually when the factors include one column variable and one row...
  2. ps40life

    Excel-look up factor based on two variables

    Hello, I have a factor table that looks something like this: Dep. 20% 30% 40% 50% 1 26500 35200 41200 45500 2 30000 36000 45000 51000 3 32000 37500 41250 47000 The numbers under the percentages are earnings, so with one dep up to 26500, you get a 20% discount. Two...
  3. ps40life

    Use drawing tools on protected form

    OK, so what are my options?
  4. ps40life

    Use drawing tools on protected form

    I agree! So, is there any good way to suspend protection, maybe with a macro, so you could use the drawing tools, then re-protect without losing form field data?? [ponder]
  5. ps40life

    Use drawing tools on protected form

    Does anyone know how I can use drawing tools on a protected Word form. I have a "graph" area that I want to be able to draw circles, squares, etc. on. I tried to protect only the other sections of the form and I can TYPE in the graph section, but the draw tools are disabled. Thanks...
  6. ps40life

    Status bar not available

    Does anyone know why the status bar option would not be available in Excel 2000? It is listed on the View menu, but it is grayed out. No files open or anything happening. Always happens this way-cannot view status bar. ?????
  7. ps40life

    Assign a VLOOKUP to cell with SELECT CASE (EXCEL)

    XLBO: I have tried your suggestion and I think in a situation where all the criteria columns were the same, it would work very well. My problem is that most of the criteria only look at one column. So, in order to cover all possibilities, I would have to build a table for many criteria that are...
  8. ps40life

    Assign a VLOOKUP to cell with SELECT CASE (EXCEL)

    To XLBO: I think I understand your idea and I wouldn't mind skipping code at all! But what happens when the criteria is only in two of the cells, and not the third? I always take into account the bldg type, but the surface and membrane may or may not be included. (I am sorry, my little data...
  9. ps40life

    Assign a VLOOKUP to cell with SELECT CASE (EXCEL)

    Hello, In an Excel spreadsheet, I used a nested IF statement in each cell to do this, but the number of variables has increased and I think I have to go VBA with it. I have one cell that is assigned a cost factor. It is determined by checking a combination of 2-3 different cells. E.g., If bldg...
  10. ps40life

    Need to find salary as of...

    Hi, I haven't found an answer to this, so... I need to find the salary of a person as of 8/1/2003. I have a history table that lists the date of a salary change and the amount. For example... Emp 1 5/3/01 54,000 Emp 1 6/4/02 57,000 Emp 1 8/6/03 59,000 So, I need the 6/4/02 record at...
  11. ps40life

    Why do so many people not acknowledge help

    Interesting and humorous post! As someone on the other side, who receives the help, I hope I always come across as grateful for the answers I receive. I have had, as someone mentioned, answers that I had no idea what to do with it. [ponder] I consider myself a technical user, but I have been...
  12. ps40life

    Sort Crosstab by a custom order

    I have a crosstab query that counts students by gender and breaks that into ethnicity. It works fine, except that the grades don't sort the way I want. An ideal sort would look like this: EE PK K 01 02 03 etc...through 12 Presently, it sorts the numbers first, then alpha with EE, K, PK. Is...
  13. ps40life

    Filtering a database report list in combo box

    PaulF, Thanks so much for the advice. I set up a query on the system table and it works perfectly. I can filter out whatever I don't want to show through the query. Excellent advice!!! Susan [2thumbsup]
  14. ps40life

    Filtering a database report list in combo box

    To dhookom: I had a table set up, but I am going to be relocating and my user is on her own after that. She is beginning to create her own reports now and I thought it would be easier to code the combo box list to update automatically as she adds new stuff. She is a new user, so she is not...
  15. ps40life

    Filtering a database report list in combo box

    To Lego: Thanks for the reply. I will try the IF statement, and I am also going to look at PaulF's suggestion. FYI-I was previously pulling the names of the report from a table. Problem is, you have to constantly be adding new report names to keep the list updated. I wanted to automate for my...
  16. ps40life

    Filtering a database report list in combo box

    Hi, I have a combo box on a switchboard form that lists all of the reports in the database alphabetically. The code looks like this: Private Sub Form_Load() Dim knt As Integer Dim i As Integer Dim j As Integer Dim aryNames() As String Dim temp As String Dim values As...
  17. ps40life

    Sort dynamically filled combo box

    Can anyone else help me finish this code? Thanks!
  18. ps40life

    Sort dynamically filled combo box

    Mongoose, It has been awhile since I posted this, but I finally got around to doing it. It works great!! I did have to change one small thing in the following line of code: values = aryNames(j) & ";" & values The first and second report were showing up on the same line, so I just...
  19. ps40life

    Design ? re: code tables used to fill in fields in tables

    OK. I agree with using the code table WITH the autonumber. It's great when entering in the table and you hide the autonumber so they only see the text of the code (not the auto#). Going back to my question though, what about when you are working with queries? How do keep track of the...
  20. ps40life

    Sort dynamically filled combo box

    Thanks. I will try this out.

Part and Inventory Search

Back
Top