468,292 Members | 1,499 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,292 developers. It's quick & easy.

Decrease product inventory count as items are removed.

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
1 1708
pbmods
5,821 Expert 4TB
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.

Similar topics

2 posts views Thread by Kenneth Courville | last post: by
7 posts views Thread by simon | last post: by
MonolithTMA
3 posts views Thread by MonolithTMA | last post: by
10 posts views Thread by mistb2002 | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.