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

  1. JohnCHolmes

    Global Search

    Frink, I like your posts, communication clarity and attitude. I think you might like to look at this one too. http://www.mrexcel.com/board2/viewtopic.php?t=109378&highlight= However it relies on Microsoft's find (essentially a Ctrl-F, I believe) and is consequently slower, just the way...
  2. JohnCHolmes

    Word Spelling/grammar - excluded text

    Thanks, tf1 - I'm inclined to go that way. A catch would be if I inherited a huge .DOC with tons of proper names. Also thanks fumei. 1. I have no forms. 2. What I referred to was heavier than the single file Boolean. When you "ignore" a suggestion, your answer is remembered even after you...
  3. JohnCHolmes

    Undo track changes in Word 2000

    Well, for the future, options/save/always create backup
  4. JohnCHolmes

    can't open word doc

    If that's the only copy there's not much you can do. At the cost of losing formatting, justification, bold, underline, and several other things, one way you might "clean it up" is to Select All and copy to Notepad, then copy/paste back the other direction. This wouldn't get everything either...
  5. JohnCHolmes

    Word Spelling/grammar - excluded text

    I just saw something that I don't believe I've seen before. Upon completing a spelling/grammar check, instead of just saying "the spelling and grammar check is complete" it also added something to the effect of "sections marked for exclusion were not checked." I cannot even reproduce that extra...
  6. JohnCHolmes

    Trouble copying data based on contents of a cell

    Well garsh I took for granted you knew how. IMHO you really ought to have that skillset to mess with VBA. As a quick start, go tools/macro/macros, highlight yours, click Step Into. Then use F8 to step through the code. Pass your mouse over code variables to see current contents (for _some_...
  7. JohnCHolmes

    Trouble copying data based on contents of a cell

    Have you stepped through the code? Use the debugger. That can't possibly be less trouble than getting the solution third-hand. One of the things that debugging does is causes you to question exactly what you've ordered the code to do. Your code says "go end-down" (etal). Have you...
  8. JohnCHolmes

    The word macro below is supposed to

    I have a brute force solution. I humbly defer to anyone who has the "proper" solution; but since your question is not getting any grease, I hope you'll appreciate this much, despite my personal embarassment at this banality [tongue] I don't use the correct way to communicate between...
  9. JohnCHolmes

    Exit sub problem.

    You know, when testing these things and you have problems like this you should not suppress DisplayAlerts. Perhaps you're already beyond that point but it's generally good advice. Another useful practice is using Option Explicit, if you're not already. (It would appear not) There are...
  10. JohnCHolmes

    hi I am running Excel 2000 and n

    I don't have your answer but have general advice that might lead you forward. In the barfing code highlight .Connection and hit F1. Then click on the word Connection. Then click example and choose Connection Object. I believe this will show you the format you need, although I sympathize with...
  11. JohnCHolmes

    Multiple fonts within one footer

    Use your good friend record macro. It will show something like .RightFooter = "Pg. &P of &N ... printed &16&D&10 &T ... tab '&A' in '&F'&""Arial,Italic""(unsa&""Arial,Regular""ved file)" Can you run with it from here?
  12. JohnCHolmes

    Need code to change cell colors

    Regarding Zathras solution: It might be preferable to eliminate the ROW clause and instead just apply the conditional formatting to only rows 57+. The potential drawback otherwise is if you e.g. delete rows 1-50, the condition will still be married to 57+, and if you then wanted the coloring...
  13. JohnCHolmes

    Need code to change cell colors

    Well done - star.
  14. JohnCHolmes

    Save A Formula As A Comment

    Re the handy FAQ at http://www.tek-tips.com/faqs.cfm?spid=707&newpid=707&sfid=2892 I sent the author some suggestions. This is a placeholder for him to reply if desired.
  15. JohnCHolmes

    newbie-ish: iif in query

    RESOLVED. Squint hard at the original question. It has "ending double quotes," not "generic double quotes." Access barfed on them. I edited the actual query -- which is a 16-legged-hairy-mother query with parentheses out the yeng-yang -- in Microsoft Word, in order to use...
  16. JohnCHolmes

    newbie-ish: iif in query

    Thanks but Null vs. "" is not the issue. What happens when you run the query? Your answer may have collateral usefulness so thanks for sharing it.
  17. JohnCHolmes

    newbie-ish: iif in query

    Apparently I can not define a field as MyField: IIf(Left$([NAME],3)=”ABC”,null,[NAME]) The query designer forces square brackets, a la [”ABC”] and then interprets it as an unknown field (the popup that essentially asks " What is ["ABC"] "). IIf and Left appear to be...
  18. JohnCHolmes

    Access export to Excel

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q177991 XL: Limitations of Passing Arrays to Excel Using Automation Credit this answer to Tom Ogilvy in Usenet.
  19. JohnCHolmes

    Assign a Path when saving (URGENT!!)

    Steve, you gave an excellent answer. (kabnl is in a state of urgency now, and probably doesn't have time to say so LOL!). In case anyone wants to do this in Excel, prior to application.saveas I go dim foo as variant foo = Application.GetSaveAsFilename(, , , Title:="Set destination dir")
  20. JohnCHolmes

    batch file question

    I thought I had a perfect example but this looks like Doh! Yet Another user error (on me). It seems I saved the .BAT in 2 places (which were CD'd inside the batch) and drew wrong conclusions, not carefully noting where I was when I started. STILL I am seeing "1>" when the commands...

Part and Inventory Search

Back
Top