Results 1 to 9 of 9
  1. #1
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124

    Update Quantity

    Hello Forum,

    I am a student and current having my intern with a reputable company in Singapore.


    I am have trouble with programming Microsoft Access 2016 as I am completely new to it.

    I have to Design a database to keep track of inventory items (qty) going in and out of the stores, from different racks..

    I couldnt get the table to be updated and shown in the next row.

    Can anyone help me out?

    Thanks.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you dont edit items in the next row,
    you edit items in your current row.

    you dont really need to know programming, BUT access can be run via macros.
    in a macro, you just pick and choose your action wanted.

    Now if you are running inventory, the current item is sold, so youd run an update query to reduce the Qty of the purchase.
    Everything is queries.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  4. #4
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124

    Macros or update queries or both?

    Quote Originally Posted by ranman256 View Post
    you dont edit items in the next row,
    you edit items in your current row.

    you dont really need to know programming, BUT access can be run via macros.
    in a macro, you just pick and choose your action wanted.

    Now if you are running inventory, the current item is sold, so youd run an update query to reduce the Qty of the purchase.
    Everything is queries.

    Thanks for the reply. May I know which macro should I use to get an action to update quantity for next transaction?

    How do I use the update query to add or subtract value from my existing stock quantity?

    Which method do you recommend? Macros or update query

  5. #5
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124
    Thanks. I will look into the items in the two links

  6. #6
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124
    Hello forum,
    I am facing a problem with the relationship set for my tables. I want the program to be able to update the qty of the items drawn out or stocked in by user.
    Can someone help me out?

    Thanks,

    Yours Sincerely,
    Haziq

  7. #7
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Run an update query and then Requery the form. After you update the underlying table, you need to get the form to go back to the table and re-get the information and display the new values. Forms do not change on their own.

  8. #8
    MdHaziq is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2017
    Location
    Singapore
    Posts
    124
    How do you get the form to go back to the table to re-get the information?

    Thanks for your reply

  9. #9
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 06-03-2015, 04:04 PM
  2. Replies: 3
    Last Post: 05-17-2015, 10:11 PM
  3. deduct Quantity from a Query
    By raffi in forum Queries
    Replies: 1
    Last Post: 11-08-2014, 05:08 PM
  4. Find quantity and seqnumber
    By mathanraj76 in forum Programming
    Replies: 4
    Last Post: 05-28-2013, 07:26 AM
  5. products and quantity
    By woody in forum Forms
    Replies: 2
    Last Post: 02-06-2011, 11:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums