Search results

  1. N

    Solved How to get a socketID (data type long) from an Ip address & Port number

    So you need to store the lsocketID, no? Sorry I'm a bit behind what exactly are you saying?
  2. N

    Solved How to get a socketID (data type long) from an Ip address & Port number

    ' Create a new socket Dim lsocketID As Long lsocketID = Socket(AF_INET, SOCK_STREAM, 0) If lsocketID = SOCKET_ERROR Then Err.Raise GENERAL_ERROR, "WinsockOpenTheSocket", "Unable to create the socket!" End If MsgBox "Here is a SocketID" & " = " & lsocketID That...
  3. N

    Looking VBA Winsock/JSON Consultant

    Okay Kindly email me : nectorzambia@gmail.com
  4. 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.
  5. N

    Solved UPDATE QUERY THROUGH VBA

    Well I have finally given up the query below changes the date to 22/11/1900 fortunately we had just captured 30 invoices and we had printed the hard copies , I had to go into studio management to correct the dates again. This means that I have to stick with the original code below though...
  6. N

    Solved UPDATE QUERY THROUGH VBA

    Here is my final try: Dim db As DAO.Database Dim strSQL As String Set db = CurrentDb strSQL = "SELECT * FROM [tblCustomerInvoice] WHERE tblCustomerInvoice.InvoiceID)= & [Forms]![frmCustomerInvoice]![CboShipDateChange]" strSQL = "UPDATE tblCustomerInvoice SET tblCustomerInvoice.ShipDate = #" &...
  7. N

    Solved UPDATE QUERY THROUGH VBA

    What if I do it this way : UPDATE tblCustomerInvoice SET tblCustomerInvoice.ShipDate = #"Format(( [Forms]![frmCustomerInvoice]![txtChangeShipeDate]),"YYYY\/MM\/DD")&"# Sorry I'm just guessing here, and so corrections will be required!
  8. N

    Solved UPDATE QUERY THROUGH VBA

    The date is 2 November 2023 English date not American Its just the code below where I'm confusing myself: UPDATE tblCustomerInvoice SET tblCustomerInvoice.ShipDate = #11/02/2023#
  9. 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...
  10. N

    Solved MS Access VBA DoCmd Print Command Error

    Fortunately the code below has worked as required: DoCmd.OpenReport "RptPosReceipts", acViewPreview, "", "", acNormal DoCmd.PrintOut DoCmd.Close acReport, "RptPosReceipts"
  11. N

    Solved MS Access VBA DoCmd Print Command Error

    The error is occurring immediately after preview which is visible to everyone ,the error is wrong property assignment. Here I do not want to see the preview mode but direct printing
  12. 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...
  13. 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...
  14. N

    Linking SQL Server tables with VBA

    Just compose the ODBC DSN less like below then you are done! DRIVER={HDBODBC};UID=myUser;PWD=myPassword;SERVERNODE=myServer:30015
  15. N

    Please help me understanding this Query

    If possible just post the database we will assist you , we also started from where you are , we leant every trick strategies from others
  16. N

    Please help me understanding this Query

    This section appear to be incomplete , I think you wanted to pick the following: (1) Product ID (2) Product Name (3) My ID ( What is this????????????/) (4) I cannot see the quantity here Here is what we do with an SQL like the one you want to do: SELECT tblCustomerInvoice.InvoiceID...
  17. N

    Developing a calculator in Ms Access VBA

    This is wonderful stuff, I never expected this. Many thanks uncle Gizmo
  18. N

    Developing a calculator in Ms Access VBA

    Thank you so much uncle Gizmo, this exactly what I was looking for.
  19. 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...
  20. N

    Macro to use the value of a textbox in a search

    I think the filter method is the way to go , just bind that txt box to some combo box . First create unbound combo box base it to your record which you want to be searching , then simply filter that combo box with your text box , then you can use vba for the final update.
Top Bottom