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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RosieMP

  1. RosieMP

    Excel StatusBar update not working (VBA)

    Wow, I feel like a moron. I was looking in the wrong place. But I feel like a moron with the right answer, which is the important thing. Thanks!
  2. RosieMP

    Excel StatusBar update not working (VBA)

    GAH! Not sure whether this is the right forum for this one... Can anyone suggest why my status bar isn't working? If rRaw Mod 100 = 0 Then Application.StatusBar = "Processed " & Format((rRaw / BottomRow), "%") Else Application.StatusBar = "whatevah" End If Even with bad...
  3. RosieMP

    Paste special problem in Excel

    I don't get an error on the vlookup, I just get nothing returned. I use an if/iserror/vlookup combo for vlookups so I don't get '#value' if there's nothing found, so the basic configuration is, if it's an error, return the value "not found", if there's no error, then return the value I'm...
  4. RosieMP

    Paste special problem in Excel

    I tried that text to columns idea but the tick mark doesn't appear in the wizard -- you can see it in the cell only in the formula bar, but not in the cell just by looking at it, and it doesn't appear in the wizard at all (no leading spaces either). (Good thought, though.) The multiply by one...
  5. RosieMP

    Paste special problem in Excel

    I've been stuck on this for months--can anyone help? We manipulate a lot of data that comes out of SAP/BW. The BW stuff is crazy with formatting--much of it specifically formatted as text (with a little ' mark in front of it.) There is nothing I can do about this. It's something to do with how...
  6. RosieMP

    Reporting category history/philosophical question

    Thanks for helping me thinking this out. Re. ankles: probably the same as clavicles. (Don't everyone apply at once.)
  7. RosieMP

    Reporting category history/philosophical question

    They might have been around in 1802. They sure have 19th century corporate policies. We got an email telling us women weren't allowed to show their clavicles. Okay Remou--not sure if we're envisioning the same thing.... Here's what I'm thinking: tReportCategories ReportCategoryID...
  8. RosieMP

    Reporting category history/philosophical question

    What about this for a solution: Rather than a change date for the raw data (and maybe this is what you were saying), what if I include date iterations in the reporting category table? That way the reporting combo has a date attached--IF I want to do some combination of our reporting codes in...
  9. RosieMP

    Reporting category history/philosophical question

    Thanks Fniely -- I agree re. codes v. descriptions; the other upside being that its easier to write queries by a field code than by some big honking description field...What I want to use for a code is the concatenated value of the collector and the internal customer type (credit group), so I'd...
  10. RosieMP

    Reporting category history/philosophical question

    To be clear(-ish), I'll have at least two tables, the raw data (main) table, and the reporting code table....
  11. RosieMP

    Reporting category history/philosophical question

    I don't have much flexibility as far as normalizing the data or setting up tables beyond a table to hold the reporting category. I get a text dump with 12000 lines and something like two dozen columns. I won't have a collector table, or a customer table, it's not going to be normalized. Or...
  12. RosieMP

    Reporting category history/philosophical question

    Okay, one more question for the day... This is a philosophical question, and I've gotten conflicting responses asking around the office, so I'd like to find out what's recommended. I'm building a table to hold a history of open accounts and report on it. Reporting buckets are based in part on...
  13. RosieMP

    Table design/Storing history

    Thanks both! I took the 'no brainer' as intended :) I'm glad it's a clear answer. I think what got me is that it seemed like a giant Excel spreadsheet.
  14. RosieMP

    Table design/Storing history

    Hi folks-- I'm having a hard time deciding between design decisions that may or may not make my life miserable in six months. I need a database to hold a significant amount of data about aging accounts. I'll add about 12000 lines each month about how much money various customers owe, and how...
  15. RosieMP

    Changing BE table name/subsequent error

    Okay, I think I figured this out, so for anyone who finds themselves in a panic this is what I did: I changed the be table name to what I wanted, then deleted the link in the front end, then I readded the table link in the front end. It didn't seem to be enough to just change the name in the...
See more

Part and Inventory Search

Back
Top