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. pbbriggs

    Excel - Formatting currency with function (lose red negatives)

    Gavin, your code is really slick. Works like a charm. I am going to write some quick code to revert back to formulas (and then re-run the formatting code) any time a value changes somewhere, but this was a great help. Thanks. Stars to you both - both solutions are equally viable depending on...
  2. pbbriggs

    Excel - Formatting currency with function (lose red negatives)

    Thanks, Skip and Gavin... Right after I posted (isn't that always the way?) I thought of conditional formatting based upon the original value (A1). It works fine, and I can live with the red text it produces for the negative numbers. I am going to try Gavin's code; I am not wild about losing...
  3. pbbriggs

    Excel - Formatting currency with function (lose red negatives)

    Hi, I have an Excel formatting question that I thought was pretty straightforward, but nothing seems to be giving me the desired result. Basically, I want to combine a number (in one cell) with text in another cell, while retaining the correct formatting of the number. It is all working...
  4. pbbriggs

    Custom Number Formats - Show Numbers in Thousands ('000s)

    Have a star, Pampers, for solving this issue for users of more current Access versions! I am quite sure that your original formatting suggestion: #,##0, would work just fine for later versions of Access. Thanks for the help!
  5. pbbriggs

    Custom Number Formats - Show Numbers in Thousands ('000s)

    The formats with the periods instead of commas aren't taking, either. As soon as I leave the format field, the period disappears. I also just tried setting the format through code (in the OnOpen event of the form). I don't get an error, but nothing happens. Maybe Access 97 doesn't recognize...
  6. pbbriggs

    Custom Number Formats - Show Numbers in Thousands ('000s)

    Don't laugh, we're on Access 97. :)
  7. pbbriggs

    Custom Number Formats - Show Numbers in Thousands ('000s)

    Hi again Pampers, Thanks for your persistence! I would definitely like to use one of the format options (vs. your unbound textbox suggestion) because my fields allow entry/edit; they are not just for viewing. The strange thing is, even though my regional settings are set correctly, whenever I...
  8. pbbriggs

    Custom Number Formats - Show Numbers in Thousands ('000s)

    Thanks Pampers. For some reason, when I enter that into the Format box, the final comma is dropped as soon as I leave the field (even if I put the semicolon after it), so it reads #,##0 . So, then the number just formats as: 459,999. I don't know if there is some trick to custom formatting in...
  9. pbbriggs

    Custom Number Formats - Show Numbers in Thousands ('000s)

    Hi, I have a form that is basically displaying a financial worksheet/cash flow statement. I would like the figures to be shown in thousands (i.e., the last three digits would not show, and the digit before the final comma would be rounded up or down accordingly). For example, I'd like 456,000...
  10. pbbriggs

    Name LOOKUP range

    #REF generally means there is something wrong with the range it is trying to look in (usually it means the cell(s) originally referenced in the formula have been deleted) Do you see #REF in the formula itself (e.g., LOOKUP(B2,#REF,2,false), or just in the result? If you know the range you want...
  11. pbbriggs

    Name LOOKUP range

    It means that someone has already named a range (called "emp"), and this is where your lookup formula is looking. To see what the range is, you can either choose "emp" from the name box (just to the left of the formula bar)... ... or use the menu option "Insert - Name - Define" to see a list...
  12. pbbriggs

    Conditional Formatting

    livvie, I think it would help if you could explain a little better what you are trying to do. Are you trying to permanently highlight some records? Are you trying to highlight some records temporarily so that when the user clicks a command button, s/he knows which records are going to be...
  13. pbbriggs

    Conditional Formatting

    How does your command button know for which record(s) it should be passing details to the other table? Could you have a checkbox (or some other true/false field) in your original table/query (upon which the form is based), and then just make all fields locked on the form except the checkbox...
  14. pbbriggs

    Conditional Formatting

    By "select button" do you mean something like an option button or check box (i.e., one button for each record, that pertains only to that record)? Are you, for example, trying to highlight a row when the "select button" for that row is checked? If that is what you are trying to do (and you are...
  15. pbbriggs

    Message Box Macro

    bobbobruns12, I don't use macros, but it sounds like your macro may never be called if you use the "AfterUpdate" event of the DLookUp text box (CityCode) because - in the event the lookup city/state is not found, the box is not updated. Does the user click a button after entering the...
  16. pbbriggs

    Tracker Software

    Thanks BobStubbs for providing an easy way to create an activity log! Star for you.
  17. pbbriggs

    Refreshing List Box after Update

    Roy, You've helped me again. I wanted to requery a form after returning to it from another (pop-up) form and had tried putting the requery command on just about every event you could think of (open, load, dirty, activate, etc., etc.) but nothing worked. I had no idea it was as simple as just...
  18. pbbriggs

    Preventing deletion (but not editing/addition) within field

    vbajock, Thanks for the reply! Sounds like a clever way to prevent any editing at all. Unfortunately, I need to allow edits/additions, just not deleting. I'm going to try what Golom suggested. Thanks Patricia
  19. pbbriggs

    Preventing deletion (but not editing/addition) within field

    Aha! Of course. I knew there had to be something I wasn't considering. Haven't even tried it yet but I know you just gave me a great solution. Thanks for the (very speedy) reply. Here's a star, as I'm about to go do what you just suggested. Patricia
  20. pbbriggs

    Preventing deletion (but not editing/addition) within field

    I wasn't sure whether to post here or in the Access Forms forum, but I have a suspicion that if this can be done at all, it will need to be done in code... I have a form on which all fields are locked except one, which is a "notes" field (memo format). I want all users to be able to add notes...

Part and Inventory Search

Back
Top