Search results

  1. N

    Looking VBA Winsock/JSON Consultant

    I'm looking for a VBA Winsock consultant to assist me on the new project I will be doing in January 2024, it's not for Free but payable at a negotiated price, I will appreciate if someone can direct me to seasoned MS ACCESS VBA /JSON programmers.
  2. N

    Solved UPDATE QUERY THROUGH VBA

    I'm currently using cloud database, so to improve the speed I need to use a pass-through query from MS Access so that I can deal with the server directly. I'm trying to open the record source in VBA, that is where I'm getting it wrong. See below why the code is not changing the date. Dim db As...
  3. N

    Solved MS Access VBA DoCmd Print Command Error

    Dear Experts! Sorry once again! I want to have a POS receipt sent directly to the printer after selecting the receipt number in the combo box using the after events property, but it is giving me an error. I do not want to preview anything here , below is my VBA Code. Private Sub...
  4. N

    Solved Rules to be implemented with Ms Access against SQL Server Cloud

    Maybe I’m missing something here, I have been following the rules listed below to implement my cloud-based database SQL Server, I can confirm the rules listed below have sorted out all my reports, they pull data almost instantly BUT not data entry forms, the parent and child forms have these...
  5. N

    Developing a calculator in Ms Access VBA

    Well I have a working calculator in my POS form but the only problem is that, to use it you need to be clicking the button . Is there a way to use keyboard button which also act like the onclick event key. The windows calculator has both the key board usage or mouse, how can we do the same with...
  6. N

    How to set point of sales invoice report in Ms Access

    I need help on how to set the POS receipt in Ms Access. What is happening is that , the receipt is coming out Okay but it prints 3 extra blank copies, how do I stop this paper wastage?
  7. 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...
  8. 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...
  9. 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
  10. 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...
Top Bottom