<div>
reason being there is no space for your joined string and that created an syntax error<br />
<br />
&gt;&gt;&nbsp;Set rsBooked = &quot;SELECT ID FROM tblBooked<b>&quot; &amp;&nbsp;&quot;</b>ORDER BY [ID] ASC&quot;
</div>


reason being there is no space for your joined string and that created an syntax error

>> Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"

<div>
Why not simply:<br />
<br />
&nbsp; &nbsp; Set rsBooked = &quot;SELECT ID FROM tblBooked ORDER BY [ID] ASC&quot;<br />
<br />
or:<br />
<br />
&nbsp; &nbsp; Set rsBooked = &quot;SELECT ID FROM tblBooked ORDER BY 1&quot;<br />
<br />
/gustav
</div>


Why not simply:

    Set rsBooked = "SELECT ID FROM tblBooked ORDER BY [ID] ASC"

or:

    Set rsBooked = "SELECT ID FROM tblBooked ORDER BY 1"

/gustav

<div>
everyone is focusing on the SQL, except Rgonzo.<br />
<br />
1. &nbsp;you have to define the SQL correctly, Rgonzo did this &nbsp;although I cannot understand at all why anybody feels the need to define the SQL string by separating the SELECT and Order By clauses:<br />
<br />
strSQL = &quot;SELECT ID FROM tblBooked ORDER BY ID&quot;<br />
<br />
2. &nbsp;The second is that cannot open a recordset by setting a value to a string.<br />
<br />
set rsBooked = currentdb.OpenRecordset(st<wbr />rSQL, , dbfailonerror)
</div>


everyone is focusing on the SQL, except Rgonzo.

1.  you have to define the SQL correctly, Rgonzo did this  although I cannot understand at all why anybody feels the need to define the SQL string by separating the SELECT and Order By clauses:

strSQL = "SELECT ID FROM tblBooked ORDER BY ID"

2.  The second is that cannot open a recordset by setting a value to a string.

set rsBooked = currentdb.OpenRecordset(strSQL, , dbfailonerror)

<div>
Gustav Brock<br />
<br />
Getting same error as with my example Compile error Type mismatch. Tried Ryans version same result<br />
<br />
Alan
</div>


Gustav Brock

Getting same error as with my example Compile error Type mismatch. Tried Ryans version same result

Alan

<div>
Dale Fye<br />
<br />
You are correct just tried Rgonzo 1971 and it worked. Thank you for your comment<br />
<br />
Alan
</div>


Dale Fye

You are correct just tried Rgonzo 1971 and it worked. Thank you for your comment

Alan

<div>
Thank your all for your help
</div>


<div>
<div class="content wysiwyg-content">
Hi EE<br />
<br />
I have the following and a mental block<br />
Set rsBooked = &quot;SELECT ID FROM tblBooked&quot; &amp;&nbsp;&quot;ORDER BY [ID] ASC&quot;<br />
<br />
Not working where have I gone wrong. Any help appreiated<br />
<br />
chestera
</div>
</div>


Hi EE

I have the following and a mental block
Set rsBooked = "SELECT ID FROM tblBooked" & "ORDER BY [ID] ASC"

Not working where have I gone wrong. Any help appreiated

chestera

ORDER BY

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.