Search results

  1. K

    Closing image viewing software

    Here's how I terminate a process Sub TerminateProcessByName(procName As String) Dim objWMIService As Object Dim colProcessList As Object Dim objProcess As Object Set objWMIService = GetObject("winmgmts:\\.\root\cimv2") Set colProcessList = objWMIService.ExecQuery("SELECT...
  2. K

    Closing image viewing software

    Since we use it for CAD files, we hadn't any problem so far. But in some cases as you explain, it may cause problems. How about This method : Read the list of running processes Open your file Find the new process and keep it in a public variable or a tempvar Terminate the process when necessary...
  3. K

    Closing image viewing software

    We have diferent viewers for 3D cad drawings installed on different machines, based on the licence of application. This is how we close the viewers. Find the name of default program associated application to the extension, in registry close the application. This finds the default application...
  4. K

    Active / Trash - Whose responsibility is it?

    I may be wrong, but somehow I feel my reply offended you and you took my response as something that I didn't mean it to be. You ended your post with "Your thoughts?", and I explained (or tried to explain) how we do it and why it's different with your method. I already have explained all your...
  5. K

    Active / Trash - Whose responsibility is it?

    The following gave me the idea. Still my other points are valid.
  6. K

    Active / Trash - Whose responsibility is it?

    In our case : Any thing that is not active, is trash. So why you need 2 where 1 can do the same. We have 1 long text field (why), an integer field (who), a datetime field (when) for deleted records. Supervisors don't want to see the deleted records all over the place. Every search form has an...
  7. K

    How to Simplify MS Access Form Searches Using Class Modules and Collections to Pair Text Boxes and Option Groups for Efficient SQL Query Generation

    Can you or @MarkK share a simple file (or a link to the thread) to show how you did it? I normally use a property in my forms instead of a collection. Thanks.
  8. K

    Solved Login to Microsoft account

    If I understand you correctly, we have those tenant accounts. Each one of us has a OurName@ourOrgnizationName.onmicrosoft.com account. We use these accounts when we use Microsoft products and apps (at work), and can not use them for private cases. The mail addresses I was talking about (and was...
  9. K

    Solved Login to Microsoft account

    OK. The problem was solved. I reset my password. During the process I received a message that I have to add my phone number. I added my phone number and reset the password. Now the account behaves normally. Either I had to add a phone number or something was wrong with my password. (not secure...
  10. K

    Solved Login to Microsoft account

    I understand the account is set up for me. I don't understand how Microsoft checks for anything within policies setup for my mail address. Our organization buys a domain : OurCompanyName.co.jp In control panel of the domain, IT creates a mail address for each employee and give us those...
  11. K

    Solved Login to Microsoft account

    Our organization has given me a mail address to be used by me. I don't understand how the policies of login to my private account on Microsoft can be set by our organization domain admin. But to be sure, I'll talk to the admin tomorrow morning as soon as I'm back to office. Thanks again.
  12. K

    Solved Login to Microsoft account

    Something that may help you to help me. All my accounts are ***@outlook.com or ****@msn.com or ****@hotmail.com the only account with problem is ****@ourOrganizationDomain.co.jp
  13. K

    Solved Login to Microsoft account

    If by MFA you mean Two-step verification, yes, it's set to off. Thanks.
  14. K

    Solved Login to Microsoft account

    I have several Microsoft account. Login to Microsoft.com is as it should be. I type my username, and click Next. In next screen, I type my password and I'm logged in. Only one account behaves differently. I type my username and click next. Instead of been asked for my password, I receive a...
  15. K

    Absolute Zero

    Many people still believe that AI won't last long without humans. Because everything they know, has come from our knowledge. They simply can't see the difference between an AI and a search engine. As I have said it before, just wait for a few years and you'll see how AI changes everything.
  16. K

    Absolute Zero

    Researchers from Tsinghua University and BIGAl have developed Absolute Zero, a groundbreaking self-learning Al that requires no human data. Instead, it creates its own tasks, solves them using diverse reasoning strategies, and improves through self-play-essentially teaching itself from the...
  17. K

    Solved Using dynamic sql instead of saved query in Insert Into queries...

    This fails because of the lack of alias. That was why I couldn't make it work from start. Createsql returns a select string, but Access seems to get confused if it has no name (alias)
  18. K

    The end is nigh !

    Doc, do you know my daily prayers? I pray to die before 75. I really hate to live long enough to cause trouble for my kids or my wife. I've had a good life, and prefer it to be ended while I understand and recognize how good it was, rather than becoming a mountain of flesh sitting in front of TV...
  19. K

    Solved Using dynamic sql instead of saved query in Insert Into queries...

    Oh and I forgot to say: Insert query shows the same error if the select section is ended with ; So no semi colon for the select sql and alias it. That took me more than half a day to understand.
  20. K

    Solved Using dynamic sql instead of saved query in Insert Into queries...

    OK. I found the problem. I have to alias the select query. So my vba should be : sql = "INSERT INTO tblPKs (PK, UserFK, frm) " & vbCrLf sql = sql & "SELECT InquiryPK, 1, '" & frm & "' " & vbCrLf sql = sql & "FROM (" & CreatSql & ") AS [tempQuery]" & vbCrLf sql = sql & "WHERE " & Filtr...
Back
Top Bottom