Recent content by cheekybuddha

If notes will be the same for every possible inserted record then you can try: oDB.Execute "INSERT INTO Discrepancies( Accession, Main_Family, Genus, Infra, Raw_Box, Collection, Notes) " & _ "SELECT B.Accession, B.Family, B.Genus, B.Infra, B.BoxNo, B.Collection, '" &...

What is your question? Do you have an error? It looks like you need an extra space at the end of the above: "WHERE A.Main_Family ='" & sFamily & "' " & _ ^ | space here Also here...

No, it wasn't. Just cool your boots. It's OK to disagree without resorting to acting like you're in the playground.

Wow! :oops: Can they do this anonymously? Do you get any idea of who reported it?

QED Try it for any mod! The ignore button isn't there. You can't ignore mods.

Is that because you only Debug.Print when you are in a Level <> 1 ? Perhaps move that line outside the End If ?

Can you give us an example of such a library?

If Colin's links above don't help, then post the code you use and explain where it faults for you. Are you saying your target machines do not have the required dll's registered on them?

What results do you get when you try using Doc's suggested search?

Not me. You. You're the mod. Guess you have to evaluate everything in terms of whether Jon might end up bankrupt now. I reckon everyone has a fair idea of where the line might be - now they will have to think harder about how close they want to sail.

Not quite sure why you're being such a drama merchant. Just behave on the boards like a half-way decent human being and everyone will be fine. If you step over wherever the arbitrary line is, the mods will take care of it. It's annoying, but them's the cards that have been dealt.

:ROFLMAO:

1. See post #1 2. Wait however many years until the government of the day realises how totally unworkable this legislation is and how it will not have any effect against its intended targets, yet completely harms unintended targets.

I'm glad you got it, Doc!

This is perfect theory. But the reality is that, even if Jon is charged with a case that is spurious, he has to come up with the legal costs to defend and fight it, which are unlikely to be recovered even if he won. That is the problem with this legislation. It's not really about 'complainers'...