Search results

  1. C

    Updating Stock Quantites

    Thanks for your quick response. So i should not have a quantity in stock value in my Stock List table?
  2. C

    Updating Stock Quantites

    I am relatively new to Access and am having to learn a lot on the job. I have been asked to Create a "Stock Database" This will be used by primarly 2 people, the storesperson and a sales person. We need to to show Part number, description, quantity in stock, latest stock check (which i...
  3. C

    Prevent duplicate entries of a field on an input form

    Brilliant, Thanks for your help. Got rid of a couple of duplicate PO numbers and it now allows me to set the index of the Purchase order number not to allow duplicates. Thanks for your help everyone.
  4. C

    Prevent duplicate entries of a field on an input form

    I believe i have removed all null values. However, when I then change the index to not allow duplicates, the following error message appears: The changes you requested to the table were not suxxessful because they would create duplicate values in the index, primary key or relationship. Change...
  5. C

    Prevent duplicate entries of a field on an input form

    They seem correct. The Table is called Orders. With the field in Orders called Purchase Order Number The field in the form is called PO_No
  6. C

    Prevent duplicate entries of a field on an input form

    Hi, Thanks for the code, I have tried this but it still lets me enter a duplicate PO number.
  7. C

    Prevent duplicate entries of a field on an input form

    Thanks for your suggestions. Unfortunately, I do not really want to change the system dramatically. Is it not possible to use a DLookup to stop the duplicate entry of a PO Number??? Thanks again for your help
  8. C

    Prevent duplicate entries of a field on an input form

    If im correct from reading the code you have suggested. It will automatically generate the next purchase order number when you go to enter a PO. The issue with this is that we may enter PO number 12 one day and then 10 the next day if quotations take a long time, or there is a delay.
  9. C

    Prevent duplicate entries of a field on an input form

    Hi, Yes each invididual purchase order number is unique and never gets repeated. I would just like a pop up to appear if a duplicate PO number is entered by accident. Thanks
  10. C

    Prevent duplicate entries of a field on an input form

    Hi All, I have recently started working for a new company and have inherited a nightmare of a system! I have basic knowledge of Access and have been asked to stop duplicate entries under the same PO Number. I have tried using DLookups by looking at other posts on the forum with no success...
View older results
Back
Top Bottom