Search results

Got me there, he was the last noun so my pronoun would refer to him, but no I meant Roy Orbison. Brian

And now you are an annoying old tit, which means being down South correct. :D Brian

Mark to save typing in the future you may like to know that those plastic ends are called aglets. Brian

Saw him live, very impressive. Brian

Eg sheets("sheet2").Range("C2")=sheets("sheet1").range("A1") If you are doing a lot of such coding then Dim sh1 as worksheet Set sh1 = sheets("sheet1") Then you can code sh1.Range("A1") Brian

Abbreviations and achronyms are common and used by us all, think MODEM RADAR it's local idioms that can be the problem, but in this case anybody with a brain cell following the thread would have known whom Dick was alluding to. Brian

Do you always have to have a dig at someone or something, Dick did not claim that they were his so just enjoy them. Brian

Thank you for coming back, I don't understand all that has happened but I am glad that it is working as it should. Brian

Talented Brian

That does not make sense unless Access has changed since I last used it as there would be no date check for the OR criterials . Any chance you could copy and paste the SQL view into the thread just to satisfy my curiosity. Brian

The code shown by arnelgp is SQL code, you can view the SQL generated by the design grid by selecting the option from the drop down menu. The * means show all columns. Did you try each criteria separately in a query to see if any records met the date criteria? Brian

I suppose I should have put a smiley after my second sentence, I was merely spouting the usual crap that the gun lobby does, a gun locked away and made secure is hardly useful as a defence against an intruder, which is their argument for having one. They argue all ways depending on what suits...

I take it that is in reply to my last question. Of course it is not gun ownership that is the problem but that the family did not keep the gun safely locked away blah, blah .... Brian

There is no need to incur the cost of a function call to DateDiff as your date test is correct, on the other hand why check on status if you want them all. I cannot see anythink wrong with what you coded, remove the first line of the criteria and see what happens, maybe none of the others meet...

You're kidding, right? If not what on earth was she charged with? Does this mean if you are a lousy shot and miss you will be charged instead of being let off? Is America really that sick? Brian

They certainly make it easier and less personal. Brian

Well Froth my post was somewhat tongue in cheek, and I agree that things need to be addressed in many areas, it's the fact that they won't even consider any form of meaningful control or dialogue that I find so appalling. BTW That long ago series "The A Team" was considered one of the most...

There are accidents and deaths on the roads but we don't just say it is the culture and do nothing. There are lessons and tests before one gets a licence to drive. Manufacturers make technical advances to make cars safer. Roads have restrictions All of this is monitored on a daily basis by law...

You're right Dick, the problem is the American culture, so the only solution is to kill all Americans and the problem is solved. Brian

Missed this as it was not in the EXCEL forum. Just With Sheets("Sheet1") .Range("A" & i) = "'" + a .Range("B" & i) = "'" + name End With is all that is required. Sheets("Sheet1").Range is a range no need to set rng1 etc Brian