Comments by Maciej Los

Maciej Los 5 days ago View

Don't understand what the problem is...
Why do you want to control VB.Net application from VBA? You can use interface(s)...
Can you be more specific and describe your problem in details?

Maciej Los 14-Apr-24 6:42am View

Are you using EntityFramework?

Maciej Los 10-Apr-24 16:29pm View

5ed!

Maciej Los 10-Apr-24 16:28pm View

5ed!

Maciej Los 9-Apr-24 11:41am View

+5!

Maciej Los 9-Apr-24 11:11am View

Do you think we can read a crystal ball?

Maciej Los 8-Apr-24 16:24pm View

5ed!

Maciej Los 8-Apr-24 15:59pm View

+5!

Maciej Los 3-Apr-24 13:53pm View

In case you'll get stuck, let me know.

Maciej Los 3-Apr-24 13:50pm View

You changed sample data. I'd suggest to use Replace function. Change my code to your needs :)

Maciej Los 3-Apr-24 13:47pm View

Thank you, Bruno :)

Maciej Los 2-Apr-24 16:43pm View

You're right, Bruno :)

Maciej Los 27-Mar-24 3:05am View

You should say "THANKS" to Pete, because His answer was very helpful in resolving your issue.
I'd suggest to remove your answer as it is a duplicate of Pete's solution.

Maciej Los 27-Mar-24 3:03am View

5ed!

Maciej Los 25-Mar-24 13:26pm View

5ed!

Maciej Los 17-Mar-24 16:18pm View

5ed!

Maciej Los 17-Mar-24 13:01pm View

Thank you, Bruno :)

Maciej Los 17-Mar-24 6:05am View

:)

Maciej Los 17-Mar-24 6:04am View

You're very welcome.

Maciej Los 16-Mar-24 16:02pm View

5ed!

Maciej Los 16-Mar-24 16:00pm View

5ed!

Maciej Los 14-Mar-24 15:44pm View

5ed!

Maciej Los 13-Mar-24 15:19pm View

5ed!

Maciej Los 13-Mar-24 14:16pm View

I love this part: "Having a dense/senior moment today...". I understand it as "pomroczność jasna" (in polish language). I doubt there's a direct translation (from polish to english), but i hope this will make you a day :)

Maciej Los 13-Mar-24 14:12pm View

5ed!

Maciej Los 13-Mar-24 5:35am View

5ed!

Maciej Los 12-Mar-24 16:56pm View

:thumbsup:

Maciej Los 11-Mar-24 14:58pm View

Exactly!

Maciej Los 29-Feb-24 15:41pm View

5ed!

Maciej Los 26-Feb-24 14:30pm View

5ed!

Maciej Los 26-Feb-24 13:52pm View

Identifiers for USB Devices - Windows drivers | Microsoft Learn[^]
Standard USB Identifiers - Windows drivers | Microsoft Learn[^]
Identifiers Generated by USBSTOR.SYS - Windows drivers | Microsoft Learn[^]
Identifiers Generated by USBPRINT.SYS - Windows drivers | Microsoft Learn[^]

Maciej Los 26-Feb-24 11:14am View

5ed!

Maciej Los 24-Feb-24 15:01pm View

Take a look here: https://forum.pdfsharp.net/viewtopic.php?f=2&t=2706&p=7782&hilit=header+height#p7782[^]
The trick is for header, but i think you can use the same with footer.

Maciej Los 22-Feb-24 13:01pm View

5ed!

Maciej Los 20-Feb-24 16:06pm View

5ed!

Maciej Los 20-Feb-24 16:03pm View

5ed!

Maciej Los 19-Feb-24 13:48pm View

It looks like you need to finish your job by deploying your extension: Install Extensions in SQL Server Management Studio (SSMS) - SQL Server Management Studio (SSMS) | Microsoft Learn[^]

Maciej Los 19-Feb-24 13:25pm View

Do you want to compare sheets cell by cell?

Maciej Los 19-Feb-24 13:14pm View

Define "duplicate records"...

Maciej Los 18-Feb-24 12:19pm View

