<div>
Oops, I forgot to mention that frmL0S1 in the example above would hold '4/12/02 12:00:00 PM' and should probably be a text field rather than a date field.
</div>


Oops, I forgot to mention that frmL0S1 in the example above would hold '4/12/02 12:00:00 PM' and should probably be a text field rather than a date field.

<div>
Thank you so much<br />
much appreciated
</div>


<div>
Thank you so much<br />
very much appreciated
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
I'm trying to retrieve the last set of records which were inserted into the<br />
database. The records which are inserted include a TimeStart. This variable<br />
is set to Now(). WHat i thought I could do is retrieve the records based on<br />
this value, because the retrieval will be done straight after the update.<br />
The SQL Query is:<br />
datinfo.RecordSource = &quot;SELECT * FROM Records WHERE (Records.TimeStart = &quot;<br />
&amp;frmL0S1.TStart&amp; &quot;)&quot;<br />
<br />
Records.TimeStart is the field where the time is inserted.<br />
frmL0S1.TimeStart stores this time, because this time was carried through a<br />
number of forms before being inserted into the database.<br />
Records.TimeStart is a text field<br />
frmL0S1.TStart is declared as a date field.<br />
I'm not sure if this would be a problem considering the update is working<br />
fine.<br />
I've tried placing single quotation marks around frmL0S1.TStart but that doesn't work<br />
and also converted this to a string but that won't work either!<br />
All help is greatly appreciated.<br />
<br />
Thanks<br />
C<br />

</div>
</div>


Hi all,
I'm trying to retrieve the last set of records which were inserted into the
database. The records which are inserted include a TimeStart. This variable
is set to Now(). WHat i thought I could do is retrieve the records based on
this value, because the retrieval will be done straight after the update.
The SQL Query is:
datinfo.RecordSource = "SELECT * FROM Records WHERE (Records.TimeStart = "
&frmL0S1.TStart& ")"

Records.TimeStart is the field where the time is inserted.
frmL0S1.TimeStart stores this time, because this time was carried through a
number of forms before being inserted into the database.
Records.TimeStart is a text field
frmL0S1.TStart is declared as a date field.
I'm not sure if this would be a problem considering the update is working
fine.
I've tried placing single quotation marks around frmL0S1.TStart but that doesn't work
and also converted this to a string but that won't work either!
All help is greatly appreciated.

Thanks
C


URGENT! SQL Query no working!??

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.