Search results

  1. R

    Query to return multiple values

    I have a Part Number that is a foreign key between the 'iSup_table' (Supplier_item) and the 'Part_variance' table (Component_part_no_finish_code). Based on the Part Number, I need to return 'Line_num'. The issue is that a Part Number can have more then one 'Line_num' in the iSup_table. I need a...
  2. R

    Prevent duplicate records from a form

    I tried finding previous posts regarding this issue, but I couldn't find something that worked for me. Im trying to prevent duplicate records based on a PO # (RA_PO_Nbr), entered from a form. I'm trying to throw a 3022 error when the user attempts to enter a record that already exists, but I...
  3. R

    Update all rows w/in column using value entered on form

    I'm trying to update all the rows in a column (column A, PO Number) within a table (iSupplierTable). The value (txtPONbr) is entered by the user on a form (NewPO). Any assistance would be greatly appreciated. Private Sub cmdSubmit_Click() On Error GoTo cmdSubmit_Click_Error Dim db As...
  4. R

    Newbie

    Hello all, I am currently a Database Reports Writer for a international fixture supply company based in Omaha, NE, assisting the Customer Service team. I have very limited knowledge of Access and I'm learning more everyday. I joined the forum to seek advice and receive help with creating...
Back
Top Bottom