Recent content by GIA

Perhaps, re the endif - but my answer was a serious one, reflecting back to one day when I insanely had a setfocus in a timer event. Can't recall what I was smoking at the time. [pipe] ------- "What is your favourite colour?" "Blue! No! Yell"

Global search your code for string "focus" - I suspect there's one somewhere, with a pesky side effect. No jive! [afro] ROFL!! ------- "What is your favourite colour?" "Blue! No! Yell"

Your question is vague, but I can say that there are not C language counterparts to such conversions as CInt or CStr that you find in VB/VBA. Guessing as to your problem, perhaps there may be something useful in casting(which would take a long time to explain), or in some of the ctype.h...

My only idea involves subterfuge :) Bury both in the page footer, oriented as desired. Set a Boolean when you hit the end of the report (bFoo). In the page footer, use iif(bFoo, (your content here), "") My other idea was to toggle off invisibility on the "secret" control...

Establish just what combination of fields (or a single field) constitutes duplication. That might be SSN, or {last name and phone}, or whatever. Then set an index on such, with NO duplicates permitted, on the table. ------- "What is your favourite colour?" "Blue! No! Yell"

Try an update query using Left(myField, InStr(myField, " ")-1) ------- "What is your favourite colour?" "Blue! No! Yell"

Go myTextBox.SetFocus (i.e. comments.setfocus) first. Yes, that seems totally lame to have to do that, but until someone explains otherwise, that's what I have to do to modify a text box in Access. ------- "What is your favourite colour?" "Blue! No! Yell"

Cool - an ancient thread breathes again! Are you saying that you are starting an .EXE that was written in Access, or Access 97 itself? ------- "What is your favourite colour?" "Blue! No! Yell"

Cool - an ancient thread breathes again! Are you saying that you are starting an .EXE that was written in Access, or Access 97 itself? ------- "What is your favourite colour?" "Blue! No! Yell"

No problem. I only spent about 20 minutes of my time giving you the original answer, which WAS the answer, right? ... (hmmm, what's my hourly rate... oh, nm). I was pretty proud of that answer, too - I'm not 95th percentile material on everything I do, but on that question I believe I was. I...

Others should pipe in as to the best method for you to learn SQL (vs. the piecemeal living-on-the-edge education-by-error I experienced). That learning which really should be a prerequisite to messing around with "TOP n". But short of learning it the "right" way, one thing...

It sounds like you've hit a bug, and whether you have or not, your dilemma is a frustrating one. We feel your pain. Well, please don't let this insult your intelligence, but sometimes it doesn't help to restate the obvious... scandisk repower the machine + 10 seconds (not just reboot)...

Thanks for weighing in - yes, that's a good one. :-9 "What is your favourite colour?" "Blue! No! Yell"

You might back door it as follows: use SELECT TOP 3 ... after reversing the sort sequence. Of course, this presumes that you can sort the 3 in question to the top (or bottom :) ), which should be achieveable - if not by a time-logging field, then by a sequence counter. In fact, by golly, you...

Because Excel has a limit of 65,535 lines, which can not be beaten. "Outside of a dog, a book is probably man's best friend; and inside a dog, it's too dark to read" - G. Marx