Recent content by Orthodox Dave

Hi PatAccess, The others are both right but there is more. I would suggest an alias for Hyperlink. Although it is not an Access reserved word, they might make it one later so be safe. Let's call it HLink Mark's point is that you are declaring a variable then testing it before you have even...

Thanks Doc Man. Maybe you should run for president! This is very much a live debate in the UK at the moment. Don't know if this got into the US news:- https://www.bbc.co.uk/news/uk-44510224

Great attitude! And I'm sure if / when you return to the US permanently, your experiences will enrich all those around you. That is, of course, if you win the argument with your wife about US / Scotland! In my experience, the women usually win!

And then we call the French arrogant!

I think you need to requery the list box after your code: Private Sub txtfind_Change() Dim strSource As String strSource = "SELECT * " & _ "FROM Guests " & _ "Where FirstName Like '*" & Me.txtfind.Text & "*';" Me.List0.RowSource =...

Sorry not clear whether you meant Napoli or Virginia? Yes it's always interesting to try and work out why cultures are so different in different countries. You (NauticalGent) are a travelled American, but as I understand it most Americans don't even leave the country. It's an enormous country...

I hope the Al Gores of this world are wrong. But I think we can all agree we would all like less pollution. Air pollution kills around 9,000 people a year in London alone. It seems like a good idea to look hard for cleaner energy sources. Since research is expensive, it won't get done unless...

The overreaction to cannabis in the 20th century led to its being made illegal, not only for recreational use, but even for medical research. And yet, heroin (known as diamorphine) can be prescribed here in the UK. It beggars belief how this could happen. Opium, a highly addictive drug and the...

The answer appears to be "No". Or perhaps there is someone, but they daren't admit it on this forum!

Nautical Gent - I understand your pain. A friend of mine has a large shed in the garden with heating and his own TV and music so he can watch and listen to what he likes. We have to live on the same planet (or even the same house) as people with different tastes, but I suppose that's life's rich...

Yes, in the UK the original name is Mothering Sunday and dates back to the 16th century:- https://en.wikipedia.org/wiki/Mothering_Sunday People still call it Mothering Sunday, but it's more often called Mothers Day these days (the US name won through, but the date remains as it was). Father's...

Yess!!! (Blimey am I the first to respond?)

Actually Frothingslosh, I couldn't agree more. I am sorry. I never normally do this and nor do I agree with it. In this case, I merely wanted to make the point for anyone who assumes religious people are stupid. In fact IQ just shows you can solve problems, that sort of thing, but you can have a...

Thank you Doc Man for taking the time and trouble to explain your carefully-considered and honest view. It is very much appreciated. One thing we can both agree on is that life is a very precious and rare commodity in the universe, although we now have it within our capabilities to destroy it...

Thanks for putting me straight missinglinq. Grasping at straws perhaps. Meanwhile TyBement has no solution to a problem that looks simple on the face of it. Could it be that a library reference is missing?