Search results

Create a pass through query so the server carries the load that Access is unable to handle, the server will then return only the requested records. The speed of this approach will depend heavily on server usage.

Form_MouseDown is triggered anytime the user clicks anywhere on the form

highlight the column and press the sort A-Z or sort Z-A button

Try either redefining your [SumofDuration], [SumofPreparation] , and TotalHours fields as decimals or doubles, or typecasting calculations: TotalHours = (CDbl([SumofDuration])+CDBL([SumofPreparation]))\60

and just because I can't resist: David Battley -- KRULL (he was Ergo The Magnificent):D For that rudeness, lout, I shall turn you into a bat! ...no, that's a recipe for hot fudge sauce... ...oh well, it'll have to be a goose...fat and ugly...

Peter Boyle -- Young Frankenstein <thump> <thump> ooooootin oooooon aaaa iiiiiiiitz!

if fOSUserName is a string, you'll also need the single quotes. also, your function doesn't return anything, lookuplevel2 must be defined as Public Function lookuplevel2() as String in order to return a string value (if you change it to Integer, you can clean up the entire second function to...

Joe Pesci -- Raging Bull

Pierce Brosnan -- The Thomas Crown Affair

Brian Cox -- X2

Ed Harris -- The Abyss

Happy B-Day, SJ

ahhh...but a classic from the golden years when British Sci-Fi ruled Sean Bean -- LOTR: The Fellowship of the Ring They have a Cave Troll...

Liam Neeson -- KRULL "I am Ergo The Magnificent. Short in stature, tall in power, narrow of purpose, and wide of vision... And I do not travel with peasants and beggars, good-bye"

you listen to the "Oldies" station and they play the song that reminds you of the summer of your 16th year, driver's license, first car... wait but that would make me...

When my wife and I bought our new house, my Mom & Step-Dad thought it was time for all of my belongings which had taken up residence in their basement, to come home to roost. A couple of months ago I was going through boxes of junk that are still cluttering my basement and came across not only...

first, the old faithful "remember to compact and repair" second, if the code doesn't compile, you can't create an .MDE file, so drop into the VBA window and choose Debug-Compile. Chances are you'll find some hanging code somewhere.

You are exactly right... I shall cease and desist further heavy handed attempts to draw unwarrented parallels between seemingly innocuous statements and anothers national heritage. That was childish, uncalled for, and belongs in the political forum with the rest of the stereotypical name...

funny, the ones on the forum that spend the majority of their time whining a bitching don't seem to be American:confused:

Tom Wilkinson -- The Patriot