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 Rhinorhino 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. larryww

    re MS Office's lovely grayed/ungrayed menu items

    Does anyone know a way to manually manage these? I'm referring to the graying of certain menu items in Office products. It's ostenisbly MRU based, but behaves more like MS-PrimaDonnaDeveloper-mushroom-induced-capriciously based. For ANY MS product, do you know how to gray out a...
  2. larryww

    reduce MS Word file size

    To answer your question, you could chop up your document and build files to link in. E.g., delete all but the first image, and save it as image1.jpg; substitute a link for the embedding; etc. . I do not know of a way to do this except by this manual process. I can't tell for sure, but forgive...
  3. larryww

    hunting for a VBA keystroke

    ...I used it to the letter. Well, except on item 2, I used the menu area - I don't have no stinkin' toolbar sucking my vertical space there, lol. * Thanks again. * (I'll agree that some toolbar clicks are just as good as key equivalents; but it's best to have both weapons. In this case not...
  4. larryww

    hunting for a VBA keystroke

    In my quest for world's laziest - I mean, most energy expenditure efficient - I am looking for a keystroke to close the project window (the one that opens with Control-R). [spineyes] It's sapping my strength to have to reach over to the mouse to do that. [yawn] Is there a "Close&quot...
  5. larryww

    Excel macro question re code exporting

    Way to go! That's it. It did need a really difficult, nearly impossible to find Tools/Reference (way to go Microsoft, you clueless fools). Chip Pearson saved me in http://www.cpearson.com/excel/vbe.htm (I predict Gates will next have them place Automatic Recalc under Microsoft DAO 3.6 Object...
  6. larryww

    macro condition clause help?

    Solution achieved: DCount(&quot;*&quot;,&quot;MSysObjects&quot;,&quot;type = 1 and name = 'tblFoo'&quot;)<>0 Works right there in the condition column
  7. larryww

    how to delete the rows below the last cell that contains data

    While I'd like to think that Lotus's &quot;minimum recalc&quot; talents of the 1980s - whoops! Strike that! Time warp! Gates doesn't allow optimization; it's anti-Wintel! Before answering, I would say that it's bold to take a language you're unfamiliar with and embark on a deleting crusade...
  8. larryww

    how to delete the rows below the last cell that contains data

    xlbo - want to reconsider that response?
  9. larryww

    Generate or modify VBA on the fly?

    I must protest! Not really meaning to be harsh, but firm: Speaking generically, as I have not worked much with Outlook: Doing such by modifying code, if even possible, would be somewhat against the laws of nature. Instead, store/save a &quot;flag&quot; somewhere that tells that the One-A-Day...
  10. larryww

    macro condition clause help?

    BTW, oops - looks like that function is wearing a Sub coat [sadeyes]
  11. larryww

    macro condition clause help?

    Thanks, Rick. I hoped to avoid a UDF, but since it looks like I must, that's a pretty tight and clean yet fully explicit explanation (wtg! May all my questions be answered thusly LOL). I tried various things in the condition column...
  12. larryww

    macro condition clause help?

    When you open up the condition column in (A2000) macro design, you can put a UDF (or other function that returns True or False) whether to execute a macro statement(s). I've seen examples with IsNull(). How would I condition based on whether a table exists, such as IfExists(tblFoo)? IsObject...
  13. larryww

    Excel macro question re code exporting

    xlh that looks fantastic - I will have to set it aside for just now but will advise if any hickups arise.
  14. larryww

    Excel macro question re code exporting

    Being a red-blooded lazy programmer, whenever I need to do something new with macros, I &quot;record&quot; it and then imitate the produced code. But oops, I can't cheat this time because what I want to do is export code to a .BAS ... you can't &quot;record&quot; actions in the VBA window...
  15. larryww

    CanGrow problem / bug

    ...that's the case in my version of Access (2000): CanGrow is turned OFF by default. I have to remember to set it to true on each and every report* ... or play Russian Roulette in guessing whether adequate field widths have been set. The problem/bug/&quot;feature&quot; is that HIGH ORDER...
  16. larryww

    Serious reports bug?

    Thanks for your response but this is still rolling snakeyes. Yes, when CanGrow is &quot;tripped&quot; it grows vertically, but in so doing it beneficially exposes the high order (that would be clipped off in its absence - i.e. the high order would be unseen without the vertical growth. Thus...
  17. larryww

    Formula: days since sheet was last modified?

    How about doing this on BeforeSave instead of Change (since I don't see an AfterSave)
  18. larryww

    Serious reports bug?

    In my version of Access (2000), CanGrow is turned OFF by default. I have to remember to set it to true on each and every report* ... or play Russian Roulette in guessing whether adequate field widths have been set. The problem/bug/&quot;feature&quot; is that HIGH ORDER DIGITS ARE DROPPED...
  19. larryww

    Printing labels from Access

    Tek-Tips has a bad problem with semi-colons in URLs and this happens a lot a lot a lot because the Knowledge Base URLs all seem to have them. I don't see a feedback link. I wish this could be rectified. Can someone report this?
  20. larryww

    Can you split a window in Excel like in Lotus 123?

    Dale is right - that's the way. I think both scott and I misunderstood you to mean 2 worksheet files.

Part and Inventory Search

Back
Top