Search results

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)

The function is also public so, good question. It can be useful when using private functions. https://docs.microsoft.com/en-us/office/vba/access/concepts/error-codes/program-with-class-modules Other than that, to show some 'best practices' in a demo project ?

I don't think in VBA this is an issue. As shown in the picture, ErrorHandling is a class and the Public eh As New ErrorHandling will always run. Even if that line failed, it is save to say that you cannot open the file. If for some odd reason, the instance got destroyed, it is still not really...

And this is a good example on why it is important to normalize a database. You could have avoided the union if you added a table for all the employees, a table for the companies, a table for the vacations and a table for the FinalExits. All linked with ID's and you can select any employee with...

Agree with this, but why in any professional code, you would want to do that ? Why is a location depending of the velocity ? (I know it is an example) If you have have different expressions to check, split them and make them easier to read. That is my opinion of course ;)

What you describe about USA an "states' rights" is kind of similar here in the EU. The EU make some rules about stuff, all countries need to follow that rule. But each country can have their own rules too about other stuff. So in Belgium, you can drive max 120 km/h on the freeway. In France, the...

Hehe, don't worry. I always keep an open mind about other cultures and countries. Even Virginia looks nice to visit :p Always fascinating to meet new people.