Search results

Is it possible to translate this language into English , we can easily assist on this one: ¿Mi base tiene dos campos "mes" y otro "número de folio" como diferencia entre dos meses? ej Enero 198030 Febrero 302105 marzo 504265 La Diferencia Entre enero y febrero, febrero y marzo, etc ... se Hace...

The answer here is that you are trying to open the record source by a query , this means that your VBA code should take into account of that: Dim dbs As Database Dim prm As DAO.Parameter Set dbs = CurrentDb For Each prm In qdf.Parameters prm = Eval(prm.Name) Next prm...

Do one the following: (1) If you are using split tables , that is the application separate and the data , then delete the links and recreate new ones and refresh the links using the link manager it should be able to work (2) If you are using SQL server to store your data then use ODBC 13.1 to...

Sorry May be I did not understand your question properly, the simple way is just create an SELECT QUERY , then convert that query into UPDATE AND CALL its name in VBA Name of a query = QryGrnTagDebit UPDATE tblGrnAccountDebit SET tblGrnAccountDebit.GrnStatus =...

Kindly see the design layout view where do I go to adjust the report

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?

Thanks

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 ??????

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

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

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

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

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

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

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

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

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

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

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

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