S
Sandy
Hi All,
I am trying to learn MS Access, so please bear with me.
I built a Report and named it Report 1. Then a built a
Form (Form1) and place a command button, where the data
source it Report 1. I need to somehow export Report 1 to
the same location everytime, but Access will automatically
Save the report as today's date -if this is even possible
to do.
Another question, can Access Save Reprots in PDF format?
Below is my command button sql:
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim stDocName As String
stDocName = "Report1"
DoCmd.OutputTo acReport, stDocName
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub
I am trying to learn MS Access, so please bear with me.
I built a Report and named it Report 1. Then a built a
Form (Form1) and place a command button, where the data
source it Report 1. I need to somehow export Report 1 to
the same location everytime, but Access will automatically
Save the report as today's date -if this is even possible
to do.
Another question, can Access Save Reprots in PDF format?
Below is my command button sql:
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim stDocName As String
stDocName = "Report1"
DoCmd.OutputTo acReport, stDocName
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub