Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
01-30-2004, 05:45 AM #1
- Join Date
- Jul 2002
- 51° 03' -78" N -114° 05' 72" W
- Thanked 0 Times in 0 Posts
Emailing a Single report based on a query to the table!
I am useing Access 2002 for this
So I have created a query to email a single report based on the data I have open in the form! problem is that when I click on the button to email the report it ask me what the Inbound_ID is I want that to be carried over for me how would I go about doing that????
Ok so here is my query!
SELECT Employees_Inbound_Query.Initials, Employees_Inbound_Query.Emp_First_Name, Employees_Inbound_Query.Emp_Last_Name, Employees_Inbound_Query.Inbound_ID, FROM Employees_Inbound_Query LEFT JOIN Employees_Soft_Skills_Inbound_Query ON Employees_Inbound_Query.Inbound_ID = Employees_Soft_Skills_Inbound_Query.Inbound_ID
and here is my code
Private Sub Email_Inbound_Report_Click()
On Error GoTo Err_Email_Inbound_Report_Click
Dim stDocName As String
stDocName = "Email_Inbound_Report"
DoCmd.SendObject acReport, stDocName
what ddo I need to change so that it doesnt ask me which inbound_ID everytime??