5ed!

Maciej Los 14-Feb-24 15:41pm View

You're joking, right?
Check this link. At the end you'll find solution: save project, close solution and VS, reopen VS and solution.
I'd suggest to run VS with admin priviledges.

Maciej Los 13-Feb-24 16:33pm View

Take a look here: Developer Community[^]

Maciej Los 13-Feb-24 16:23pm View

5ed!

Maciej Los 7-Feb-24 16:41pm View

Do you mean something like this: regex101: build, test, and debug regex[^]?

Maciej Los 2-Feb-24 12:29pm View

5ed!

Maciej Los 2-Feb-24 12:28pm View

5ed!

Maciej Los 2-Feb-24 12:28pm View

5ed!

Maciej Los 2-Feb-24 12:21pm View

5ed!

Maciej Los 31-Jan-24 13:53pm View

Agree. And i believe that it could the path through torment for person who never worked with AI.

Maciej Los 31-Jan-24 13:48pm View

5ed!

Maciej Los 31-Jan-24 13:48pm View

5ed!

Maciej Los 22-Jan-24 11:41am View

5ed!

Maciej Los 22-Jan-24 11:20am View

What is rd?

Maciej Los 22-Jan-24 11:15am View

Is this an answer?

Maciej Los 18-Jan-24 15:03pm View

5ed!

Maciej Los 16-Jan-24 17:11pm View

This is not an answer. Please, delete it to avoid down-voting.

Maciej Los 16-Jan-24 15:33pm View

I voted for that answer: 5 stars (see right-top corner).

Maciej Los 16-Jan-24 15:04pm View

5ed!

Maciej Los 15-Jan-24 14:58pm View

This is not an answer. Please, delete it or provide proper solution.

Maciej Los 9-Jan-24 9:31am View

5ed!

Maciej Los 9-Jan-24 9:31am View

5ed!

Maciej Los 9-Jan-24 9:30am View

Bruno, all the best to you too.

Maciej Los 8-Jan-24 15:07pm View

My virtual 5!

Maciej Los 7-Jan-24 16:48pm View

What is the definition of those classes?

Maciej Los 7-Jan-24 12:53pm View

Happy New Year, Richard :)

Maciej Los 7-Jan-24 12:10pm View

Do not repost!
Getting Google map location points and distance from webview2 control in VB.NET[^]

Maciej Los 7-Jan-24 12:08pm View

5ed!

Maciej Los 7-Jan-24 3:02am View

5ed!

Maciej Los 7-Jan-24 1:58am View

This is not an answer. Please, delete it and use "Have a question or comment" under the solution posted by other user.
Yes, this means it's not necessary to create linked tables. You can use queries in code behind.

Maciej Los 6-Jan-24 3:30am View

5ed!

Maciej Los 6-Jan-24 3:14am View

5ed!

Maciej Los 6-Jan-24 3:14am View

5ed!

Maciej Los 3-Jan-24 13:47pm View

Then... 5ed!

Maciej Los 3-Jan-24 13:47pm View

OK.

Maciej Los 30-Dec-23 13:22pm View

5ed!

Maciej Los 30-Dec-23 12:28pm View

Do not repost!
Creating an exe with VS 2022...[^]

Maciej Los 30-Dec-23 12:03pm View

Can a question be an answer?

Maciej Los 21-Dec-23 16:00pm View

"does not work" is not very descriptive...

Maciej Los 12-Dec-23 16:55pm View

If the installer have to use default OS language, use

[Setup]
LanguageDetectionMethod=uilanguage

See:
Inno Setup Help[^]

Maciej Los 12-Dec-23 16:29pm View

5ed!
I'd change only one part: instead of CType(), i'd use DirectCast(). Why? Check out this: DirectCast Operator - Visual Basic | Microsoft Learn[^]

Maciej Los 12-Dec-23 16:29pm View

5ed!

Maciej Los 12-Dec-23 16:26pm View

5ed!

Maciej Los 12-Dec-23 16:23pm View

5ed!

Maciej Los 12-Dec-23 13:39pm View

