Search results

  1. S

    Copy lines in a table/query using VBA

    I am not sure if this is even possible. I do a bill of material in a form with part numbers for (4) types of material in one color. Each material has several different colors. I do not do a BOM for each color because the cost is the same no matter the color. I then run a VBA to export all the...
  2. S

    How to export Reports to Multiple worksheets in excel

    I am trying to export 4 reports to excel so all reports got to one workbook and uses 4 tabs/worksheets. I can use the following for a table/query and it works great i get the tabs/wooksheet. DoCmd.TransferSpreadsheet acExport, , "90JJ AR by Rej", "C:\Documents and...
Back
Top Bottom