Search results

  1. N

    In VBA Pairing Hostname & Port

    I will try it , I hope this will help but I'm almost there, because I'm able to ping the gadget from a remote work station , for curiosity does 192.168.1.5 represent the Hostname ????????? 8888 represent destination gadget port ??????
  2. N

    In VBA Pairing Hostname & Port

    there is a Serial port code here maybe it will help you with your quest: Ok this is the current one I'm using and works very well after some adjustments with the cutting & buffer adjustment it is all nice but the serial port cannot be shared by multiple users unless one buys a port redirector...
  3. N

    In VBA Pairing Hostname & Port

    are you using the code from msAccess? does the other computer has msAccess? No the other computer is a serial gadget not a computer
  4. N

    In VBA Pairing Hostname & Port

    Dear all; See if you can guide here (1) My understanding of the hostname is the local name of the machine or IP address which we get it by "netstart an" on the CMD prompt. Now when sending serial data to the other device on the same network which one of the pairs do we use? (1) Hostname; Port...
  5. N

    Sending data & receiving data from another computer via TCP/IP protocal

    As you can see I'm able to ping that gadget from a remote computer, anyway I will keep on trying
  6. N

    Sending data & receiving data from another computer via TCP/IP protocal

    Hello there! The above code I have finally abandoned, it does not work at all, after replacing with a new code completely I'm now able to see quality data being sent by using this VBA CODE below : strData = BuildData(JsonConverter.ConvertToJson(transaction, Whitespace:=3)) lngStatus =...
  7. N

    Sending data & receiving data from another computer via TCP/IP protocal

    First to start with I'm currently using the COM serial port to send and receive data from a serial gadget which is working fine , no issues at all, but it cannot be used by multiple users or current users unless it was possible to share it over the network. The alternative to that is to use...
  8. N

    How to populate label controls on a form to act as a restaurant menu

    Sorry Sir; I'm not able to see where you added the code I checked the attachment it has no new code Regards
  9. N

    Challenges with Ms Access VBA with socket programming

    The_Doc_Man I do agree with you 100% in all your points: (1) The data I'm sending is in hex format as per requirement of the gadget , True (2) The data I'm expecting to receive is suppose to be in the same format , the way I receive it in COM PORT system (3) After changing the data length to 1...
  10. N

    Challenges with Ms Access VBA with socket programming

    The process will to hard to bring it into the accounting software which was written in Ms Access VBA, however, there is also plan B. If I use the utility software from the third party then all the work stations will be able to use that gadget since the shared port will be visible to all...
  11. N

    Challenges with Ms Access VBA with socket programming

    The Doc Man Thank you so much, you have some points here , after implementing the sleep function , the code is now generating again an error below, but I'm able to ping the gadget from the remote computer see the ping details lngStatus = OpenSocket("192.168.1.197", 8888) lngStatus =...
  12. N

    Challenges with Ms Access VBA with socket programming

    Run your code step by step to get a clearer idea of the problem than "nothing happens". I have done that it now giving an error on sending as below: send = -1
  13. N

    Introduction

    I'm a chartered certified accountant and have a good understanding of Ms Access but not very fluent, that is the reason why I'm here to improve my Ms Access programming and be in a position to sort out problems. Regards Chris
  14. N

    Challenges with Ms Access VBA with socket programming

    I'm not having my code below initializing the VBA socket code as a result when I start the code nothing happen , see the code below where I need help and suggestion for the required fixing. Calling codes in sub procedures Please strdata has the data in hex format Dim lngStatus as integer...
Back
Top Bottom