How do I update Inventory in Access
Thank you for taking the time to report an issue.
What's wrong... Please write below.
SET Inventory.Available_Copies = (SELECT COUNT (*) AS Count from (Select DISTINCT BOOK_ID from BOOK_COPY where Book_Copy.Status_abbrv = 'CI');
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
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
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.
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.
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).
What I can't seem to wrap my head around is performing a record lookup from the scanned data (I have a table with scanned data to add to inventory (tblAddInventory), a table with scanned data to remove from inventory (tblRemoveInventory) and a master table with all ofmy warehouse inventory (tblWarehouseMain) and performing a calculation on the records to add - or subtract - stock, depending on what table the data comes from.
I am (er, rather used to be) comfortable with VB.
I have tried to create an update query as well as some basic code via control on a form, but I'm finding myself at a loss. Anyone willing to take a shot at helping or pointing me in the right direction?