Search results

  1. S

    Notify user after completion - FlashWindowEx

    So, for an ethical coder to publish anything, they must read every single line of code that was ever written by anyone before to make sure it is not similar to the code they are about to publish? I get the impression you didn't read what I wrote here in previous posts. :sneaky:
  2. S

    Notify user after completion - FlashWindowEx

    As written previously, it is irrelevant if someone has written the same code before. The questions of copyright is whether the code was written (mostly) from scratch and just by chance is similar to someone else's, or whether someone else's code was copied. - And yes, the fact of copying...
  3. S

    Notify user after completion - FlashWindowEx

    In principle my elaborations from the previous post also apply here. The question that must be answered for AI LLMs is whether they "learned" the information they ingested and now produce new original work with the AI being the creator, or whether they merely reproduce the work of others. This...
  4. S

    Notify user after completion - FlashWindowEx

    Disclaimer: I’m not a copyright lawyer. These explanations are not intended as legal counsel. For the readers who didn’t download my module, @arnelgp is referring to this copyright notice in my code: Anyone’s code using this Windows API will be based on Microsoft’s...
  5. S

    Solved Error when trying to speak.

    Is there a male voice installed on your system? [I just noticed your last update] Ok, apparently not. You could use this to check explicitly: Dim vox As Object ' SpeechLib.SpVoice Set vox = CreateObject("SAPI.SpVoice") Dim allVoices As Object Set allVoices = vox.GetVoices...
  6. S

    Notify user after completion - FlashWindowEx

    I missed that detail. So, uCount exactly determines the number of times the window flashes but is only a rough guide for the times the taskbar button flashes. Actually, while the duration of the flashing would matter, the count of the flashes is completely irrelevant to me.
  7. S

    Notify user after completion - FlashWindowEx

    Thank you, Colin! I see what you mean. The caption/title of the window flashes exactly the number of times of uCount but the Taskbar button continues to flash three more times after the window title stopped. This appears to be unrelated to the value of uCount, except for a value of 1 were the...
  8. S

    Notify user after completion - FlashWindowEx

    That's part faulty and part deprecated. - It should still work on 32bit though. The flaws are: The window handle (hWnd) must be a LongPtr Size of the struct must be determined by LenB. If you are curious about the reasons behind the above flaws, check out my text on How to convert Windows API...
  9. S

    Notify user after completion - FlashWindowEx

    I was curious and wrote a working implementation. It's tested on 32bit only but should be fully 64bit compatible. You can download the module here: https://codekabinett.com/download/modFlashWindowEx.zip
  10. S

    Notify user after completion - FlashWindowEx

    Post your non-working attempt. - After a quick look at the API documentation I'm fairly sure, it can be fixed quickly.
  11. S

    Solved IIF with many

    @murray83 , did you try the suggestions for rewriting the IIF statement by @Gasman and myself?
  12. S

    Solved Unicode compression when creating a table

    That is expected behavior. The CHAR data type is padded with spaces to its full length. You are probably looking for the VARCHAR data type.
  13. S

    Solved Price History

    Lovely choice of words. :-) I struggle to follow the course of this thread, so I've got no specific advice to solve the current problem. However, I made two videos on time dependent data with examples similar to your changing prices. My approaches are different than those discussed here, but...
  14. S

    Solved Unicode compression when creating a table

    Is "WITH COMP" a valid abbreviation of "WITH COMPRESSION"? - I don't think so. Application.CurrentProject is not of type Database! The type is also named CurrentProject. Dim prj as CurrentProject Set prj = Application.CurrentProject prj.Connection.Execute "CREATE ....
  15. S

    Solved IIF with many

    You can only link complete boolean expressions with OR: =IIf([Text298] Like '190003*' Or [Text298] Like '230131*' Or [Text298] Like '30413*',"Please tip as a loose load, slip sheet has invalid
  16. S

    @@identity

    Well, it should work if you use the same DB instance: MsgBox TheForm.Recordset.Parent.Openrecordset("SELECT @@identity").Fields(0).Value Correct, but using a Pass-Through-Query only makes sense if you insert the new record in the very same batch as otherwise you would not be in the same scope.
  17. S

    @@identity

    Another idiotic reply by "AI". If @@Identity returns a value for the current session how can this be affected by other users? - It can't! However, as others pointed out already, @@Identity returns the last generated identity value, which can be a different value than you expect if there are...
  18. S

    Sorting Numbers Correctly

    If none of the previous suggestions are applicable to your scenario, you could use the natural numerals sorting algorithm from the Windows API.
  19. S

    Prompt using a board of advisors

    Interesting that you perceived the advice of "Koch" and "Goldratt" as most beneficial, while you actually implemented the advice of "James Clear". :LOL: BTW: I highly recommend Atomic Habits.
  20. S

    How to stop my public IP Address from changing

    @The_Doc_Man, I did not intend to suggest using an IP address for identification/authentication of users is a good idea. Restricting access to a system on the internet by IP address has its merits. But only to exclude illegitimate requests by their origin (IP address) already, before your...
Back
Top Bottom