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!

  • Congratulations Mike Lewis 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. anniesolomon

    Problem with Index in MS Word

    Well, Paul, I guess you didn't read my posts very well. I did refresh the index by clicking in it and then pressing F9. The reason it didn't delete the "hosed" reference is because it was a legitimate reference. For some reason, the index entry didn't recognize the leading dots before the...
  2. anniesolomon

    Problem with Index in MS Word

    I figured it out. It was a legitimate index entry (the Spanish word "lo" as an object). For some reason the field got hosed. I deleted the entry, recreated it, and voila! It's all good now.
  3. anniesolomon

    Problem with Index in MS Word

    I have a strange entry (Lo3) in my index and can't figure out how to get rid of it. There's no associated page number. I've searched my document for Lo3 but found nothing. I can delete it from the index but as soon as I update/refresh (F9) the index the entry reappears! I've attached a copy...
  4. anniesolomon

    I keep losing my Exel format

    You are spot on! I was pasting stuff from a website into my "formatted" spreadsheet. Thanks for teaching me something new. I never heard about structured tables but I'm going to look into it.
  5. anniesolomon

    I keep losing my Exel format

    I selected the entire worksheet and formatted it so that data in all cells will be at the top left and wrapped. But, as soon as I type something new, the format isn't working. The data goes to the bottom of the cell and does not wrap. It's making me crazy!
  6. anniesolomon

    1000 Separator in an Expression

    I'm using the following expression in an Excel spreadsheet: =IF(E3+F3>N3,"Good Stock Level","Order "& INT(N3-E3-F3)& " "& D3) False results return the number without a comma which I would like to have: "Order 1868 BK" instead of "Order 1,868 BK" Can anyone tell me how to force the 1000...
  7. anniesolomon

    Total Access Analyzer 2010

    Has anybody used Total Access Analyzer 2010 yet? I tested it a couple months ago and had diffulties. FMS swears they have the bugs worked out but I'd like to hear from you before I spend $300.
  8. anniesolomon

    Using wildcard character to search a field

    Hi AceMan. Yes, I'm familiar with the wild cards. It's those darned quotation marks that get me every time. I just cannot seem to grasp how to properly place them and when to use single versus double quotes. I really appreciate your help. Of course, your code works perfectly! Please enjoy...
  9. anniesolomon

    Using wildcard character to search a field

    Thanks but using the word Like alone doesn't help. I would use it with an asterisk wild card before and after the value in the text field but I can't figure out the correct placement of the quotation marks. That's what get me every time!
  10. anniesolomon

    Using wildcard character to search a field

    I'm still having a lot of trouble inserting SQL statements in VBA. Here's what I have: Me.Filter = "[Word]='" & Me![SearchForThisWord] & "'" The problem is I don't want the user to have to search for the Exact word. If I were building a query, I'd use *.* but I don't know how to get that...
  11. anniesolomon

    Grouping and Counting Looking for Differences

    I shouldn't have asked everyone to ignore this post. I just spent hours trying to work with the earlier thread I mentioned but couldn't figure it out. It seems like Greg didn't explain how he developed qUniqueNSNXref. So, I'm still without a solution. I'm hopeful that someone will come to my...
  12. anniesolomon

    Grouping and Counting Looking for Differences

    Please ignore this post. I just remembered that I posted months ago (thread701-1619106). Just now getting the time to get back to thi problem.
  13. anniesolomon

    Grouping and Counting Looking for Differences

    I often have several requisitions on backorder against the same vendor contract and want to group them together so I only have to type my follow up notes one time. In other words, instead of having several TrackingNumber records, I just want one. I want to design a report that alerts me when a...

Part and Inventory Search

Back
Top