<div>
I don't have Vb to hand at the moment. Could I use the recordset.move last to go to the last record and then then recordset.absoluteposition<wbr /> to determine what position the cell is and get the data from it. There must be an easier way surely?
</div>


I don't have Vb to hand at the moment. Could I use the recordset.move last to go to the last record and then then recordset.absoluteposition to determine what position the cell is and get the data from it. There must be an easier way surely?

<div>
Hmmm. This partialy works but returns the whole record, not specific fields..<br />
<br />
ARecordset.MoveLast<br />
<br />
MsgBox ARecordset.GetString
</div>


Hmmm. This partialy works but returns the whole record, not specific fields..

ARecordset.MoveLast

MsgBox ARecordset.GetString

<div>
<br />
Got it! This seems to do what I want...<br />
<br />
ARecordset.MoveLast<br />
MsgBox (ARecordset.Fields(&quot;a1&quot;))<br />

</div>



Got it! This seems to do what I want...

ARecordset.MoveLast
MsgBox (ARecordset.Fields("a1"))


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I'm using DAO to connect to an access database. The DB populates a DataGrid.<br />
<br />
How do I to retrieve the data from the last populated record. Eg if my records and fiels are populated as below, I would want to return either dd &nbsp;from the A1 record. The columns will be populated with a varying amount of data...<br />
<br />
Thanks, Dave.<br />
<br />
A1 &nbsp; A2 etc etc<br />
aa &nbsp; zz<br />
bb &nbsp; xx<br />
cc &nbsp; gg<br />
dd &nbsp;hh<br />
<br />

</div>
</div>


Hi,

I'm using DAO to connect to an access database. The DB populates a DataGrid.

How do I to retrieve the data from the last populated record. Eg if my records and fiels are populated as below, I would want to return either dd  from the A1 record. The columns will be populated with a varying amount of data...

Thanks, Dave.

A1   A2 etc etc
aa   zz
bb   xx
cc   gg
dd  hh



ADO Get data from last populated record

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.