Search results

Thanks everyone for your help. Many thanks to Pat Hartman for the solution to the problem. I have been trying to get this problem fixed for a long time. Thanks a million Pejayuk :D :) :cool:

It would seem that this forum is inserting the space. If I paste the SQL query into NOTEPAD, there is no space. When I paste it into the textbox to poste the statement it still has no space, but when viewing it on the forum after it is posted the space appears.!. ???!!!!:confused:

The space must of been me when I paisted it in, as the space isn't in the query and the query works fine. Here is the SQL statement again. SELECT EmpDetails.EmpID, EmpDetails.JobTypeID, EmpDetails.Name FROM EmpDetails WHERE...

That would be [Forms]![frmFindEmpByJobType]![comboJob TypeSelected].

Here is the code, tables, query, and relationship #####Code that returns the data to show the query works ##### Private Sub Command3_Click() On Error GoTo Err_Command3_Click Dim stDocName As String stDocName = "qryFindEmpByJobType" DoCmd.OpenQuery stDocName, acNormal, acEdit...

Checked. I have checked the code and it works fine when the criteria isn't liked to a form object (Text box, combo box etc.). If the infomation is paisted into the prompt I get the result I want so the query works. The form is open and when the query is called from a button it works. But I need...

I am using Ms Access 2000, and have created a Query that uses the value held in a forms object as the criteria. This query when run from a button returns the results fine in a datasheet. However, when I try to use this query in VBA DAO to return a recordset that I can manipulate, I get prompted...