By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,849 Members | 2,169 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,849 IT Pros & Developers. It's quick & easy.

Decrease product inventory count as items are removed.

P: 2
Hi i created an access 2003 dmb that tracts inventory by a production number. Now i need a way to decrease the inventory as it gets removed from inventory which a clerk would input.

i know the basics of how it would be done but im not sure how to call the sql function i would need to write.... or even how to write the sql function.

Here was my idea and maybe you can help?

they would input the production number?

they would input a number that would reflect how much of that specific item to deduct from inventory.

then it would find that record.

It would subtract they number they inputed from the value of the number of items in the inventory

If the inventory is 0 or less i want to delete the record
if it is above 0 i want to update that record.

my problem is that i dont know how to A) find that specific record and passing the argument to vba

and then i dont know how to delete the record in vba

pretty much i dont know how to do anything anymore cause i havent done vba in about 3 years :(
Jul 19 '07 #1
Share this Question
Share on Google+
1 Reply


pbmods
Expert 5K+
P: 5,821
Changed thread title to better describe the problem.

Moving to the Access forum....
Jul 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.