Desperate in need of help

[1eye1vision]

I need some help on a problem that has been bugging me for the past 4 months, everywhere i turn i cannot get help for this.
I have a DB for stores maintainance and what i have is a form on which stores are ordered. What i need is a way of accounting for the stores as they arrive and adding the quantity to the account for that item. However this must take into account that items sometimes are not received together and may turn up in batches. I had the idea of having an 'On-Order' table but don't really know how to proceed. This is the last piece of my project that i need to complete and it is really bugging me. Any help would be greatly recieved.

Regards in advance.

 

[FatD]

Hey i guess this site will help u...... i had some probs too n this site was quite helpful
http://msaccess.batcave.net

 

[ColinEssex]

You could have a listBox on a form to select the item that you're getting the delivery for.

Once selected, you then could have a subform that shows how many you have currently, what the re-order trigger number is (in case you want to change it) and their cost per item, and the current stock value.

Then in another subform, you have the new order delivery details - supplier, date, order number, number received etc and a button to add thatdelivery to the stock level.

The subforms are linked to the master by the IDNo of the item.

Col

 

[1eye1vision]

Thanks FatD, i'd already had a look at this site plus plenty of others and still have not come up with a solution to the problem. I'm not exactly the best programmer in the world and have been trying to solve this now for what seems like an eternity.

Regards

 

[1eye1vision]

hi colin, thanks for the response. The listbox sounds like a great idea. as stated in previous post to FatD, i'm not the best programmer so implimenting things aren't as easy as writing them down. I'll have a look tonight and see how i do. Thanks again

 

[The_Doc_Man]

Search this forum for "Inventory" and "Stock Levels". This topic has been addressed in literally hundreds of threads.

In summary, you never update inventory on hand. You DO, however, update inventory adds (via shipments received) and inventory removes (via customer purchases shipped) - plus transactions for shrinkage. Then, your instantaneous inventory on hand is always a QUERY of a QUERY.

In the first layer, you have your transactions, but use a UNION query so that you can impose a negative number on inventory outbound and shrinkage and a positive number on inventory inbound. Then write a summation query of the union query, and that is your instantaneous inventory level at all times.

While we don't mind helping people here, it would make your own life easier if you learned to use the forum's SEARCH function. It works great and this is not a new topic for us.

 

[1eye1vision]

Doc-Man
That's all very well if you are used to using access. I know that this subject has been covered several times and have seen some of the ways in which people have updated their databases. This however doesn't help me in my search for an answer to my problem. If it was that simple i would have probably completed the project by now.
Any other guidance would be useful though!!

 

[1eye1vision]

BUMP!! Does anyone have an answer for this problem

 

[1eye1vision]

Can Anyone Offer some help with this problem PLEEEEASE!!!. Don't know where to turn with this anymore!! Searched loads of different threads and can't see the wood for the trees.

Thanks in advance

 

[Rickster57]

Inventory

I would recommend you sit down and take a look at the Inventory database that comes with Access. Go to File>New>Databases>Inventory database.
You also may want to look at the Order Entry database as well.

 

[1eye1vision]

Hi All, still having major snags with this problem, had a look at the examples as suggested but with my lack of knowledge not having much luck.
any more help would be appreciated.

Thanks in advance