Recent content by underc

  1. U

    Export and automatic rename a report

    Hi AlexHedley This is a nice way of doing what i want. :) Thank you for your time!
  2. U

    Export and automatic rename a report

    I've done this in a form Dim strPathAndFile As String strPathAndFile = "C:\Users\Name\Desktop\" & Seq_number & ".pdf" DoCmd.OutputTo acOutputReport, "FI_IDs", acFormatPDF, strPathAndFile, False The problem is that i must be in a form with a record open like "101" When i run the code, it will...
  3. U

    Export with todays date as filename

    Hello ghudson Can you do that but instead of the date filename i need a field value from my query as filename. Could you hlep me? Thanks
  4. U

    Export and automatic rename a report

    I don´t really know how to do that. I need a button in a simple form (without records) that when pressed will open the "FI_ID" Report based in a Query. Then automatic save it (export) in PDF format with the name of a field value in that report. If the field value is Tom it must save the file as...
  5. U

    Export and automatic rename a report

    Hello AlexHedley, thanks for your reply. I´m using a macro, but don´t know where and how to get the field value... So i try to do it with VBA, but got the same problem... don´t know how to get the field value in the report called "Seq_Number". 1. DoCmd.OpenReport "FI_ID", acViewPreview...
  6. U

    Export and automatic rename a report

    Hello everyone. I need some help in access 2010. I have a report (FI_ID) based in a query with the same name. When i export this report to my desktop i need to manualy rename the filename. What i need is a way to automatic rename my report to my text field value, called "Seq_Number" (it's a...
Top Bottom