QBF seemingly not connecting with query

[akirekab]

I am tired, as I have done this or similar things many times, I am not seeing the problem here.

I will run a query producing the following SQL

 
SELECT tblInterviewRecord.FaceToFaceReasonID, tblInterviewRecord.InterviewtypeID, tblInterviewRecord.ContactDate, tblEmployees.Initials, tblInterviewRecord.ServiceTypeID, tblFaceToFaceReason.FaceToFaceReason
FROM tblEmployees INNER JOIN (tblInterviewRecord INNER JOIN tblFaceToFaceReason ON tblInterviewRecord.FaceToFaceReasonID = tblFaceToFaceReason.FaceToFaceReasonID) ON tblEmployees.EmployeeID = tblInterviewRecord.EnteredBy
WHERE (((tblInterviewRecord.InterviewtypeID)=2) AND ((tblInterviewRecord.ContactDate)>=[Forms]![frmProductivity]![txtStartDate] And (tblInterviewRecord.ContactDate)<=[Forms]![frmProductivity]![txtEndDate]) AND ((tblEmployees.Initials)=[Forms]![frmProductivity]![cboInitials])) OR (((tblInterviewRecord.FaceToFaceReasonID)=3) AND ((tblInterviewRecord.InterviewtypeID)=1) AND ((tblInterviewRecord.ContactDate)>=[Forms]![frmProductivity]![txtStartDate] And (tblInterviewRecord.ContactDate)<=[Forms]![frmProductivity]![txtEndDate]) AND ((tblEmployees.Initials)=[Forms]![frmProductivity]![cboInitials]));
 

And the code of the button to run the Query is this:

 Private Sub cmdRunQuery_Click() 
On Error GoTo Err_cmdRunQuery_Click
 
Dim stDocName As String
stDocName = "qryProductivity2Query"
 
DoCmd.OpenQuery stDocName
 
Exit_cmdRunQuery_Click:
Exit Sub
 
Err_cmdRunQuery_Click:
MsgBox Err.Description
Resume Exit_cmdRunQuery_Click
 
End Sub
 

I have seen the term dialog form, but not sure what is meant. Should I construct it differently than any other form, ie I used the employee table as base for form, but really dont need a base, just assumed I needed something.
I ran the query with manual input and it runs fine and returns correct data, which means it is something not connecting with the input to the form.

thanks for any help
Ken

[puppydogbuddy]

I am tired, as I have done this or similar things many times, I am not seeing the problem here.

I will run a query producing the following SQL

(CODE)
SELECT tblInterviewRec ord.FaceToFaceR easonID, tblInterviewRec ord.Interviewty peID, tblInterviewRec ord.ContactDate , tblEmployees.In itials, tblInterviewRec ord.ServiceType ID, tblFaceToFaceRe ason.FaceToFace Reason
FROM tblEmployees INNER JOIN (tblInterviewRe cord INNER JOIN tblFaceToFaceRe ason ON tblInterviewRec ord.FaceToFaceR easonID = tblFaceToFaceRe ason.FaceToFace ReasonID) ON tblEmployees.Em ployeeID = tblInterviewRec ord.EnteredBy
WHERE (((tblInterview Record.Intervie wtypeID)=2) AND ((tblInterviewR ecord.ContactDa te)>=[Forms]![frmProductivity]![txtStartDate] And (tblInterviewRe cord.ContactDat e)<=[Forms]![frmProductivity]![txtEndDate]) AND ((tblEmployees. Initials)=[Forms]![frmProductivity]![cboInitials])) OR (((tblInterview Record.FaceToFa ceReasonID)=3) AND ((tblInterviewR ecord.Interview typeID)=1) AND ((tblInterviewR ecord.ContactDa te)>=[Forms]![frmProductivity]![txtStartDate] And (tblInterviewRe cord.ContactDat e)<=[Forms]![frmProductivity]![txtEndDate]) AND ((tblEmployees. Initials)=[Forms]![frmProductivity]![cboInitials]));
(/CODE)

And the code of the button to run the Query is this:

(CODE)
Private Sub cmdRunQuery_Cli ck()
On Error GoTo Err_cmdRunQuery _Click

Dim stDocName As String
stDocName = "qryProductivit y2Query"

DoCmd.OpenQuery stDocName

Exit_cmdRunQuer y_Click:
Exit Sub

Err_cmdRunQuery _Click:
MsgBox Err.Description
Resume Exit_cmdRunQuer y_Click

End Sub
(/CODE)

I have seen the term dialog form, but not sure what is meant. Should I construct it differently than any other form, ie I used the employee table as base for form, but really dont need a base, just assumed I needed something.
I ran the query with manual input and it runs fine and returns correct data, which means it is something not connecting with the input to the form.

thanks for any help
Ken

A dialog form is just that, a form that "carries on a dialog with the user" in the form of prompts that require responses from the user.

In regards to your query, you did not speifically state what happens when the code runs, And when you say it runs correctly with manual input.....are you getting prompted to enter something? What happens exactly?

This portion of your select list in your SQL statement looks incorrect:
tblFaceToFaceRe ason.FaceToFace Reason <<<<<should that be
tblFaceToFaceRe ason.FaceToFace ReasonID <<<<<this

[akirekab]

A dialog form is just that, a form that "carries on a dialog with the user" in the form of prompts that require responses from the user.

In regards to your query, you did not speifically state what happens when the code runs, And when you say it runs correctly with manual input.....are you getting prompted to enter something? What happens exactly?

This portion of your select list in your SQL statement looks incorrect:
tblFaceToFaceRe ason.FaceToFace Reason <<<<<should that be
tblFaceToFaceRe ason.FaceToFace ReasonID <<<<<this

Thanks for reading thru this, I know it looks conflomerated.
When I just open the query, it asks for both dates and the initials, even though I have the form open, with the info in the cbo and txt boxes. Again I havee numerous applications and places where I have parameter input, from forms and I have no issues, but for some reason, it is ignoring this form.

I of course have triple checked the names of the cbo and txt boxes, names of the query, names of the forms, and yet it is not working.

I appreciated you looking at it, I know without the entire app section it would be tough to figure out. I will work more and rephrase my question if I don't figure it out. Thank you so much. Ken

[puppydogbuddy]

Thanks for reading thru this, I know it looks conflomerated.
When I just open the query, it asks for both dates and the initials, even though I have the form open, with the info in the cbo and txt boxes. Again I havee numerous applications and places where I have parameter input, from forms and I have no issues, but for some reason, it is ignoring this form.

I of course have triple checked the names of the cbo and txt boxes, names of the query, names of the forms, and yet it is not working.

I appreciated you looking at it, I know without the entire app section it would be tough to figure out. I will work more and rephrase my question if I don't figure it out. Thank you so much. Ken

There is one thing you can do.....declare your parameters. To do that, place your query in design view, then go to the command menu and select query>parameter s, then supply the name and data type of your parameters. Sometimes Access needs this info because it can't or won't pick a data type for your parameters.