Recent content by Moosak

  1. Moosak

    How do you distribute the updates?

    I used the Same mechanism that you are using. But I make this simple form in the FE to take the new updated FE to the server so the old FE always check if there is a new update at the startup. This way required just few clicks from the application manager to setup the new updates. 1. Click...
  2. Moosak

    Solved syntax error in DLookup

    I can see that the tool is not giving the user Every thing in the Final shape but It did most the job for him, Also it give him a chance to modify the given result as he wish. Okay I will make some little modification to the tool to give the user the choice of adding the parentheses where ever...
  3. Moosak

    Solved syntax error in DLookup

    The tool also allows the user to modify the syntax and test it, through direct modification in the yellow box. Try it yourself. :)
  4. Moosak

    Solved syntax error in DLookup

    Examples : Cr = Criteria Cr1 Cr2 Cr3 Cr4 ( Cr1 or Cr2 ) and Cr3 and Cr4 Cr1 and ( Cr2 or Cr3 ) and Cr4 Cr1 and Cr2 and ( Cr3 or Cr4 ) ( Cr1 or Cr2 or Cr3 ) and Cr4 ( Cr1 or Cr2 or Cr3 or Cr4 ) ( Cr1 or Cr2 )...
  5. Moosak

    Solved syntax error in DLookup

    I told the code to put parentheses around the two criterias if it is ("or") between them, and if there are three or four criterias and ("or") between them, it puts the parentheses in front of the first criteria and at the end of the last criteria. Is that correct ?
  6. Moosak

    Solved syntax error in DLookup

    I solve the matter of the parentheses 🙂 Now you can try using the tool
  7. Moosak

    Solved syntax error in DLookup

    Thank you for alerting me to this point, I will try to fix it. Can you give me the appropriate method when the two conditions ("and" / "or" ) combined
  8. Moosak

    Solved syntax error in DLookup

    Actually I haven't examen that but most the time it works fine with me. If I face any such case I will fix the tool then. :) Try the tool and feedback me please. Also I don't know if your example is explaining in real the expressions syntax.
  9. Moosak

    Solved syntax error in DLookup

    Using My magical tool (Smart Domain Functions Builder V1.0) : :) DLookUp("[Unit]","[Article]","[Article number] ="& Article &" Or [EAN] ="& Standard &" ") The tool can be found here : Smart Domain Functions Builder V1.0 Here how I used it : more details in the above link ;)
  10. Moosak

    Rename label boxes

    Hi Gasman You pass the form name which contains the controls that you want to rename or change there captions. I meant by NewName the prefix that you want for the controls. They will be renamed some thing like this (If you pass "Cont" as NewName) : ( Cont01, Cont02, Cont03, Cont04, Cont05...
  11. Moosak

    Rename label boxes

    This is my code for this : Public Sub RenameFormControls(txtFormName As String, NewName As String) 'Designed By : Moosak Dim Frm As Form Dim Ctrl As Control Dim x As Integer Dim CtrlType As Variant DoCmd.OpenForm txtFormName, acDesign Set Frm = Forms(txtFormName) ' UnComment...
  12. Moosak

    Open .exe without Shell

    You can try this one also : Public Sub OpenPath(strPath As String) Shell "explorer.exe" & " " & strPath, vbNormalFocus End Sub and call it like this : OpenPath "H:\QA90PRO32\QA90PRO.exe"
  13. Moosak

    Open .exe without Shell

    Nothing will happen if the file is not exists. Check that first and make sure the path is written correctly.
  14. Moosak

    Open .exe without Shell

    You can write it this way also : Shell "explorer.exe" & " " &"c:\windows\notepad.exe" &, vbNormalFocus No popp ups.
  15. Moosak

    Open .exe without Shell

    Is there any worries from using APIs?
Top Bottom