> I think it's because it's trying to parse Personal.xlsb which I closed. How can I inspect only the project I want to inspect, rather than all open ones?
I have the following macro that opens an instance of IE and copies the data into an excel file. The code below works but the only way I could get this to work is to copy all of the web page then format the worksheet to keep only the data table. I did inspect the web page and tried to use the tabl...
Hi all. I just found RD won't load in Microsoft Access VBA, after not having used it for a couple months. Now it displays an error that it can't be found. Currently using v2.5.0.2544. Any suggestions to fix it..?
FYI - There have been a couple rounds of Microsoft Updates since the last time I used it, some including MS Office.
While RD is critical to my ability to work efficiently in the VBIDE now, I'm not sure I'd consider it critical in that installing a beta build that doesn't work is catastrophic. Worst case, you submit a bug report, then DL the previous version (and keep going back) until you find one where the feature that isn't working for you goes back to working (assuming a regression bug).
I almost never run a "production"/"release" build because there's usually a pre-release for the next build out before I get a chance to install the previous "release".
The worst thing I've ever had RD do was leave ghost Excel processes behind that had to be killed in task manager. That issue was solved a year or more ago.
IMHO, the "release" cycle just isn't quick enough (with the all volunteer workforce) to wait for the new features and fixes that are coming out in the various pre-releases.
I'd say a pre-release is as good as a production release, it just has a smaller version number bump
@this Ah! Much like the virus couldn't spread while I was eating last night, but it could spread when I was just sitting at my table waiting for the food to arrive. I thought maybe it was holding the fork that was keeping me safe, so I just held on to it for the whole evening.
@IvenBach What do you mean? The nice talking heads on major news networks assured me that it was totally A-OK. They even waved a letter from a bunch of health professionals saying that racism was the bigger pandemic. They are not going to lie to me, would they?
If the data is to be believed then we have 135,991 TOTAL DEATHS from COVID so far this year with 1,348 people murdered by Police. One is obviously bigger than the other but we don't pay the virus to protect us. Getting killed by the Police you were taught to trust as a child is the ultimate betrayal and the outrage is justified. The virus is going to kill people, for sure. The Police don't have to.
*US numbers because the US is the only country that exists on the internet
@HackSlash in 2020 alone? That sounds excessively higher. Last year, 1,002 arrests were fatal, that's out of tens of millions of arrests. However, of that 1,002 fatal arrests, only 55 were reported as unarmed.
@this it's different every year. You could say "over 1000". As far as "unarmed" people being killed I'm sure it depends on where you get your numbers. I'm seeing a study from 2014 to 2019 that shows an average of 152 unarmed people killed by Police per year. Sure, it gets more nuanced. What are they "armed" with? A hammer? A knife? A syringe? A gun? We could analyze each case but the fact remains that the Police kill people when their lives are not in danger. That's the distinction.
The number I cited comes from Washington Post fatal shooting database. Since they include everything from car to knife to toy weapon, "unarmed" means just that - unarmed.
However, the way I see it, that's not enough to actually say police kill people. If anything else, a police officer is 18x more likely to be killed by the suspect than the other way around. And what about the homicides? It's on rise. Where's the outrage over that? Kids are getting shot, and they want to talk about defunding the police? Boggles the mind.
I'm not questioning the definition of Unarmed. I'm questioning the justification of killing someone because they are "armed". I've seen a case where the suspect had a syringe they were using to shoot up heroin with. They claimed on the police report that he was armed but he wasn't going to kill them with a syringe.
Police are not more likely to be killed by the suspect. 106 police officers lost their lives on duty last year compared to your 1002 fatal arrests number. That's quite a huge disparity. 10 citizens are killed for each cop.
As you say, it will depend on the situation. A man wielding a syringe 30 feet away in a broad daylight is much less threatening than a man wielding a syringe close range in a narrow hallway. Unfortunately, the statistics can't cover that kind of subtleties.
Wow, so it's adjusted per capita as if Police are a separate population from the citizens? We all know you can make statistics say whatever we want. I'm not focusing on black people or police as being separate. I'm saying that 10 citizens are killed for every one cop. Therefore citizens are at a higher risk during an encounter with police.
Police are citizens. Black people are citizens. We are supposed to be all the same in the eyes of the law.
Yet the claim is that police targets black people much more often. That is not supported by the data, and also ignore the fact that for homicides, the #1 perp for black male victim is.... another black male, not a police officer. Seems to me we should be focusing on that, not police. If you want to argue that police reform is needed, sure, we should talk about disunionizing the police, so that they have more freedom to fire bad cops.
I didn't make that claim but if we look at the SO post you linked right there we see that more cops are killed by white suspects while more black suspects are killed by police.
No you didn't but that's the original basis of the mostly peaceful protest across the nation.
It's worthy of getting nationwide attention (and should have been addressed much earlier) but lately it's getting distorted under all the polarizing rhetorics of defunding police and not actually dealing with the roots of the problem.
That said, I know that I don't know enough about the proper procedures to follow in an arrest, so therefore I shouldn't be judging the more blurred cases (e.g. like the one in Atlanta). Better that it's scrutinized by people who actually know something about safety in arrests or other police-public interactions.
All I know is that other countries have better Police. There are other police forces we can learn from. Maybe we can buy training or procedures from them. We don't have to reinvent the wheel. We can look at what is working and put the pieces together over here. The UK, and Canada are good examples where the training material is even in English.
VBA Rubberducking
VBA Rubberducking