Search results

Hi - Thanks all fo your help, managed to get it to work, I recreated the module and tried it again, results as expected

Function validateMessageDate(Mdate) ' determines if another message has occured within 10 seconds of the MDate ret = False NDate = DMax("[MessageDate]", "tbl_BaseData", "[MessageDate]>#" & [Mdate] & "#") If (IsNull(NDate) = False) Then ' determines if next highest MessageDate value in...

I have changed it to a function (and updated the SQL- Thanks) still gives a error, seems to be the # that are causing the problem

Hi I have changed it to a function, it seems to be the # that are causing the issue..

Hi, Sorry still having issues with this, my table is called tbl_BaseData, when i try and run the code given i get the message, but i am getting the error, Runtime Error @2465': Microsoft Access can't find the field "|" reffered in your exession I admidt it is prob me doing something...

I have a table which I want to compare the time of two rows, and if the time is within 10 seconds return the two rows and ignore the other rows. i.e. from the table below it would return rows 3 & 4.. Row Date Computer message 1 28/08/2012 22:11:23 Comp1 Problem...

I guess the loophole was good in the sort term, but now how do they release guys they have held for 5/6 years, and say we have nothing to charge them with, you are free to go without answering why they have been held for so long. My impression is that once you are there, there is no process to...

There appaers to be no proof that these indivuduals are terrorist, if he have no proof that indivuduals are terrorists we should be willing to release them. if we can prove that they are terrorists then throw the book at them..

Ken, The point is that, you cannot hold people indefinably without charge at some point they need to be charged and found guilty of something or released. Just because they may be dodgy does not mean they are guilty. The only reason that they cannot be held on American soil is because they...

I aggree with you but I cannot see any future administration changing direction...

It is very easy to asume that all those held at Guantanamo Bay MUSt be some sort of Terrorist and therefore deserves to be held in detension, however I must admidt that I ammore than a little uncomfortable with the US holding them indefinitely, esp in a place where they have no "rights". Can we...

There I was thinking that this thread was about that superbowl half time show...

I am not sure the Aussies never blamed the ref, forward passes etc. They just few home with their tails between their legs, The Eng ref for the France vs New Zealand (Wayne Barnes) even had death threats, and his wilkpedia entry defaced and a "hate" website set up.

I would aggree, I do not think the English have been sore lossers at all. Most Rugby fans I know (bear in mind I have played/been around rugby clubs for 25 years), believe that the try was a very tight call, went against us, shame but never mind (win some/ lose some). Compared to the NZ...

Another question, Hilary Clinton has just been re-elected as the Governor of New York (I think) if she (or any other newly elected Governor) goes for president and are in the final running. Do they have to resign from being Governor when they run for President? Or can they return to Governor if...

and keep it for 10 years...

I think things will get very interesting soon, as the resources become scare. Africa that is the source, but is very poor will have diffrent countries competing for its resources (but don't let the african people benifit). damm if only we still had our empire we would be sorted..., If you want...

Whilst I may agree with the do-not resuss (in certain cases). I could never agree with actively killing a baby once it was born although I do not object to abortions. Once baby is alive and able to survive outside the mother (even with a little help) it is human. What I do think that there...

Ability to wash themselves, have a conversation that does not include any reference to Star Track or Star Wars. Really just being able to communicate and convert business requirements into code, oh yes and ability to wash themselves, (I know it may seem I have repeated myself but I know more...

Wosley Rich Made me laugh