Recent content by rdowney79

  1. R

    Query to return multiple values

    Issue solved. I went to a previous query in the DB and was able to get my desired results. Thanks!
  2. R

    Query to return multiple values

    Tried to clean it up for clarification purposes. Hope that helps. Thanks, Ray
  3. 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...
  4. R

    Prevent duplicate records from a form

    Issue Solved. thank you Pr, you were a tremendous help. Button - that seems to be much a much easier route than using vba to throw error. What are the drawbacks to simply electing a column to be 'Unique' and 'Required' over using VBA, as I have in this instance? Thanks, Ray
  5. R

    Prevent duplicate records from a form

    Pr, thank you for the quick response. Im very new at Access, so I'm learning on the fly. I tried your response, but got an 'Error (2428) - You entered an invalid argument in domain aggregate function.' which I clueless about. Also, the data type for RA_PO_Nbr is currency.
  6. 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...
  7. R

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

    Issue Solved. The issue was with how I was running the query. Instead of DataSheet View, I Ran the query instead and it worked. Thank you for all your help pbaldy. Thanks, Ray
  8. R

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

    There is a submit button that is pressed after user inputs the value in the form, does this have any impact? UPDATE iSupplierTable SET iSupplierTable.[PO Number] = [Forms]![frmNewPO]![txtPONbr]; Damn I must be green, I'm not sure what you mean on your third point.
  9. R

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

    does this look right for the query? Field: PO Number Table: iSupplierTable Update To: [Forms]![frmNewPO]![txtPONbr] I dont get any results Thanks, Ray
  10. R

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

    How would I store a user input (from the form) to be used in an update query? Or Is there a way to prompt for a user input, with an update query alone?
  11. 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...
  12. 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...
See more
Top Bottom