Search results

  1. J

    Updating 100 records in a table using a single Form Entry

    I Work for an NHS organisation. A department here orders prescriptions and sends them out to Gp Surgeries. I have been tasked in designing a database to make this easier for them. Prescriptions arrive on a Pallet. Each pallet has 100 Boxes of prescriptions on it. Each box Contains 2000...
  2. J

    Code to take me to a Duplicate Record

    Hi, i am new to Access I have a form based on a query and have written code to display a msgbox if a duplicate entry is inputted in the NHS_Number field in the form. I have also added code "me.undo" to clear the form so that it is not saved. I am looking for a piece of code that will display...
Top Bottom