R
rcoombe
Afternoon,
Apologies if this topic has been covered but i struggled to find it if
it has. I'm a bit of a novice in Access so i was hoping someone could
help me.
At our warehouse we house alot of products from different companies,
when they come in the door we would have pallets of the same stock and
they would have a Product Code then "x" amount of days later some
stock would go out to a store. We have a basic DB to keep everything
in order but we are having problems with human error. i.e. a product
code might be 12345-A and the inputter might put 12345/A or even type
it wrong all together i.e. 122456-A.
I've been looking at various input masks and validation rules to
combat this situation. We have a list of the product codes that we
will have in and i was wondering if anyone could advise me if i could
put a validation rule in so that if the inputter tries to enter a
product code not on the list of valid product codes it wont let him/
her.
I've looked at the DLookUp function but had no joy.
Any help at all would be appreciated.
Thanks
Ross
Apologies if this topic has been covered but i struggled to find it if
it has. I'm a bit of a novice in Access so i was hoping someone could
help me.
At our warehouse we house alot of products from different companies,
when they come in the door we would have pallets of the same stock and
they would have a Product Code then "x" amount of days later some
stock would go out to a store. We have a basic DB to keep everything
in order but we are having problems with human error. i.e. a product
code might be 12345-A and the inputter might put 12345/A or even type
it wrong all together i.e. 122456-A.
I've been looking at various input masks and validation rules to
combat this situation. We have a list of the product codes that we
will have in and i was wondering if anyone could advise me if i could
put a validation rule in so that if the inputter tries to enter a
product code not on the list of valid product codes it wont let him/
her.
I've looked at the DLookUp function but had no joy.
Any help at all would be appreciated.
Thanks
Ross