Search results

  1. P

    Output file name

    I have a report that exports to PDF with the shipment number as the filename, but I want the file name to include the values from two other fields [CSR] and [facility] in the same query. Nothing I do works. Any Help?? Private Sub Command30_Click() Dim db As DAO.Database Dim rs As...
  2. P

    DLookUp or not??

    Hello Everyone, I'm trying to get a Dlook up to compare a 3 character long text string in one column in a query to a column in an unrelated table and if they match to return the word "Match" Is Dlook up the wrong solution? Table name "Altos" Table Column "AlCode" Query Field Name "Altos1"...
  3. P

    Looping Left function has me stumped

    Hello Everyone, I have a sub-form in datasheet view with several records, the first two characters of each record make up a product code, that is then copied to a field on the parent form. I can split the first two characters from the first record. I've tried everything I can think of to loop...
  4. P

    so simple yet it eludes me

    Please let me know if posting in the wrong place, and let me say thank you upfront. I have a strange text file that contains values separated by a 2 character abbreviation. ie. "PN" and "QT" I can import just fine, but I can't seem to get the data to separate into separate columns. This is...
Back
Top Bottom