Search results for query: *

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

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.

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

In W2K all file redirection (e.g. >FOO) does not work from batch files. What I see (echoed) is 1> instead of > Anyone know why? Please don't answer if you don't know. Or at least _say_ you don't know, if you just want to venture a guess. The then "leading expert" in this forum was...

In W2K his more.com often will only scroll 1 line at a time after the first pause, as opposed to giving me another 24 lines as he's supposed to. Anyone else have this, or can shed light? I haven't isolated the condition; it doesn't misbehave as such 100% of the time.

I opened a Novell drive (G:) and a local drive (C:) that both contained an identical 2-day-old file. 1. I opened the file from the C: folder - an Excel file. 2. I saved the file. 3. I dragged from the G: folder to C:. I used right click to drag. I chose copy. His Replace? dialog showed the...

I cannot print even a test page to the 2 afflicted network printers that show status of "opening" (instead of of "ready"). What do I need to do? (Already tried simply restarting) This happened suddenly after prior normal usage of both, when I tried to print from Excel...

In W9x you could have a shortcut in ANY derivative of the Start Menu dir, and it was ALWAYS be seen in terms of its hotkey. E.g., if you put notepad.lnk in \windows\start menu\FooBird, with Ctrl-Alt-N attached, then it was accessible everywhere, always - even from a DOS window, which is quite...

Can someone tell me the location of the testicles of the Access designer who whimsically updates the "Modified" date? This is not just for compacting either, and not just on Reports, though those are the WORST offenders; only tables seem to be immune. So I'm looking for a fix -...

I'm grateful for the Selection.Resize solution to the thread "Help with Excel macro recording and absolute addresses" (BTW, has anybody ever gotten Tek-Tips search to work?!). I have just successfully tried reducing the current selection by 1 row, using...

I have a worksheet that End-Home insists ends at BM1452, but I want it to end at AJ1452 (It DOES end at AJ1452 @#$%!). So I go to AK1, hit Ctrl-end-home, and Edit/delete/columns. Well, the problematic columns won't go away. Naturally I saved the file; I even restarted Excel. But those...

Surprise, surprise - bet nobody's ever had macro-record do this, huh? (Moreover, has anyone ever really wanted an absolute reference recorded?! Seriously - ever? See footnote). Well in Chapter 47 of the heartwarming story of these absolute references, today I would like to know how to extend...

This may seem minor, but for heavy keyboard users it is truly a PITA. When I minimize IE on this machine (only), it comes right back up when I hit alt-tab. On all other machines it drops to the end of the "alt-tab" list. I know that it SHOULD do that when you minimize by just...