Recent content by nector

  1. N

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

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

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

    Ok Let me try it
  3. N

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

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

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

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

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

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

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

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

    Solved In MS Access if the VBA code is taking longer than required how do we force the code to next

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

    Solved Transferring data from unbound MS Access Form to another form

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

    Solved Transferring data from unbound MS Access Form to another form

    Still an error here
  10. N

    Solved Transferring data from unbound MS Access Form to another form

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

    Solved Transferring data from unbound MS Access Form to another form

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

    Solved Transferring data from unbound MS Access Form to another form

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

    Solved Transferring data from unbound MS Access Form to another form

    Below is the attached DB
  14. N

    Solved Transferring data from unbound MS Access Form to another form

    Ok give some time let get it orgaizized
  15. N

    Solved Transferring data from unbound MS Access Form to another form

    Let me check properly
See more
Back
Top Bottom