=TB=
Registered User.
- Local time
- Today, 17:40
- Joined
- Aug 13, 2002
- Messages
- 68
I will try and explain my problem as clearly as possible and hope that one of you are able to help.
I have a simple db that is used for stock control purposes. The stock itself is held physically in different locations. The stock items are put into the database via a form with the fields [Item] [Qty] [Location]. The stock is dispatched via another form [Item] [Qty] [Location] the [Qty] field on this form, on update uses a few lines of code (courtesy of my college teacher) to change the value to a minus value. All the transactions in and out are then stored in one table. As all the dispatched qty is stored as minus figures within the table it’s easy to calculate current stock levels etc via a few simple queries and reports.
My problem is that at the moment there is nothing stopping or warning the user when they dispatch stock from a wrong [location]. I can run a query and filter that query to show all minus stock, but I am unsure how to manipulate this information. I have tried for days to find a solution to this. I have been working on the lines of running the query on update of the [location], is it possible from this dispatch form to throw up a warning triggered by the query returning a value? I can run the query on update of the [Location] field on the dispatch form but I need help with how to throw up a message box based on the query returning a minus value in the [qty] field of the query.
Thanks
I have a simple db that is used for stock control purposes. The stock itself is held physically in different locations. The stock items are put into the database via a form with the fields [Item] [Qty] [Location]. The stock is dispatched via another form [Item] [Qty] [Location] the [Qty] field on this form, on update uses a few lines of code (courtesy of my college teacher) to change the value to a minus value. All the transactions in and out are then stored in one table. As all the dispatched qty is stored as minus figures within the table it’s easy to calculate current stock levels etc via a few simple queries and reports.
My problem is that at the moment there is nothing stopping or warning the user when they dispatch stock from a wrong [location]. I can run a query and filter that query to show all minus stock, but I am unsure how to manipulate this information. I have tried for days to find a solution to this. I have been working on the lines of running the query on update of the [location], is it possible from this dispatch form to throw up a warning triggered by the query returning a value? I can run the query on update of the [Location] field on the dispatch form but I need help with how to throw up a message box based on the query returning a minus value in the [qty] field of the query.
Thanks
