<div>
Hi there,<br />
<br />
Is this any help:-<br />
<br />
Set qry = CurrentDB.CreateQueryDef(&quot;<wbr />&quot;, &quot;Select * from &lt;TableName&gt;&quot;) <br />
<br />
rather than use seek use find first after the previous line like this:-<br />
<br />
Set rst = qry.OpenRecordset()<br />
With rst<br />
&nbsp;.FindFirst (&quot;UserName = '&quot; &amp;&nbsp;sUserNameEntered &amp;&nbsp;&quot;' AND UserPWD = '&quot; &amp;&nbsp;sPasswordEntered &amp;&nbsp;&quot;'&quot;)<br />
<br />
hope this helps<br />
<br />
Regards,<br />
<br />
Coggie<br />

</div>


Hi there,

Is this any help:-

Set qry = CurrentDB.CreateQueryDef("", "Select * from <TableName>")

rather than use seek use find first after the previous line like this:-

Set rst = qry.OpenRecordset()
With rst
 .FindFirst ("UserName = '" & sUserNameEntered & "' AND UserPWD = '" & sPasswordEntered & "'")

hope this helps

Regards,

Coggie


<div>
<div class="content wysiwyg-content">
I am familiar with SQL in Visual Foxpro. Obviously SQL in VB is a little different! &nbsp; Where do I put a SQL statement (other than the recordsource property of a data control)that will return results to a flex grid? (I would rather not use debug.print to show the results). I would also like to allow the user, I guess through seek, to determine the search variable.<br />
<br />
Thanks!
</div>
</div>


I am familiar with SQL in Visual Foxpro. Obviously SQL in VB is a little different!   Where do I put a SQL statement (other than the recordsource property of a data control)that will return results to a flex grid? (I would rather not use debug.print to show the results). I would also like to allow the user, I guess through seek, to determine the search variable.

Thanks!

VB SQL

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.