Replies

Just to add to this, for anyone running one of the above processors who is wondering if this will matter to them, although this deprecating of DirectX 12 is only just being reported around the internet now, driver version 15.40.44.5107 (the first version to deprecate DirectX 12) was actually released on 10 January 2020, so if you’ve updated your Intel graphics driver since then then you will already know if this affects you.

1 user thanked author for this post.

Alex5723

-Spoilers below, just as there are in Oscar’s above posts-

I’m glad that you enjoyed it so much, Oscar. I hope that you enjoyed the progression of Korra’s character as much as I did; it’s so rare to get physical disability and mental struggles addressed in a show primarily aimed at younger viewers, and rare just generally, so I was very pleased to see it and very pleased that it was handled so well.

I agree that Kuvira isn’t the most original character, but she wasn’t just a stock character and very much had her own reasons for doing what she was doing, and it allowed for some good action, so I have no real complaints there. I’m also glad that they addressed the inevitable side-effects of the previous seasons, with Kuvira being largely a result of them.

I also very much appreciated the evolution of Korra and Asami’s relationship, even if the creators weren’t allowed to do it properly.

Overall, I suppose that I just really appreciate the maturity of the last couple of seasons, it wasn’t something that I expected. Having the protagonist realise that personal maturity and self-reliance and power aren’t necessarily the same things and is very mature, and a good lesson to be teaching the primary target audience. I also felt that her struggles gave her vulnerability that wasn’t there in the previous seasons, which allowed me to empathise with her a lot more.

So yes, an excellent show.

I saw this question earlier, but I thought that I’d leave it for 24 hours in case someone else came along to help, as I don’t have any experience with MS Access specifically. I do, however, have a lot of experience with SQL and databases in general, and MS Access largely implements SQL, as far as I’m aware, so here are the queries you want in SQL, as best as I can think to implement them:

Query 1:

SELECT [FY/Qtr],
COUNT(DISTINCT Store) as Store_count,
COUNT(DISTINCT Product) as Product_count
FROM table_name
GROUP BY [FY/Qtr]

Query 2:

SELECT [FY/Qtr],
Store,
Product,
COUNT(*) as Count
FROM table_name
GROUP BY [FY/Qtr],
Store,
Product

Query 3:

SELECT Product,
[FY/Qtr],
COUNT(DISTINCT Store) as Store_count
FROM table_name
GROUP BY Product,
[FY/Qtr]

The key to all of these queries is using GROUP BY. GROUP BY creates summary rows based on the specified columns, which can then be SELECTed from, both directly by column name and by using COUNT(), which does what you would expect.

You asked about DISTINCT – DISTINCT selects only different values, ignoring duplicates. This can be combined with COUNT, although I did want to check that this would work with MS Access, and it seems that Microsoft implements COUNT(DISTINCT) in a different way – click here to see how to convert it (I won’t do it myself because I don’t have access to Access).

As an aside, I note that one of your column names is FY/Qtr. Anything other than alphanumeric characters and underscores should be avoided if at all possible in database column names, so I suggest that you change it to FY_Qtr. You will note that, in the above queries, I have enclosed FY/Qtr in square brackets – this is to avoid problems and should be done if you are unable to change the column name.

A long post, but I do enjoy a coding challenge. I hope that this all helps!

I obviously agree that there are such things as false positives, and certain security programs can be more overzealous than others, but it takes less than a minute to Google an exe and upload it to VirusTotal, which is a small price to pay for increased security.

1 user thanked author for this post.

globalist

Allowing restricted access to an untrusted process and seeing what happens is generally a very bad idea. You should always Google the exe and upload it to VirusTotal to make sure it’s not malware first. The process is likely to be untrusted by your virus scanner for a reason!

As it happens, you’re lucky, because DDVDataCollector isn’t malware, although you may not want to allow it since it’s a Dell telemetry tool that collects everything you do on your computer, including the websites you visit, and sends it to Dell.

It will keep prompting you if you block it again, though, so the best way to disable the telemetry is probably to open Dell SupportAssist, click on Settings, click on Privacy, and disable the telemetry there (if you can, I don’t own a Dell computer to check).

They are both great shows, agreed. Hopefully you will feel the same as I do about the relative quality of the seasons, because then you will enjoy it even more as it goes on!

OscarCP wrote:

So is the “Avatar” (noun, not verb), the main character in ATLAB and in “Korra” successive incarnations of an actual god come to Earth in human form? I do not remember seing that said, implicitly or explicitly, anywhere, hence my question. Does anyone here knows more about this?

The origins of the Avatar are explained in The Legend of Korra (in the second season, if memory serves me correctly). It’s really rather spoilery, so I won’t explain it unless you really can’t wait and want me to.

(I tried to include the reason in a Read More tag, but it deleted my post upon editing, so that seems to be a bit buggy.)

1 user thanked author for this post.

OscarCP

First of all, to anyone considering watching it, it is very much a sequel to Avatar: The Last Airbender, and shouldn’t be watched without watching Avatar: TLA first.

As for my opinion on The Legend of Korra, which I watched several years ago, I will try to give what I found to be the positives and negatives, because it’s not all good and not all bad.

