Search results

By throwing parties for the Queen, apparently:rolleyes:

That wasn't one of the options... unless, of course, you were about to make an argument which proves his intellect, bearing, and countenance are on par with yours...:eek:

I believe we've already accounted for the existence of two such beings... I'd simply like clarification on which one is Satan :eek:

We might actually begin to realize the implications of such an event within those few nanoseconds before all of space/time winked out of existence :D

Doesn't matter what we think, Col has indefatigably proven that they must be born here...and everyone knows he's always right:rolleyes:

According to the Psychoanalytic Quarterly, the formative years are birth to age five...:cool: I must admit though, the whole "you are", "no, you are" thing begs to question if those years have yet elapsed in the forums...regardless of who exactly is translocating what urine :p

But where is he taking it?:confused: and why?:confused:

:D :D Undoubtedly one of the funniest, if not the funniest, movies I've ever seen. Sorry, Gary, I'll stop hijacking now.... It was at a funny angle:D

and he's still a Korean... If you're gonna make us claim him, we also get Chaplain, Hope, and Lennon :D

Learned that one from Snatch...great movie. I needa get me ma a new Caravan...she's partial ta' t' periwinkle blue, bays.

ahh yes...our colonial/empirical differences again. Tell someone you're in desperate need of a fag in London, you'll probably get offered a smoke, but I submit the result would be somewhat different on the streets of San Francisco:eek: The Dog's B*llocks is a good thing?? :confused:

In the words of your distinguished collegue: Since everything Col speaks is truth and he is never wrong, the gunman was undeniably a Korean.:cool:

you're welcome :)

He most certainly was not. He was a resident alien:

He did specify hunting, Rich.

yes. assuming you mean DLookup("CUR","CURRFG", "SOBP = 5") oops:o strDBCura = "Update " & RsType!sobpdebit & " SET DebitDBN = Debits * " & DLookup("CUR","CURRFG", "SOBP = '" & RsType!SOBP & "')" & ";"

Replace the RsCur with a DLookup... strDBCura = "Update " & RsType!sobpdebit & " set DebitDBN = Debits * " & DLookup("CUR","CURRFG", "SOBP = '" & RsType!SOBP & "';" I wrapped the criteria of the DLookup with single quotes, assuming it was a string, if it's a number, remove them...

Dim i as Integer For i=0 to me.Controls.Count-1 Me.Controls(i).Visible = False Next i

First off, just to make sure we are on the same page, you know that: Set RsType = CurrentDb.OpenRecordset("SELECT SOBP, SOBPDEBIT FROM RFGDebitNotes ;") produces a recordset, not a single answer, correct...

You cannot reference the recordset you just created in code in another SQL statement...it must be compiled into the DB for the SQL statement to recognize it. Using Nested SQL statments will get you where you want to go.