Stored Procedure message in Access

[MrsMope]

Good Morning,
I have a stored procedure stored within access (spJobTime) this stored procedure has the following code.

SELECT     dbo.Job.JobNumber, dbo.Customer.Name, dbo.Job.Description, dbo.Employee.Name AS DesignerName, dbo.Employee.Name AS SalesmanName, 
                      dbo.Job_Item.Job_Item_ID, dbo.fn_GetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'JigSetupRE') AS JigSetupRE, 
                      dbo.fn_GetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'StockingRE') AS StockingHours, 
                      dbo.fn_GetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'AssemblyRE') AS AssemblyHours, 
                      dbo.fn_GetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'PlyRE') AS Expr1, SUM(dbo.fnGetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 
                      'JigSetupRE') + dbo.fnGetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'StockingRE') 
                      + dbo.fnGetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'AssemblyRE')) AS TotalHours, dbo.Job_Item.Description AS ItemDescription, 
                      dbo.Job_Item.Quantity, dbo.Job_Item_WoodTruss.TCSize, dbo.Job_Item_WoodTruss.BCSize, dbo.Job_Item_WoodTruss.TCPitch, 
                      dbo.Job_Item_WoodTruss.BCPitch, dbo.Job_Item_WoodTruss.Span, dbo.City_ID.City_Name, 
                      dbo.fn_GetCustomJobItemDataAPI3(dbo.Job_Item.Job_Item_ID, 'PricedAs') AS Type, dbo.fn_GetCustomJobItemDataAPI2(dbo.Job_Item.Job_Item_ID, 
                      'MatchShell') AS MatchShell
INTO            dbo.tmpJobTime
FROM         dbo.Customer INNER JOIN
                      dbo.Job ON dbo.Customer.Customer_ID = dbo.Job.Customer_ID INNER JOIN
                      dbo.Employee ON dbo.Customer.Employee_ID = dbo.Employee.Employee_ID AND dbo.Job.Salesman_ID = dbo.Employee.Employee_ID AND 
                      dbo.Job.Designer_ID = dbo.Employee.Employee_ID INNER JOIN
                      dbo.EmployeeCategory_ID ON dbo.Employee.EmployeeCategory_ID = dbo.EmployeeCategory_ID.EmployeeCategory_ID INNER JOIN
                      dbo.Address_ID ON dbo.Job.Address_ID = dbo.Address_ID.Address_ID INNER JOIN
                      dbo.Job_Item ON dbo.Job.Job_ID = dbo.Job_Item.Job_ID INNER JOIN
                      dbo.Category_ID ON dbo.Job_Item.Category_ID = dbo.Category_ID.Category_ID INNER JOIN
                      dbo.Job_Item_WoodTruss ON dbo.Job_Item.Job_Item_ID = dbo.Job_Item_WoodTruss.Job_Item_ID INNER JOIN
                      dbo.v_SelectedRecord ON dbo.Job.JobNumber = dbo.v_SelectedRecord.Job_ID INNER JOIN
                      dbo.City_ID ON dbo.Address_ID.City_ID = dbo.City_ID.City_ID
GROUP BY dbo.Job.JobNumber, dbo.fn_GetCustomJobItemDataAPI3(dbo.Job_Item.Job_Item_ID, 'PricedAs'), 
                      dbo.fn_GetCustomJobItemDataAPI2(dbo.Job_Item.Job_Item_ID, 'MatchShell'), dbo.fn_GetCustomJobItemDataAPI(dbo.Job_Item.Job_Item_ID, 'PlyRE'), 
                      dbo.Customer.Name, dbo.Job.Description, dbo.Employee.Name, dbo.Employee.Name, dbo.Job_Item.Job_Item_ID, dbo.Job_Item.Description, 
                      dbo.Job_Item.Quantity, dbo.Job_Item_WoodTruss.TCSize, dbo.Job_Item_WoodTruss.BCSize, dbo.Job_Item_WoodTruss.TCPitch, 
                      dbo.Job_Item_WoodTruss.BCPitch, dbo.Job_Item_WoodTruss.Span, dbo.City_ID.City_Name

It is set as a 'Make table query', whenever I run this I recieve a message: [red]The stored procedure executed successfully but did not return any records[/red] Which is untrue, I check for my table and it has been created. I want to hide this message, how do I do this?

 

[dhookom]

The stored procedure does not "return" records. It creates a table which is different. You can open the P-T query in design view and set the returns records to No.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[MrsMope]

I don't have a pass thru query though, I have the stored procedure which is creating the table. I don't have a returns record property on the stored procedure.

 

[cmmrfrds]

Try in the stored procedure.
Set Nocount = on

This will suppress informational messages being returned from the stored procedure.

 

[MrsMope]

I turned the NoCOUNT On, but I still get the message.