Search results

Many thanks to arnlgp for clearly sorting out this and many thanks to all the contributors for your effort are also highly appreciated I have learnt a lot I hope even newcomers will benefit as well.

T The code above simply erase data as you are enter the barcode

Many thanks I think your idea will surely work here

I have a product table which hold products for six warehouses. The business rule here says each of the six warehouses must have the same products name, but the difference should be the primary key or differentiated by the primary key. The reason being each warehouse represents a branch listed as...

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