Recent content by KitaYama

I'll be waiting how your next version will be. I wonder if I can use that, because we don't have "county" here. Our structure is Country->Prefecture (State)->City.

But those duplicate city names are in different region (States). I can not find a state that has two cities with the same name. I'm not American, and I'm not sure if my assumption is correct, But it's what chatgpt is telling me In the United States, you generally cannot have two incorporated...

If there's no duplicate city names in a region(State), your current file works perfectly. If there are two cities with the same name in a region (State) in the same country, which I think is impossible, your solution in that file will fail.

I liked how @Ken Sheridan managed contacts location in this post. He has Countries, Regions and Cities tables, all one to many relationship, and then saves only CityID for the contact. It covers up all possible duplicates. In Contacts form, CityID combo is linked to the underlying table, and...

You forgot about those who didn’t step in from the start, because they could already see how the OP’s thread would turn out.

My bad. I had forgotten that you prefer replies to be limited to exactly what you ask, rather than suggesting a better method, even if the root of the problem is that your approach itself may not be the best database practice.

Why do you need to move them to another database? Data doesn't take too much space on disk. You can set a default value for date in your search form, so when users search for something, it shows the data from 2025 and later as default. One bonus is that if for some rare reasons they need to...

Are you sure about that? :D That's absolutely correct. I tried learning French at one point. When I was reading a poem in class, the teacher stopped me and said, “You sound like a Nigerian who just moved to Paris.” That was enough for me to realize my pronunciation probably wasn’t going to...

My sincere condolences to his family and loved ones. He was a valued member, and his knowledge and willingness to help others will be greatly missed.

I even have problems with my own native language, so learning Spanish is beyond me. Compared to other languages, English is simpler, which is why I started learning it. I really admire those who can speak Spanish, French, or German.

I have a background in PHP web programming and used high-end editors like Zend Studio with many built-in features. When I first started using Excel VBA and later Access VBA, the lack of those features was a real pain. A friend suggested trying different utilities to see if any of them could...

According to AI: English ⇒ Spanish Notion ⇒ Idea Station ⇒ Puesto (in some contexts like military post) Motion ⇒ Propuesta (When used in parliamentary context) Motion ⇒ Movimiento (Physical movement) Question ⇒ Pregunta Suggestion ⇒ Sugerencia Caution ⇒ Cuidado (in some rare usage : precaución )...

Yes. Many of them are used for the ribbon, several for customized TaskDialogs, some for vertically aligning text in report textboxes, and others for various purposes. A small portion of them were also taken from your site (dimming the screen, centering forms, etc.). In the end, I followed the...

@xavier.batlle @sonic8 @isladogs Before following the given advice and keep the things as they are, I just want to be sure you have the correct information. I gave a count and it hit to 285 API declarations (After deleteing #Else sections) and nobody knows how many of them are duplicates. Do...

How about if after moving them, I use AMZ to reorder the whole module alphabetically? In this case I can see different instances of the same API on top of each other and compare them to see if the parameters are the same or not.