Search results for query: *

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

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

Thanks for your SOLUTION which I don't always get to say. Wtg! I grew a lot from your post - things I've been needing for a long time and never learned. You are correct, sir. Since long-term computer veterans are most often seen using them, hotkeys might appear to be an artifact of...

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

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

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

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

xlbo - want to reconsider that response?

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

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

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

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

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

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

Is everyone aware that Access reports will show 800 instead of 1,800? That's right - no asterisks or warnings. This WILL happen if a field width is not wide enough ... or you didn't remember to set CanGrow. In fact, the report wizard often burns me - and I suspect many of you - on this on...

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

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

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

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?

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