Good to know :)

Maciej Los 11-Dec-23 16:50pm View

Thank you, Andre.

Maciej Los 11-Dec-23 16:50pm View

Thank you, Andre.

Maciej Los 8-Dec-23 7:43am View

If you want to make your application universal, you have to store date and time in UTC.

I'd suggest to read this: Dates, times, and time zones - .NET | Microsoft Learn[^]

Maciej Los 8-Dec-23 7:20am View

What part of your code doesn't work? What's error message? Which line?

Maciej Los 8-Dec-23 7:09am View

5ed!

Maciej Los 8-Dec-23 7:08am View

5ed!

Maciej Los 8-Dec-23 6:57am View

Sorry, we have no access to your system and we don't see your screen. How do we know what did you change in your project that affects an issue like this?

Maciej Los 8-Dec-23 5:32am View

5ed!

Maciej Los 8-Dec-23 5:13am View

5ed!

Maciej Los 8-Dec-23 3:03am View

Thank you, Andre :)

Maciej Los 8-Dec-23 2:54am View

You're very welcome and thank you.

Maciej Los 7-Dec-23 4:16am View

You're very welcome. :)

Maciej Los 7-Dec-23 2:18am View

I'd suggest to use EPPlus NuGet package. It's very fast and light version of OpenXML/Excel.

Maciej Los 6-Dec-23 7:36am View

5ed!

Maciej Los 6-Dec-23 7:28am View

I've seen this question yet: How to read access 2007 database in Python[^]. And you answered it. So... Please, report this question as a repost (use red flag under the question). This is one of the rules on CP. :)

Maciej Los 6-Dec-23 7:24am View

You already have asked this question: How to read access 2007 database in Python[^]
Please, do not repost!!!

Maciej Los 6-Dec-23 7:05am View

Short and to the point!

Maciej Los 6-Dec-23 7:02am View

5ed!

Maciej Los 6-Dec-23 2:55am View

You forgot to mention what's wrong with your code...

Maciej Los 6-Dec-23 2:53am View

You're welcome. :)

Maciej Los 6-Dec-23 2:51am View

Thank you, Andre :)

Maciej Los 5-Dec-23 11:10am View

:thumbsup:

Maciej Los 5-Dec-23 9:51am View

Show us what you have tried...

Maciej Los 5-Dec-23 3:53am View

5ed!

Maciej Los 5-Dec-23 2:39am View

:) I'm not Chris. My name is Maciej. And i only wanted to tell you why your answer has been downvoted. A "final solution" is exactly as yours, but it follows from Chris's answer.

Maciej Los 4-Dec-23 3:07am View

I gues, you're right. :)

Maciej Los 3-Dec-23 11:44am View

Publishing other people's posts as your own is not welcome. That's the reason your "answer" has been downvoted.

Maciej Los 1-Dec-23 18:07pm View

Do i said that C# and interop do not have their place? No.

Maciej Los 1-Dec-23 17:46pm View

5ed!

Maciej Los 1-Dec-23 17:46pm View

5ed!

Maciej Los 1-Dec-23 15:33pm View

Do you want to get Active Directory users? If so, then take a look here: Get List of Active Directory Users in C#[^] and here: Getting Users From Active Directory[^]

Note: you have to be sure that users are registered on Windows Server.

[Polish]:
Czy chcesz pobrać konta użytkowników ActiveDirectory?

Maciej Los 1-Dec-23 14:54pm View

I have seen what have you done. As i mentioned, the way to write proper sql statement depends on Oracle database. I'm not able to help you, because i have no access to Oracle database.

Maciej Los 1-Dec-23 14:54pm View

[posted by mistake]

Maciej Los 30-Nov-23 15:57pm View

5ed!

Maciej Los 30-Nov-23 15:51pm View

What's your issue? What's wrong with your code?

Maciej Los 30-Nov-23 15:49pm View

I mean, you have to carefully read related article.

Maciej Los 29-Nov-23 6:09am View

5ed!

Maciej Los 29-Nov-23 5:59am View

