...loves to do things. You might see a couple of ideas there though (option to skip huge tables, e.g.)
As to your own, a line like
If 10000 * (lngRecordNumber \ 10000) = lngRecordNumber Then Debug.Print lngRecordNumber
might be likable, or
Debug.Print "beginning " & tdfTable.Name
though they'd...
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...
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...
...it also added something to the effect of "sections marked for exclusion were not checked."
I cannot even reproduce that extra clause, even when I *DO* mark a line and go {tools/language/set language} and click the "do now check" button, and hit F7 again. My uninformed observation is that...
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_...
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...
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...
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...
...although I sympathize with you as more frustrations may follow [sad]
By the way, in case it comes up ... whenever I start a New Access database I *always* first do this in the VBA window:
tools/references/check Microsoft DAO 3.6 Object Library
get RID of ADO 2.1
Others may disagree on the...
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?
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...
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.
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...
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.
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...
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.
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")
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.