Enforcing/implementing quantity limits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone,

I am currently making modifications to a Access based stocktake program. At
present, when an item is scanned (through one of the applications forms)
information appears on the form relating to the part that was scanned (E.g.
part no, description, quantity and whether the part exists in the ITEM
MASTER table). This application also outputs a report which summarises what
was scanned and total quantities.

One improvement I want to make to the existing application, is to enforce a
quantity limit. In the ITEM MASTER table, I have created an additional column
called QLIMIT. QLIMIT is the quantity limit for each part - E.g. part 1234
has a QLIMIT of 5.

This is what I am trying to do:

Lets say I am scanning part 1234. As soon as I scan more than 5 parts (which
is the QLIMIT for this part), I want a onscreen warning to appear stating
that I have exceed the QLIMIT and that the part should be put aside.

Is there some way I can do this?

YOUR HELP WOULD BE GREATLY APPRECIATED.

THANKS
BAUER
 
How is the form set up that you are using for data entry? Is it setup
as a master/sub form?

Keven
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Problem 4
SQL Problem - Criteria 2
How best to remove different quantities from multiple records? 1
Adding Quantity 2
Add multiple new records based on quantity duplicating data 1
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
Inventory Help 3
Creating Criteria For Data Entry 3

Back
Top