Thank you, Cris for this tip.

Maciej Los 29-Nov-23 5:57am View

You're very welcome.

Maciej Los 27-Nov-23 16:57pm View

Another solution is to create "windows template" and then to inherit from it. :)

BTW: you missed "class" word in "public static FormHelper" statement.

Maciej Los 27-Nov-23 11:58am View

Are you sure? I have tested above code. Works perfect.

Maciej Los 27-Nov-23 11:01am View

5ed!

Maciej Los 26-Nov-23 10:38am View

5ed!

Maciej Los 22-Nov-23 15:36pm View

Good point. Thank you, Richard.

Maciej Los 21-Nov-23 15:50pm View

Thank you, Carlo.

Maciej Los 20-Nov-23 13:05pm View

5ed!

Maciej Los 20-Nov-23 12:59pm View

Thank you, Andre. :)

Maciej Los 20-Nov-23 12:43pm View

Please, do not repost!
Change page orientations[^]

Maciej Los 20-Nov-23 12:32pm View

5ed!

Maciej Los 20-Nov-23 12:29pm View

5ed!

Maciej Los 18-Nov-23 13:36pm View

Check out updated solution.

Maciej Los 17-Nov-23 13:52pm View

5ed!

Maciej Los 17-Nov-23 9:45am View

5ed!

Maciej Los 16-Nov-23 15:38pm View

5ed!

Maciej Los 16-Nov-23 14:15pm View

5ed!

Maciej Los 16-Nov-23 10:13am View

5ed!

Maciej Los 15-Nov-23 15:52pm View

Yes, see updated answer.
[EDIT]
Have you tried my code to convert seconds into time?

Maciej Los 15-Nov-23 12:32pm View

+5!

Maciej Los 14-Nov-23 16:52pm View

Please, improve your question. Instead of two columns of code, use single column. BTW: can you provide complete code?

Maciej Los 14-Nov-23 15:58pm View

5ed!

Maciej Los 14-Nov-23 15:57pm View

Seems that no one can understand what you want to achieve... Please, describe your issue in native language, then use google translator. After that, use "Improve question" and paste that translation.

Maciej Los 13-Nov-23 13:50pm View

Thank you, Richard.

Maciej Los 10-Nov-23 17:50pm View

Is this WindowsForms application or ASP.NET? Click method seems to refer to WinForm, but the content of method is using Redirect method, which is not related to WinForms.

Maciej Los 10-Nov-23 17:19pm View

5ed!

Maciej Los 10-Nov-23 9:10am View

5ed!

Maciej Los 10-Nov-23 2:13am View

:) Thank you :)

Maciej Los 8-Nov-23 8:44am View

5ed!

Maciej Los 8-Nov-23 8:00am View

5ed!

Maciej Los 8-Nov-23 4:20am View

Why to post an answer to already answered question, especially when OP was askking this question over 11 years ago!

Maciej Los 8-Nov-23 3:46am View

5ed!

Maciej Los 8-Nov-23 2:48am View

Sorry, but i don't understand you...
If you want to keep original TransDataId, then change your SourceData table to be able save original data and increase internal Id (not TransDatId!).
[BTW]
Schema of tables would be helpful.

Maciej Los 8-Nov-23 2:44am View

What have you tried till now?

Seems, you have to create an instance of BankAccount class...

Maciej Los 8-Nov-23 2:35am View

No. Sorry, but you're wrong.
The intructions inside a loop do all the same. They insert a cell in active cell and move the rest of cells to the right direction.
In VBA function have to be a function if this function have to return some value(s). If a piece of code have to be executed without returning a value, then it should be a procedure (in VBA is called/named "sub").

Maciej Los 6-Nov-23 17:31pm View

You're very welcome :)

Maciej Los 6-Nov-23 13:30pm View

Sorry, i don't understand you...
What i'm trying to tell you, is:

Form_Settings fs = new Form_Settings();
fs.ComboBox_Language.SelectedItem = Properties....

Maciej Los 6-Nov-23 13:13pm View

5ed!

