I have a Stored procedure, which produces a fine Crosstab result when Doubleclicking on the procedure, and supplying the required parameters.
However, when running from a button it runs, and then closes down without showing the result
Set conn = CurrentProject.Connection
conn.Execute ("sp_CrossTab " & "'qtabTIMEData01'," _
& "'WeekText', " _
& "'SortName', " _
& "'WeekNum'"
I have tried both with Paranthesis and without
Any idea how to view the resultset
Regards
Hans
However, when running from a button it runs, and then closes down without showing the result
Set conn = CurrentProject.Connection
conn.Execute ("sp_CrossTab " & "'qtabTIMEData01'," _
& "'WeekText', " _
& "'SortName', " _
& "'WeekNum'"
I have tried both with Paranthesis and without
Any idea how to view the resultset
Regards
Hans