Search results

The error I get is…S R Project Database cant fiend the field `|` referred to in your expression. Then it points to… Reports!rptworkauth.Caption = [Project Number]. I had the “End If” in there because originally I was toying with the report also being sent to outlook as a email attachment.

Hey Paul, Since you were a huge help last time I thought I would a new code past you. This one is very complicated to me. I would like this code to save the current report as pdf to specific folder, if this folder already exists, then pdf will be created, if the folder doesn't exist then the...

Hello Speakers_86, I have decided to go a different direction, I would like this code to save the current report as pdf to specific folder, if this folder already exists, then pdf will be created, if the folder doesn't exist then the folder will be created and then pdf. The name of this report...

Hello Speakers_86, I think I have a better understanding of the code. Below is the code I think will work, however when I try to run it, I get an error on the myReportDir saying "Compile Error Variable Not Defined".Any idea why? I should tell you that this command is under a button on a form...

I can't seem to get this to work. Private Sub Command164_Click() On Error GoTo ErrorHandler Dim myCurrentDir As String Dim myReportOutput As String Dim myMessage As String myCurrentDir = CurrentProject.Path & "H:\" myReportDir = myCurrentDir & "Reports" & "\"...

Access 2007.

Hello, How do I save a report to PDF with VBA code? Name that File with a project number and the Report Name Then send it to a certain File Path? All with the click of a button. Any ideas? Regards, Holly

Thank you very much Paul! It worked perfectly!:D

When I enter the vendor, then media type, then project expense TAT. It should give me the correct price when it has met all the criteria however it is not matching with the correct price for the entered criteria. Any thoughts? strsql = "SELECT * from [tbl sr lab rates] where [lab] ='" &...