Recent content by roh710

  1. R

    NotInList VBA Code Problem

    I understand now. I will try that and I will post the result soon. Thanks! KR
  2. R

    NotInList VBA Code Problem

    Thanks for your post. I kinda follow what you're saying but not sure how I should change my code. I tried to change DoCmd.OpenForm "AddNewCustPartNo", , , , acAdd, acDialog, NewData to DoCmd.OpenForm "AddNewCustPartNo", , , , , acDialog, "CustPart_No = '" & NewData "'" but that didn't take...
  3. R

    NotInList VBA Code Problem

    Hi Everyone, I have a form with combobox which has a corresponding customer part number for our own partnumber. When a customer part number which does not exist in the combobox is entered, the "AddNewCustPartNo" form will pop up. The idea is to have the NewData(the new customer part number)...
  4. R

    E m a i l Invoice from Customer Order Form with Command button

    I was able to get the code below to work over the weekend at home. However, when I came to my office this morning and tried to run the code, it' gave me following error message: Run-time error '2282': The formats in which you are attempting to output the current object is not available. It...
  5. R

    E m a i l Invoice from Customer Order Form with Command button

    I am trying to send invoices via e m a i l. I have an invoice form and once the form is filled in, I can create invoice with click of command button. What I want to do from this point is to create another command button for emailing the Invoice (Report) as an attachment (PDF) to the...
See more
Back
Top Bottom