Recent content by joeyd11ph

S O L V E D !!! Thank You Very Much Minty and to all who shared their ideas. I did the right thing by consulting you guys..... More power to my ACCESS home.

Hi theDBguy, All I play with a timeout but no luck. My apology to all by not divulging all the steps I have taken. Have tried all the suggestions here before I post but all of them have pros and cons: 1. checking by file >>slow response (>1min) if FE PC is off already (maybe retrying...

Thanks moke123 for your reply, My setup is P2P only, no internet connection involved, i just want check LAN connection not internet connection.

Thanks a lot theDBguy...

Thanks for prompt reply, theDBguy, I forgot to mention that I tried that but the same always "Connection NOK".

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 =...

To All Gurus Finally, I found out that my test data is corrupted. Thanks to all, Cheers Joey

HI DBguy Yes me too cant access the forum yesterday. I still have the same problem. thanks joey

Thanks for cleaning up tip Doc, It will certainly make my code easy to follow and debug...

HI DBguy Take your time. Thank you very much for your kind prompt reply. Cheers Joey

Hi DBguy zip link below https://1drv.ms/u/s!Aik1iwXemtr6jyDyMHVJIxntWHXl?e=MleOQt thanks Joey

Hi DBguy here is the link https://1drv.ms/u/s!Aik1iwXemtr6jyXEtW3OpL21TFOT?e=vUuA1U thanks joey

hi BDguy I'm having error uploading both Zip and ACCDB file pls see attached screenshot Can I send the link in my Cloud? thanks joey

Hi DBguy attached is my DB password for Admin is QAF Tafteesh go to "REPORT" chooe "WEEKLY" Thanks and appreciate very much your kind help joey

Hi Isladogs and others pardon me for my slowness in dealing with SQL. Please I appreciate very much if anybody can translate the link given by Isladog http://allenbrowne.com/subquery-01.html#AnotherRecord (Get the value in another record) in Access query only. Thanks, much gurus... joey