Search results

  1. K

    - Bali ang gusto ko sir makuha na minimum stocks (3months) yung last 3 months receipt date from...

    - Bali ang gusto ko sir makuha na minimum stocks (3months) yung last 3 months receipt date from Purchased Received Qty) - Tapus yung consumption sir yung Last three months Issuance Qty. ito yung file ko sir: https://drive.google.com/file/d/1OUewjgzuUjYcWzO-V5qfrLYCjOF7tmnu/view?usp=share_link...
  2. K

    Hi sir arnelgp, I have tblStocks Table Entry StockID-0001 ItemDescription-Boy Bawang...

    Hi sir arnelgp, I have tblStocks Table Entry StockID-0001 ItemDescription-Boy Bawang InStock-20 Stock Form Stock ID - 0001 Description - Boy Bawang In Stock - 20 I want to Display the following Minimum Stocks (3 months)= Actuall Consumptions( 3 months) = Average...
  3. K

    Have a good day to all. I'm just asking your opinion of what is the best way to extract my...

    Have a good day to all. I'm just asking your opinion of what is the best way to extract my Inventory level as per below concern. This is very helpful in order to ascertain the recurring stock level to avoid inventory shortage. Thank you so much in advance. tblStocks ItemID-123...
  4. K

    Merry Christmas and a Happy New Year in 2023

    Merry Christmas and advance happy new year too!!!
  5. K

    Have a good to all you sir!!! I need your expertise concerning below issue which i try to...

    Have a good to all you sir!!! I need your expertise concerning below issue which i try to manage but unfortunately im failed to do in microsoft access report. https://drive.google.com/file/d/1-f0H4I2SZORaSuUPiprb_ykDhuyHf5gQ/view?usp=sharing Thank you so much and you assistance is really...
  6. K

    Access Front-end Auto-Updating Utility ?

    thank you so much sir..
  7. K

    Access Front-end Auto-Updating Utility ?

    just put PtrSafe before Function
  8. K

    Warehouse Inventory Project

    THANK YOU SO MUCH SIR
  9. K

    Warehouse Inventory Project

    I knew you are expert sir. But possible sir you can check the attachment . If i put back the "Option explicit" the sorting has an error when i remove its working . I need your help on how to avoid that error even with Option Explicit declared.
  10. K

    Warehouse Inventory Project

    thank you for that concern. I'm just intermediate in VBA...
  11. K

    Warehouse Inventory Project

  12. K

    Warehouse Inventory Project

    use this code in your search button. Option Compare Database 'Option Explicit << remove this Private Sub Search_Button_Click() Dim strFilter As String Dim strDateStart As String Dim strDateEnd As String If IsNull(Forms![test].FromDate) Or Forms![test].ToDate = "" Then MsgBox "Start...
  13. K

    Solved How can I hide/unhide item in combo box as per user login

    If you have a spare time sir. Yes.. its my pleasure. Actually it's working already but i believe that you have a more effecient way.
  14. K

    Solved How can I hide/unhide item in combo box as per user login

    Thank you so much sir. now it's working... I just tweaks some but your code really matters. And thank you to all...
  15. K

    Solved How can I hide/unhide item in combo box as per user login

    Thank you so much... thank you so much sir
  16. K

    Solved How can I hide/unhide item in combo box as per user login

    THANK YOU SO MUCH SIR
  17. K

    Solved How can I hide/unhide item in combo box as per user login

  18. K

    Solved How can I hide/unhide item in combo box as per user login

    Thank you for your response sir. Actually sir im using user Role to manage that permission. User role - Administrator - Production - User I'm using Global User role Private Sub Form_Load() txtUser.Value = strUser txtRole.Value = strRole Select Case strRole...
  19. K

    Solved How can I hide/unhide item in combo box as per user login

    Have a good day to all!!! I just want to ask your favor on how to hide/unhide item in the combo box as per user login. Combo Box item List 1. Remove Stock - This will show only for user - A 2. Manufactured Parts - This will show only for user - A 3. Move to Warehouse - This will...
  20. K

    HELLO TO ALL !!! THANK YOU ADMIN FOR ACCEPTING ME

    Thank you sir.
Back
Top Bottom