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: *

  1. con10t

    Access 2007 Form stuck in "calculating" after adding picture control

    Aceman--Thanks for the info, at this point ANY news is good news. I'm at work at the moment, so I'll have to try what you suggested and continue reading. I'll let you know if that worked/helped. I appreciate all your help! Deborah
  2. con10t

    Access 2007 Form stuck in "calculating" after adding picture control

    I have a 2007 Access database to inventory my supplies. I was embedding pictures into the various forms and noticed that my database was exploding in size.In an effort to cut down on the size of my database, I followed the instructions on this truly incredible thread, wherein instead of...
  3. con10t

    Excel 2007 Find closest match in multiple records

    Skip--Thanks for your reply. I guess, yes, that I mean I want to find the individual who is closest to "zero" on all three parameters, and if there isn't an exact match--zeroes on all parameters--who matches the model the closest. Dallen/Deb--Thanks for this--I think this is exactly what I was...
  4. con10t

    Excel 2007 Find closest match in multiple records

    I have a spreadsheet that holds information for over 1000 individuals. There are three scores per individual. We have a "model" individual and I want to find the individual that most closely matches the model. It doesn't matter if their scores are higher or lower, just closer. Model Individual...
  5. con10t

    Outlook doesn't recognize font selection

    Thanks in advance for your help. My boss changed his signature and since then his emails do not reflect the font he has selected--Arial, black, 12 point. Instead, they are Helvetica, white, 10 point. He uses Word as his e-mail editor and he has no problems with Word. We have double-checked the...
  6. con10t

    if statement with an average condition

    Hi! I'm working with Excel 2002 and have a similar situation as 553, but instead of looking up a number, it looks up text. I'm wanting to find the average scores of different groups. The following formula is trying to give me the average of the test scores of individuals coded as Engineering...
  7. con10t

    Print Preview Formatting Page message

    Add on: On another site it was recommended that I remove the page of page code. When I did the report came up, BUT, now the Boys subject (which, again, only has 14 entries) is hundreds of blank pages long!!! Any new ideas? Thanks again! Deborah
  8. con10t

    Print Preview Formatting Page message

    I have created a report that lists quotations divided into subjects. An enter parameter box allows the user to determine which subject they want to see. Sometimes the report comes up with no difficulties. At other times, the bottom of the screen reads "Formatting page, press Ctrl+Break to stop ...
  9. con10t

    Need an Excel formula for distribution based on points

    Ridge--Thank you for following up with me. I have been remiss in giving you kudos and I apologize for not thanking you for your help. The big guy was unhappy with how the spread turned out, so we added another formula--the top 10 get the lion's share and the rest get what's left. So we used...
  10. con10t

    Need an Excel formula for distribution based on points

    Thanks! I'll run this past the big guy and see if he really wants to set maximum and minimum. I appreciate your help! Deborah
  11. con10t

    Need an Excel formula for distribution based on points

    Thanks so much--and you're right! Either boss man has given me bad numbers or somebody's going to get a nice scholarship. I'd love to see the example. Let's drop total down to 10K and see how that works. Thanks! Deborah
  12. con10t

    Need an Excel formula for distribution based on points

    Thanks you're a lifesaver--dcspublicATSIGNattDOTnet Trying to keep junk mail volume to a low roar. I'm getting e-mail for body parts I don't have!! LOL!! Hope you understand. Deborah
  13. con10t

    Need an Excel formula for distribution based on points

    This year there are 20 people. Next year there may be more. Points this year range from 22 to 100. Person with 22 points gets $500; person with 100 points gets $4,000. Is there some kind of sliding scale function in Excel that will appropriately allocate the rest of the funds?
  14. con10t

    Need an Excel formula for distribution based on points

    I am working on a funding spreadsheet. We have applicants who have been scored "points". We have $100,000 to allocate to them. The person with the lowest points will receive at least $500.00 The person with the highest points will receive $4,000. We would like to distribute the remainder of the...
  15. con10t

    Calculating totals in a form based on check boxes.

    Thanks for trying. I must be typing something in incorrectly. When I try pwise's suggestion the total in the Billable Expense is always $15.00 regardless of which candidate I am viewing--some have no costs, others have hundreds of dollars. When I try kewo99's suggestion, both the Total box and...
  16. con10t

    Calculating totals in a form based on check boxes.

    Good morning! I am a newbie, so please bear with me. I am creating a form that lists the costs associated with a candidate. Some of these costs we pass on to our clients, some costs we pay for. I have a subform that allows the user to list each item (travel, test materials, off-site office...

Part and Inventory Search

Back
Top