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

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

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

Being a red-blooded lazy programmer, whenever I need to do something new with macros, I "record" 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 "record" 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...

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/"feature" is that HIGH ORDER DIGITS ARE DROPPED...

"One or more messages in your Outbox do not have a valid account specified." OL 2000 on Win98. This happens, at least today, when I reply or forward on a message; but "new message" (i.e. compose) seems fine. That error message shows upon clicking "Mail delivery...

Would someone confirm this sorting in Excel 2000? Paste the 6 values in a1 through a6, select all 6, and sort with "no header." 2F 2FA 2F--A 2FB 2FC 2F-R vlookup(...TRUE) appears to respect the same as its implied ascending sorted order. Whadya think, Dale?

When I tell the IE5 to "Edit with Word for Windows" (on the File menu), I get nothing short of a violent epileptic seizure of jiggling/blinking on the screen. Eventually I can calm it down after deleting banners and tables, but it feels like it's giving me brain damage even trying to...

Where in the dickens do they hide the Most Recently Used files (the ones that show under File menu)? I swear, I've thoroughly searched the Registry (finding Access and Excel's with no problem). And before someone gives the rocket science answer of "why don't you just click File?", it...

Is anyone else fed up with this error? Today's lovely contestant is (as seen in the debug window) ?range("CurPlan") which is a single cell which was created by Insert/Name/Define. While the macro is not running, ?range("CurPlan") gives the correct contents. As soon as I...

Is there a variable that tells if the conditional formatting has been tripped? More on my specific quest: I have a routine that looks for shaded cells with For Each c In ActiveSheet.UsedRange If c.Interior.Color <> ActiveWorkbook.Styles.Application.Cells.Interior.Color Then However this...

This regards PrintScreens of mainframe sessions which are the lovely green-on-black [afro2], pasted in .DOCs. My desperatation tactic has been futzing around with print properties - gruesome and flawed; besides which, that varies by printer and printer driver, right? I hope someone knows a...

I have a routine that looks for shaded cells with For Each c In ActiveSheet.UsedRange If c.Interior.Color <> ActiveWorkbook.Styles.Application.Cells.Interior.Color Then However this apparently doesn't catch conditionally formatted cells. c.Color doesn't get it. Since there's no @#$%ing...

(Cross-posted to Microsoft: Office Forum, which I believe is a distinct audience from this) I'm looking for a C.Y.A. routine to alert me when I have Excel columns that are too narrow, causing ##### to print. I'm hoping that someone has an ingenious solution, though this might require hooking...

(Cross-posted to VBA Visual Basic for Applications (Microsoft) Forum, which I believe is a distinct audience from this) I'm looking for a C.Y.A. routine to alert me when I have Excel columns that are too narrow, causing ##### to print. I'm hoping that someone has an ingenious solution, though...

Do you guys use the &quot;Sorting and Grouping&quot; box for Access report design? I'm wondering how this runs up against what you put in the query design view. I'm hoping that I can avoid exhaustive testing if someone else (you!) is already strong on it. Can you confirm or refute the...

Do you guys use the &quot;Sorting and Grouping&quot; box for Access report design? I'm wondering how this runs up against what you put in the query design view. I'm hoping that I can avoid exhaustive testing if someone else (you!) is already strong on it. Note that this isn't worrying with...

This is code to search for several terms in MS Word. For [a stupid but illustrative] example, if you want to find the next vowel in a .DOC, give this sub arguments a,e,i,o,u. It uses comma as a delimiter, but allows backslash/comma for a literal comma. I believe this to be reliable code for...

I'm having a problem determining the cursor position (&quot;insertion point&quot;?) following EditFind. I also want to use SetSelRange to restore the position to the point prior to the find, but I'm not confident in it either. After all the hours of trial and error, it looks like the code is...