Recent content by nector

Thank you all the respondents it looks like nothing is wrong here and from the test all is fine the people are working ok no issues at all

It's fine I'm told the end point can allow one product at a time

I think from your advice unless I got you wrong am supposed to restructure the code like below so that it gives me the correct formatted product list in Json format , see attached Private Sub CmdSubmitTaxinfor_Click() Dim db As DAO.Database Dim rs As DAO.Recordset ' Use a Collection...

Please note that the API that send data is designed to send a single record at a time you cannot send bulk record at one go the answer is NO, only when the first single record is complete only then can you move to the second, third, fourth etc

Here I wanted to filter this query called QrySmartInvoiceProductsDetails now reproduced below that is where I have some challenges: SELECT tblProducts.bhfId, tblProducts.itemCd, tblProducts.itemTyCd, tblProducts.orgnNatCd, tblProducts.pkgUnitCd, tblProducts.qtyUnitCd, tblProducts.btchNo...

Sir you are free to correct where you have seen an error many thanks for your contributions , but below is how I'm selecting all the products in the list box Private Sub CmdSelectitemstosend_Click() ' Define a variable for the list box Dim LstBox As ListBox Dim i As Integer...

I have changed a combo box to a list box to allow for selecting all the products at one go and the combined VBA code looks like below, but somehow it does not work. Where do I go wrong Private Sub CmdSubmitTaxinfor_Click() Dim varItem As Variant Dim strWhere As String Dim i As Integer '...

We are planning to open a supermarket in a busy place now the tax authority requires us to be sending any prices changes to their office each time we make any changes The reason for this is to ensure that they have record also The prices changes are sent to the tax authority by using an API...

My apologies to you all for not responding quickly to your valuable contributions I was away attending to a funeral. Many thanks to all I really appreciate your help on this matter

We are keeping some SKU or product lines around 45,000 in the product table now updating prices line by is very cumbersome and time consuming, and so I'm compelled to building a split form which shows all the products with the listed controls and commands: (1) Percentage Change (This is where...

Many thanks to all the contributors and you corrected me in many areas where I was getting confused.

The program below works very fine no errors whatsoever; we have also made sure that all the tables have primary keys and foreign keys to easy searching records. However, someone whispered to me yesterday that the domain functions included in your VBA will be slowing the speed and the solution to...

I'm not too sure whether you understood the code properly, Sleep (10000) The reason why the sleep code is there is too allow the top code to do its job if takes more than10 seconds then its timed out , the code move to the next stage, this is where I thought maybe I mixed it up or missed...

Here I'm trying to sleep the function below for 10 seconds so that if the internet is not connected it should move to the next code and provide a friendly message to the user so that the user knows exactly what is happening. What is now happening (1) If there no internet the code works ok and...

Many thanks to you all our valuable professionals we appreciate all your contribution and I'm glad that to say that through your help we managed to sort it out and its working ok.