Topics Search

How do I update Inventory in Access

How do I update Inventory in Access
Views: 116
I have a form where the user enters the item purchased and the quantity - I want that quantity entered in the customer invoice to be deducted from the Quantity_On_Hand field in the Inventory table. What would be the best way to accomplish this? I assume I would need to enter an expression in the after update on the quantity in the customer invoice? What I have tried so far has accomplished nothing but errors
Sponsored Links:

More topics

 

Count Distinct in Access

Preview
I'm trying to do a select count distinct values for a table. Reading a few sites on google, I know that access does not support this. The database is for a library inventory system. I have 2 tables: Book_Copy and Inventory. Book_Copy has the columns (Copy_ID, Book_ID Checkout Date, Check In Date and Due Date, Status). The inventory table has columns: Inventory ID, Book _ID and Available Copies. I am trying to update the Inventory table, Available copies column based on the status (checked in) in the Book_Copy table. I have tried to write an update query trying different ways but all I end up getting is syntax errors. Any help would be appreciated. This is what I have tried:
UPDATE Inventory
SET Inventory.Available_Copies = (SELECT COUNT (*) AS Count from (Select DISTINCT BOOK_ID from BOOK_COPY where Book_Copy.Status_abbrv = 'CI');
 

Accessing my inventory remotely

Preview
I have a simple Inventory application (developed using Access 2000) which is stand alone. That is the changes to the inventory can be done only on a single PC.
Now, I need to make it available from different geographical locations i.e. via internet. However, it will be accessed from one location/one user at a time. My inventory application requires Access 2000 to run.
Is there any way that I can upload Access 2000, my inventory application and associated folders to a remote 24/7 Server and access it at will. What is the simplest way to do this
 

retail and wholsale in a ms access 2007 database

Preview
please is it possible to have a store inventory, retail inventory ,wholesale inventory separately in ms access database?
the sale point will be one it will just reflect where the item is coming from.
for example someone comes to buy from wholesale, it deducts from the inventory in wholesale, if the person comes to buy from retail it deducts from the inventory in retail
at the end of the year if we want the stock taking, it does the individual inventory and totals all the inventory together
would be glad if any help is rendered
 

Inventory Form that adds/subtracts from current inventory number in table

Preview
I am currently trying to create an inventory database that includes a form that will update the inventory numbers last updated in the database. Rather than having one row constantly being updated in the table, I would like to keep track of what has come in and out of the warehouse and when.

So far, I have the fields on my form and am able to update the next record by entering in numbers, but I'm not sure how to use what I enter into the fields (based on a dropdown of inbound/outbound) to either subtract from or add to the last updated record in the table.
 

retail and wholsale in a ms access 2007 database

Preview
Retail inventory ,wholesale inventory separately in ms access database? the sale point will be one it will just reflect where the item is coming from. for example someone comes to buy from wholesale, it deducts from the inventory in wholesale, if the person comes to buy from retail it deducts from the inventory in retail
at the end of the year if we want the stock taking, it does the individual inventory and totals all the inventory together
 

How to make an Update Query

Preview
I'm trying to create an update query. I have an inventory table that contains the type of inventory. One of my inventory types is "Copy Machine". I want to create an update query that changes "Copy Machine" to "Copier", but I am really struggling
 

Update Record using Combo Box To Navigate

Preview
I currently have a table with three fields (Brand, Service, Inventory).

Brand is a primary key, it can only show in the table once. However, I'll need users to go into the table and update the service and inventory numbers every month.

What I envision is a form in which Brand is a combo box, the user can pick their brands and then the Service and Inventory fields change to whatever in in the table currently. The userscan then update those values, hit a button, and the changes are stored in the table.

I've already tried doing this and what happens is on the first record, I try changing the brand, and the first records brand changes to the one I picked and it is saved in the table (like Ineed to make brand a locked field).
 

Running an inventory query

Preview
My job is using Access 2003. I want to be able to take a weekly inventory of products. I figured out how to use a query to print a list of products that should be reordered based upon minimum sotkc level - current level = reorder quantity. I am trying to figure out how to track the usage of a product. Can I make that query note the current date and inventory level and update some table each time. So I could look at an item and see each week how many of that item was ordered?
 

Simple Inventory

Preview
I'm trying to use a query to show my current inventory. I produce chili and have ingredients and when ever I use an ingredient I would like it to be removed from my inventory and whatever I created will be added to my inventory or query.
 

Access Well Customized Inventory management Database

Preview
I'm currently looking to hire someone with very well known microsoft access programming.
I need someone to program an automatic inventory system to with with my ecommerce webstore and other selling locations.

I also have an question before starting. Does this person needs to locally program the inventory database from scratch at my local computer, or is he able to do it somehow online and add it to my access.