Search results

That won't work. In VBA, Enum members must be numeric constants because they are compiled as Long integers. NewLine = vbNewLine will throw an error. It can be NewLine = 10 ' Line Feed (LF) OR NewLine = 13 'Carriage Return (CR) But I'm not sure if that works. Because I always use vbCrLF.

When a PhD chemist talks, I switch to listening mode and pretend I understand.🫢 I’ll be sitting quietly upgrading my ignorance.

I’m at work and wasn’t able to read the full article. I’ll read it later. I simply scrolled through it. I’m sure they had strong reasons for their decision. China is now facing a lot of criticism from environmental organizations. They believe the heat generated by the data centers is a disaster...

Hadn't heard of it. thanks

It's several months old, but for those who have not yet heard of it : https://www.sify.com/data-centers/china-launches-worlds-first-ai-powered-underwater-data-centre/ https://www.scientificamerican.com/article/china-powers-ai-boom-with-undersea-data-centers/ After this move, US is planning...

I'm sorry. I don't know why I used "Decrease". It's "Increase". It takes a whole life till I learn English. Edited my post. Apologies.

I think one of my difficulties with English is forgetting how different our language is from yours. The way we communicate differs greatly from how native English speakers express themselves. In our language, we often omit large parts of a sentence because the structure makes the meaning clear...

I meant third party antivirus. I think it was obvious.

Not arguing, but you didn't get the point. I didn't say write your own antivirus.I also didn't mean you be your own plumber. I said when you have a plumber at home, why calling someone else. Windows come with Windows Defender. I asked why using a third party app. My question was why turning off...

I never take any comment as a personal attack, specially from you. I asked a question, and you simply described your side of story. That's all. And thanks for the detailed reply.

Would you please explain how following a link in a mail, ends up to a software being installed? Didn't you select/click anything to download and install? Thanks And happy new year. I also don't understand why people still use third-party antivirus software, especially those who have good...

Why not : If DCount ("*" , "tblPipeLineInput" , "StationID = " & txtStationID) = 0 then MsgBox "Record not found." End if You don't even need the ELSE section. Because you do nothing there.

You may know it, but if you don't : If you use ChatGPT, you can create custom versions of ChatGPT that combine instructions, extra knowledge, and any combination of skills in a specific purpose. Each of them are called GPT and each GPT is a specialized ChatGPT made for a specific course...

Million thanks for all your efforts. I'm at home and don't have Access here. I'll check it on Monday. I really appreciate your assist.

It seems your situation is very different from ours. Here, there is a lot of effort to reduce car accidents. For example, people who have a gold driver’s license (5 years with no accidents) pay less for var insurance, less for fuel (per liter) or oil, pay lower taxes when renewing their driver’s...

I really appreciate this test. Since the table will grow soon, I think I will go with #2 sql. Million thanks for your time and help, and sorry for the confusion I caused.

It's fine. But the question is how much it effects on the payment. As I explained above, here, a full Non-Fleet Grade (20 years without accident) has a %60 discount. And it's huge. %10 for gold license. 5% for 35+ age and so on. I think you may want to check how your 40 years no accident effects...

You may have missed my edited reply. @CJ_London found the problem and I corrected #1. Access makes it hard to share databases when different locals are set in control panel, or when a database is written in an Asian language. I have had this problem frequently when others can not open my...

Maybe because of 28 years no ticket, no accident. Here, it's the main effect on insurance payments.

Good catch. Thanks. Yes, you are correct. The date I showed in #1 for 10 was wrong. I corrected it. I wasn't able to paste the table. It kept giving me ooops error and asked me to reduce my post to less than 10,000 characters. That was why I had to insert a table, and copy paste each field for...