Search results

  1. J

    Solved Checking network connection in split database setup

    Good Day To All, Below is a copy of a Sub to check whether connected or not to the network. This is ok, only I need to hide the command window during execution or to work in the background only. Private Sub btnEXIT_Click() Dim stdOut, objScriptExec, strPingResults Set objShell =...
  2. J

    Chicken and Egg situation, which comes first?

    Hello Gurus, Please enlighten me on the query to handle: 1st week Field A = Field A + Field B 2nd week Field A = Field A + Field B and so on... I have an error message of "Circular Reference caused by alias" upon running the query. Please help with the right formula and syntax. Thanks in...
  3. J

    Shutdown PC through Access button

    Hi Guys, I'm setting up a dedicated PC to do Access only from powerup to shutdown. To be exact, when I press the power button of my PC it will boot and start Access and when done, press exit button on Access and it will close Access and shut down the PC. The end-user will not see any Win...
  4. J

    do not count duplicates fields in report

    Hello I need to count as one only any Duplicates fields in my report. I managed to do it in Job No row using the below procedure but fail in both received and completed date. "To count the number of distinct instances of a Job No in the period covered by the report include a hidden text box...
  5. J

    New Here

    Hi All, I'm working in Qatar for 17 years now as an Electronics Engineer. I came across this site while searching for answers to my ACCESS project and found all of them very helpful and solved my headache. I'm only newbies in this field. Cheers to all of you guys. Joey
Top Bottom