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!

Search results for query: *

  • Users: RosieMP
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. RosieMP

    Changing BE table name/subsequent error

    Please help, folks -- I need advice. I'm horrified to have found after splitting a database and rolling out the fe/be that a table is named incorrectly. When a user tries to launch a particular query (that produces a report) they get a 3078 error because a table is not found. Evidently at some...
  6. RosieMP

    Slowing down automated emails (VBA w/ Lotus Notes)

    Can anyone suggest some code for slowing down the sending of multiple emails? I built an email sender in Excel that sends through Lotus Notes. We'd sent up to 500 with no problem, but the user's file has expanded to 1500 addresses and today Lotus Notes had a small panic attack and choked. Is...
  7. RosieMP

    Improved stability Access FE/SQL backend

    I have yet another Access fundamentals question, this one about another DB.... We have a DB that is being rolled out from a group of about twelve users to a potential pool of maybe fifty or more. They won't all use it concurrently, but some will. I understand that Access isn't really...
  8. RosieMP

    Textbox value not returning query results

    I have a textbox on a form for users to use to enter one or a series of contracts, separated by commas. (txtEntry) I have another invisible textbox I use to hold the value of the first textbox in a query-friendly format, so the first box might hold "1,2" and the second holds "1 or 2." (I just...
  9. RosieMP

    Implications of DB Split

    I was wondering if anyone could offer an overview of post-split administration of an Access DB. I'm facing doing my first split and I've read enough about the process of how and why to do it to feel confidant, but I'm having a hard time envisioning what it's like to make changes to the database...

Part and Inventory Search

Back
Top