Maciej Los 6-Nov-23 13:11pm View

It seems you're trying to set the properties to object whose instance does not exist (Form_Settings).

Maciej Los 6-Nov-23 13:10pm View

Deleted

[posted by mistake]

Maciej Los 6-Nov-23 10:25am View

The question is not "why they cannot find their way" by "why they don't try to find it".

Maciej Los 5-Nov-23 17:08pm View

I'd suggest to read this: Python Programming on Win32: Appendix D - Threads[^]
This could be helpful too: https://stackoverflow.com/questions/26764978/using-win32com-with-multithreading[^]

Maciej Los 5-Nov-23 13:23pm View

5ed!

Maciej Los 5-Nov-23 13:21pm View

5ed!

Maciej Los 4-Nov-23 14:40pm View

Why? This functionality seems to be unfriendly to the UI.

Maciej Los 4-Nov-23 14:02pm View

Please, post it as an answer.

Maciej Los 4-Nov-23 13:56pm View

5ed!

Maciej Los 4-Nov-23 13:29pm View

5ed!

Maciej Los 2-Nov-23 11:40am View

5ed!

Maciej Los 28-Oct-23 13:15pm View

5ed!

Maciej Los 28-Oct-23 12:25pm View

5ed!

Maciej Los 27-Oct-23 11:32am View

5ed!

Maciej Los 27-Oct-23 11:28am View

5ed!

Maciej Los 27-Oct-23 11:25am View

5ed!

Maciej Los 1-Oct-23 8:10am View

5ed!

Maciej Los 11-Sep-23 15:23pm View

5ed!

Maciej Los 7-Sep-23 14:36pm View

5ed!

Maciej Los 23-Aug-23 14:00pm View

5ed!

Maciej Los 21-Aug-23 14:12pm View

5ed!

Maciej Los 21-Aug-23 14:12pm View

Thanks.

Maciej Los 21-Aug-23 14:02pm View

I'd suggest to post that question on CP Bugs and Suggestions[^]

Maciej Los 2-Aug-23 17:24pm View

This portion of data is too small to provide an algorithm. I'd suggest to divide the value of column C by 1. rank (column B).
Result:

Value  Rank (Col D)
1.18   3
1.70   2
1.17   4
5.90   1

Is that what you want?

Maciej Los 2-Aug-23 15:17pm View

I haven't teested it on Oracle database...
As you can see, there's a Match#1 and Group#1. Group#1 is what you're looking for.

Maciej Los 1-Aug-23 13:31pm View

5ed!

Maciej Los 1-Aug-23 12:18pm View

And what is the logic behind it?

Maciej Los 27-Jul-23 16:05pm View

Follow this link: SQL Server 2022 | db<>fiddle[^]

Maciej Los 26-Jul-23 13:34pm View

5ed!

Maciej Los 22-Jul-23 16:27pm View

I was a bit busy...

Maciej Los 21-Jul-23 15:17pm View

Sample ML data would be helpfull.
BTW: I'd suggest to read this: A Complete Sample of Custom Class Collection Serialization and Deserialization[^]

Maciej Los 21-Jul-23 14:41pm View

5ed!

Maciej Los 12-Jun-23 12:34pm View

Does it helps: Marshalling Classes, Structures, and Unions - .NET Framework | Microsoft Learn[^]

Maciej Los 31-May-23 12:42pm View

Does the error occur while adding a picture from local drive?

Maciej Los 31-May-23 12:38pm View

5ed!

Maciej Los 8-May-23 15:42pm View

Can you share sample data and expected output?

Maciej Los 5-May-23 15:00pm View

So, it's working as expected :)
Sorry, Bruno, for the late reply. I'm a bit busy.

Maciej Los 2-May-23 15:26pm View

Try it :)

Maciej Los 20-Apr-23 12:43pm View

Agree. My answers to the questions depend on content of the question. Some people need to get an incomplete example, then they are able to finish their job, but the other need to have a complete solution.

Maciej Los 19-Apr-23 10:55am View

5ed!

Comments by Maciej Los (Top 200 by date)