Self reducing lists ?

  • Thread starter Thread starter Derek Joinson
  • Start date Start date
D

Derek Joinson

Hi,
is it possible to do self reducing lists in Access ? I have an Excel sheet
that can accomplish this, but it is getting very cumbersome and with lots of
people inputting data, it is not infallible.

E.G. I need to track serial numbered shock absorbers fitted to buses. They
can be fitted to 4 positions on each bus. Once I have fitted shock absorber
"Ser No 1234" to the front left hub on a bus, on the database how do you
prevent it being fitted to the other 3 positions on the same bus or to any
positions on other buses, as it is obviously physically impossible to have
it in 2 places at once.

Is it also possible to do this without VBA or macro routines, as I am not as
capable with Access as I am with Excel. Any help would be greatly
appreciated.
Cheers for now,
Dekka.
 
It seems that your 'list' would only pull up parts with a blank 'location'
field or a n 'installed' check box no checked. Another option would be to
remove it from your 'inventory' table once it is used.

I guess the basic question here is, Once you use the part, how are you
indicating that in the part record (or inventory) table? You should be
deleting it, reducing the onhand to "0" or checking it off as used somehow.


Rick B


Hi,
is it possible to do self reducing lists in Access ? I have an Excel sheet
that can accomplish this, but it is getting very cumbersome and with lots of
people inputting data, it is not infallible.

E.G. I need to track serial numbered shock absorbers fitted to buses. They
can be fitted to 4 positions on each bus. Once I have fitted shock absorber
"Ser No 1234" to the front left hub on a bus, on the database how do you
prevent it being fitted to the other 3 positions on the same bus or to any
positions on other buses, as it is obviously physically impossible to have
it in 2 places at once.

Is it also possible to do this without VBA or macro routines, as I am not as
capable with Access as I am with Excel. Any help would be greatly
appreciated.
Cheers for now,
Dekka.
 
Back
Top