<div>
&lt;my table on the SQL-2008-Server will be sorted&gt;<br />
Sorted how...?<br />
<br />
You can certainly do this by modifying the &quot;Order By&quot; property of the form<br />
<br />
I don't see a need to go all the way back the the SQL server table and change the sort...<br />
:-O<br />
<br />
Private Sub YourButton_Click()<br />
&nbsp; &nbsp; Me.OrderBy = &quot;YourField&quot;<br />
&nbsp; &nbsp; Me.OrderByOn = True<br />
&nbsp; &nbsp; Me.Requery<br />
End Sub<br />
<br />
<br />
JeffCoachman
</div>


<div>
<br />
To be more syntactically correct:<br />
<br />
Me.OrderBy = &quot;YourField ASC&quot;<br />
Or<br />
Me.OrderBy = &quot;YourField DESC&quot;<br />

</div>


<div>
ok, works, but strange as in my Access-book, it was said that I have to sort on SQL as it won't work on Access but didn't gave an example. May I ask one added as I filter right now on the Server as well and not in the form like<br />
<br />
With cmd<br />
&nbsp; &nbsp; .ActiveConnection = c<br />
&nbsp; &nbsp; .CommandText = &quot;sp_Modell_V1_tblStatistik<wbr />ChartTmp&quot;<br />
&nbsp; &nbsp; .CommandType = adCmdStoredProc<br />
&nbsp; &nbsp; .CommandTimeout = 0<br />
&nbsp; &nbsp; .Parameters.Append .CreateParameter(&quot;@Auswahl<wbr />&quot;, adVarChar, adParamInput, 100, &quot;Index&quot;)<br />
&nbsp; &nbsp; .Parameters.Append .CreateParameter(&quot;@Auswahl<wbr />_Detail&quot;, adVarChar, adParamInput, 100, Me.Index.Value)<br />
&nbsp; &nbsp; .Execute<br />
End With<br />
c.Close<br />
Set c = Nothing<br />
Set cmd = Nothing<br />
<br />
Is there a more direct way on the form as well?
</div>


<div>
many thx, I hope the split goes ok for both<br />
rgds<br />
Kongta
</div>


<div>
&lt;I would like to implement an Click-Event where then my table on the SQL-2008-Server will be sorted and after I refresh my form an will then get the sorted results&gt;<br />
Remember to always just state your &quot;Ultimate Goal&quot;, (Sort/Filter a form), not the way you think it should be done...<br />
;-)<br />
<br />
...in case there is a more efficient technique...<br />
;-)<br />
<br />
Glad I could help...<br />
;-)<br />
<br />
JeffCoachman
</div>


<div>
<div class="content wysiwyg-content">
I do have a Access form where I would like to implement an Click-Event where then my table on the SQL-2008-Server will be sorted and after I refresh my form an will then get the sorted results. Whats the easiest way to do that?<br />
thx<br />
Kongta
</div>
</div>


I do have a Access form where I would like to implement an Click-Event where then my table on the SQL-2008-Server will be sorted and after I refresh my form an will then get the sorted results. Whats the easiest way to do that?
thx
Kongta

SQL Sort by through Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.