Search results

True I'm calling it from windows API and for me its a game changer

Ok Let me try it

Very true , that is why I'm trying to amend the code to use the code below but I seam not to get it right for whatever reasons: #If VBA7 Then<br> Public Declare PtrSafe Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As LongPtr) 'For 64 Bit Systems<br> #Else<br> Public Declare Sub Sleep...

I think you wanted to suggest that I need to compose a code like below so that I simply call it like what you are saying because SLEEP function does not work on its own without a function support module in MS Access Option Compare Database Option Explicit #If VBA7 Then Public Declare...

The symptoms here is that the code can only abort when the internet is not there and keep on trying sending if the internet is there which is not what is required. Meaning the time limit is not relevant! Business Rule: Whether there is internet or not the code must allow only 10 seconds once...

Many thanks Let me test it properly at 14:00 hours then I will give feedback

The VBA code below sometimes takes more than twenty seconds to run, now a decision is made that if this code takes longer than 20 seconds then it should quit and move to the next code instead of rotating for 10 minutes on one code, for sure a timer is required, that is where it's getting...

Many thanks a lot sir, you just opened my mind I think just taking your idea you wanted to say this, and it works ok Public Sub txtProductCode_AfterUpdate() Dim lngProdID As Long Dim sReturn$, varValue As Variant If Not (IsNull(mID)) Then 'DoCmd.GoToControl "sfrmPosLineDetails...

Still an error here

Just use this box to capture the second line you will get an error , first no error second line you have an error Example (1) 410000100 (2) 410000101 (3) 410000102 If you use the form to capture yes the code it works ok but the scan box is where the scanner scan , the form is meant for manual...

There is still an error when you try to capture the second item on the addnew

To appreciate the question above kindly get the database attached and simply go to properties and check the unblock field then it will open. For the keyboard to work simply compile the code.

Below is the attached DB

Ok give some time let get it orgaizized

Let me check properly

Here is an error Im getting I'm not sure how to change it

The demo db works ok but the same concept when I transfer it to the actual POS I'm getting an on the calculator code even after changing the external sub to public. Here are the changes I did make Public Sub txtProductCode_AfterUpdate() Dim lngProdID As Long If Not (IsNull(mID)) Then...

Many thanks arnelgp exactly that is what I was looking for

This scenario is based on a POS touch screen where you cannot see any keyboard for data entry, now in MS Access we built a Keyboard unbound form to assist in capturing data. The reason why we did it that way is that there are some situations when the scanner fails to scan the barcode, and so the...

This is excellent job and well done arnelgp it was not easy to think in those lines I'm sure it will help others well