Recent content by kstinnett

  1. K

    Solved Pass Parameter from Form to Report

    First of all thanks so much that took care of it. Secondly, I am aware of the Underscore but I get in a hurry sometimes because this isn't my full time job but I greatly appreciate the reminder. I will go back and clean all of that up. lastly, the name field is not mine it is connected to my...
  2. K

    Solved Pass Parameter from Form to Report

    SELECT [Course Catalog].[Course Name], [Course Completed].[Date Completed], Erp_EmpBasic.Name, [Course Completed].CourseID FROM Erp_EmpBasic INNER JOIN ([Course Completed] INNER JOIN [Course Catalog] ON [Course Completed].CourseID = [Course Catalog].ID) ON Erp_EmpBasic.EmpID = [Course...
  3. K

    Solved Pass Parameter from Form to Report

    I am thinking this isn't what you are asking for but I am not sure if this isn't it where to find what you are really asking for. Private Sub Command13_Click() Dim strParamValue As String strParamValue = Me.txtCourseName.Value ' Get value from text box DoCmd.OpenReport...
  4. K

    Solved Pass Parameter from Form to Report

    I took the parameter out of the query and put your code in but now its popping up the normal parameter box when I run it. Sorry if I missing something simple.
  5. K

    Solved Pass Parameter from Form to Report

    Appreciate all the feedback. I am not a programmer. I have learned a lot on my own but I am not sure how I need to change this to get it to work from your responses. Could either one of you provide me more detail. I just took the code from a google search and I have modified it several times...
  6. K

    Solved Pass Parameter from Form to Report

    I am having issue with a "type mismatch" when I click my button to run a report with a parameter in the form. I have searched for the exact syntax but I am having issues finding it. Here is my code. I am using a combo box to pick my criteria for the query that the report is based on. ANy help...
Back
Top Bottom