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
 
Back
Top