murray83
Games Collector
- Local time
- Today, 15:13
- Joined
- Mar 31, 2017
- Messages
- 728
Hi All
2 questions in one day i am sorry, but in need of a little help this is my code
which should in theory save the report with the date of the query but it just falls flat and highlights the following point of code, i must admit i took the & bit from my saving for excel so may have got the data wrong
so any help would be great and promise last question for today and this week
2 questions in one day i am sorry, but in need of a little help this is my code
Code:
Private Sub cmdQuery3_Click()
Dim mypath As String
Dim strReportName As String
Dim sEmailTo As String
DoCmd.OpenReport "Query3", acViewPreview
mypath = "G:\GENERAL\STOCK\supplier compliance\BWS Supplier Compliance\BWS Compliance DB\PercentageVsLoad\"
strReportName = "BWS Percentage Of Faults For" & [Which Date] & ".pdf"
DoCmd.OutputTo acReport, "", acFormatPDF, mypath & strReportName, False
End Sub
which should in theory save the report with the date of the query but it just falls flat and highlights the following point of code, i must admit i took the & bit from my saving for excel so may have got the data wrong
so any help would be great and promise last question for today and this week