Search results

I did thank you twice :) and added reputation

Solution Found. DoCmd.OpenReport "Total Report", acViewPreview, , "ProjectNumber='" & !ProjectNumber & "'" DoCmd.OutputTo acOutputReport, "Total Report", acFormatPDF, MyPath & MyFileName DoCmd.Close acReport, "Total Report"

Hoe to Filter the Report Paul? :)

Hi Paul, How to filter the Report please?

Please see attached

Please see attached

Hi, Paul thnx I have already done that, how can I send you the db?

Private Sub PrintAll_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim MyPath As String Dim MyFileName As String Dim MyProjectNumber As String Dim MyProjectName As String MyPath = "C:\Reports\" Set db = CurrentDb() Set rs = db.OpenRecordset("SELECT...

Hi Paul, What I'm trying to do is print all the reports in separate files, at C:\Reports. Print each record with Project Numb + Project Name Done. Problem instead of printing only one record inside the report, is printing all of them.

same results

Dear Paul you jocking or testing me?:) that wont do anything

Trying to make this code work, don't know how to filter as it prints identical all reports. Private Sub cmdExportPDF_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim MyPath As String MyPath = "C:\Reports" If Len(Dir(MyPath, vbDirectory)) < 1 Then MkDir (MyPath) End If Dim...

Trying to Compare 2 fields Status with answers Yes or No, from 2 Tables PipeLine and Pipe, and get the fields that don't match, what am i doing wrong? SELECT PipeLine.[Project Name], PipeLine.[Capacity DC], PipeLine.[Project Num], PipeLine.[Status] FROM PipeLine LEFT JOIN Pipe ON...