On the one hand, it is, overall, inferior to Avatar: TLA, which isn’t surprising considering how good Avatar: TLA is. The main thing is that the characters just aren’t as likable and don’t have the memorable personalities. This is no surprise, though, as the main group in Avatar: TLA are just absolutely wonderful and I’d watch a show just for them regardless of the plot! I also didn’t find the story in Korra as compelling as the story in Avatar: TLA, perhaps due to the fact that I wasn’t as invested in any of the characters for a lot of it, perhaps due to the fact that I was used to the world, perhaps due to the fact that it just isn’t as good. I also felt that the writers achieved the first half of Korra’s growth as a person simply by making her headstrong and constantly make bad decisions, which is such a tired way of doing things. Aang didn’t need that to grow.

On the other hand, it is still superior to the vast majority of animated shows out there. It suffers because people were expecting another Avatar: TLA, and it was never likely to reach the great heights of that show. Sequels to great shows and movies just don’t tend to be as good because of regression to the mean, after all. And while the first half of Korra’s growth is weak, the second half is excellent, especially in the fourth series, which tackles more mature themes (I can’t say more because of spoilers, but it’s very well done). She goes from a character that I found irritating to a character that I truly liked, and that is a rare thing.

Overall, it’s very much a show that is worth watching if you enjoyed Avatar: TLA, just don’t expect it to be exactly like Avatar: TLA or quite as good as it. And even if you are unsure after the first season or two, it is worth sticking with, as the third and fourth seasons are much better, in my opinion.

When you enter a web address into your browser, the browser requests the IP address that corresponds to that web address via a DNS (Domain Name System), so it knows where to direct your request. By default, browsers do this unsecured, which is obviously vulnerable. Firefox allows you to (if you’re in the US, if I recall correctly) make the request over HTTPS, which is more secure, although not invulnerable.

The only potential downside is that Firefox does this by using the Cloudflare service by default, so it comes down to how you feel about that company. As I recall, Cloudflare did an external audit of their DNS a while back and found that some data was unintentionally kept for up to 24 hours in a tiny minority of cases, but the audit was very transparent and it seemed to me like that they were prioritising privacy, and they did pass the audit, so I would personally not have a problem with them.

Excel is so bad at dealing with CSV files and has been for years, it’s infuriating. LibreOffice knows how to deal with them!

I’ve given this some thought and I have three thoughts:

1) Add an optional Unit input box to the form. This is the best solution that I can think of as it maintains exactly what the customer wants and keeps the pieces of data separate. If you want to make it more readable for the company then, when processing the form data, concatenate 2 into “Unit 2” IF the input box contains data.

2) If 1 is not possible, a simple hack would be to force 2/6 into a string by concatenating 2/6 into ” 2/6″ when processing the form data. Note the space before 2/6. I don’t have access to Excel right now, but this should keep it as a string I think?

3) You may want to be more thorough than 2 by using a regular expression search and replace to convert 2/6 into “Unit 2, 6”. This would be less reliable, however, since there might be variations on 2/6 entered.

Overall, I would recommend 1 if at all possible.

Hope this helps.

A lot of forums allow you to set your location in settings and it will adjust the posts to your time when outputting them. This allows the post time to still be saved in UTC (or server time, but that has issues if you move server location). This isn’t an option here, however.

If Susan wanted to implement it but didn’t want to add a setting, she could also consider retrieving the time zone of the user by using JavaScript, but this is less privacy friendly than just asking in settings, so I wouldn’t use this method myself.

An interesting fact about UTC: it’s not actually an acronym. The Americans and English wanted to use CUT (Coordinated Universal Time) and the French wanted to use TUC (Temps Universel Coordonné), and the compromise was that they used neither! I’ve always loved that fact, I hope it’s true.

Hats off to Mozilla for managing this, but my first thought is how long is it going to be before Microsoft blocks their method? They can’t go letting people have choice on or control over their own computers, now can they…

Also, even though they “seem” to be dead, beware of damaging the batteries as lithium batteries can catch fire and even explode if there’s any charge left in them at all.

While you would probably be fine, I would really emphasise this. You do not want to have to evacuate your house because of a breached battery! While it’s a pain to get in to, it does look for anonymous’ videos that it is possible to do so, so you can take out the drive and then just give that the hammer treatment.

2 users thanked author for this post.

BobStr, Steve

All is good 🙂

I’ve not watched it yet, I’ve had a hectic few months, but I’ll make a note to let you know in the animation topic when I have watched it.

1 user thanked author for this post.

OscarCP

Please don’t take my comment the wrong way, Oscar, I was simply letting you know that your posts are showing up as you intended. I assumed that you were wondering if they were to others and that’s why you had said “Everything looks normal to me.” and posted the screenshots. I have no opinion in any direction as to post styling. Sorry, just trying to be of assistance!

1 user thanked author for this post.

OscarCP

A couple of performances that I have enjoyed:

Firstly, an outstanding perforamnce from 2011 of the BBC Symphony Orchestra performing Verdi’s Requiem:

https://www.youtube.com/watch?v=Hlo1I3rx6n4

If you listen to nothing else from it, listen to Dies Irae at 9:39. That’s enough to move anyone! The scale is overwhelming.

Secondly, more of a general recommendation, and that is any performance of Beethoven by Wilhelm Kempff. Here are movements 1 and 3 (sorry for leaving you out movement 2!) of his Moonlight Sonata, as that is something that everyone has heard and will be able to compare:

https://www.youtube.com/watch?v=O6txOvK-mAk

https://www.youtube.com/watch?v=oqSulR9Fymg

Aren’t they just the most superb performances of these pieces? So perfect. He recorded Beethoven’s complete sonatas, which can be purchased, if you are interested. I own the CD and can recommend.

2 users thanked author for this post.

OscarCP, GarthP