Recent content by Grumm

SpaceX should just build a spaceport and start launching starships from there. Using the falcons to send materials and resources in orbit. No need to get them back to Earth...

You can add a filter on the selection (you need to select the entire range you want) Then filter out the empty lines, Now you can copy paste the visible lines into a new sheet.

Not sure how serious this question is based on the other 3 questions. But in any case, first of all, HTML isn't a programming language. HTML is just a markup language (like Scribe, XML) For projects, well you can create website with it.

Usually, you can put the family name in it. But make sure you have a system to handle edge cases. For example, I have 2 names and at one point, they added me twice in class...

That makes more sense. What about a 'Family' table ? with ID and Name Like Student as a field 'FamilyID' Should normalize your table even more I think.

I wouldn't store all the 1---1 ones. You cannot be a sibling of yourself. Should look more like this : 1........... 2 2............1 3.............4 3.............5 4.............3 4.............5 5.............3 5.............4 that way, you know for each student who the siblings are. select...

My bad. That was what I mean by 'where you are born'. If you where born in some indian family, or somewhere in japan, your choices will be different. And maybe it is bad to lead to stereotyping, but that is the unlucky outcome. Belgium is also stereotyped as 'beer drinking people' and yes, most...

That is imo not really true. Yes, there are a lot of variations, but they are still based on where you are born. Our brain is like machine learning. Any input at early stages can have a great impact later. If you tell a baby from the moment that it is born that red is called 'green', the baby...

That is because it is in VBA. VBA is (as far as I know) same functions for all. OP was using the format expression in the designer mode. (This is the same as Excel: you need to use language specific functions in cells. But not in VBA)

I would just check the microsoft support : https://support.microsoft.com/nl-nl/office/een-datum-en-tijdveld-opmaken-47fbbdc1-52fa-416a-b8d5-ba24d881b698 Looks like Dutch uses the English letters. (but again, it looks like nobody knows what is correct : u of hh Geeft het uur weer met één of...

Isn't that how a democracy works ? You vote until only 2 evil choices are left then, all the people can do (not because that is what the people want but just doesn't have the choice anymore) is to pick the one that is less evil. Well in France you have like the first voting round and after that...

As far as I created VBA in access on a dutch version of Office, it doesn't matter. SELECT DateofSale, Year([DateofSale]) AS Expr1 FROM ProductSales; This select will be the same. But it looks like even Microsoft doesn't really know what to use in the format function ...

I think you missed the point. What I wanted to tell is to give people the benefit of the doubt before actually warning and giving advice. It is possible that @ColinEssex didn't know the true facts or whatever. And you can explain why or what. 'Be careful what you post on a public forum.' So...

I disagree here. Why should someone be careful to post something on a forum ? We all can be wrong at one point or even not know everything like it is in reality. But that is why on a forum, you can explain your own point of view on stuff. And yes, we do have to rely on papers or articles...

Long time I used Access, but since you are doing a sum, why isn't there a group by in the query ? You either put only the 'sum' in the select, or use a group by. (I think)