Search results

  1. L

    Filtered report and export it to excel

    Thanks for Your response I fix it with macro, but the next problem coming I have 5 reports need to export to one xls file, and those 5 reports want to write to sheet1 .... sheet5. How to solve this...? thanks
  2. L

    docmd.outputto vs docmd.transferspreadsheet

    may somebody help me please. I need to export my report to excel I use docmd.outputto, the result is oke, but it only write to single sheet, it can repeat to sheet2 sheet3 etc. I use docmd.transferspreadsheet, it cannot work if the source to export is report. It only work if the source is...
  3. L

    Filtered report and export it to excel

    May Somebody help me I want to running report with filter by combobox, and export this report to excel. In fact, I can see the report with success, but when I see the xls result, it not represent the filtered report. Can somebody help...? thanks in advance
  4. L

    sheet name in excel file...?

    Hi May somebody help me, I want to write sheet name in excel file with the item was choosed in combo box, when running docmd.outputTo Please help thanks
  5. L

    create button, export five report same format to five sheet of one file xls

    Thanks Uncle Gizmo I only beginner in vb access, may You or other in this forum help me more, with example. I want to create button in Form1, after I click this button, each of all item in combo box need running the report, an each report export to sheet1, sheet2 to excel file (one file). The...
  6. L

    create button, export five report same format to five sheet of one file xls

    Hi Please help me, I have the form, in this form there is list of value which run query and resulting the report. For example if I have 5 item in list, i have to choose one of then and the query running and the report is print preview. My question is, How to export all 5 report to 5 sheet in...
Back
Top Bottom