This command (MoveFirst, MoveLast etc) doesnt appear to be available for use
although it appears in the help index. I'm using VB for Excel 2000. Is
that right or is it me ?

Thanks for your help, in advance.

from vbe help index searching for movelast



Move to the first, last, next, or previous record in a specified Recordset
object and make that record the current record.

Syntax

recordset.{MoveFirst | MoveLast [dbRunAsync] | MoveNext | MovePrevious}

The recordset placeholder is an object variable that represents an open
Recordset object.

Remarks

Use the Move methods to move from record to record without applying a
condition.

Caution If you edit the current record, be sure you use the Update method
to save the changes before you move to another record. If you move to
another record without updating, your changes are lost without warning.

When you open a Recordset, the first record is current and the BOF property
is False. If the Recordset contains no records, the BOF property is True,
and there is no current record.

If the first or last record is already current when you use MoveFirst or
MoveLast, the current record doesn't change.

If you use MovePrevious when the first record is current, the BOF property
is True, and there is no current record. If you use MovePrevious again, an
error occurs, and BOF remains True.

If you use MoveNext when the last record is current, the EOF property is
True, and there is no current record. If you use MoveNext again, an error
occurs, and EOF remains True.

If recordset refers to a table-type Recordset (Microsoft Jet workspaces
only), movement follows the current index. You can set the current index by
using the Index property. If you don't set the current index, the order of
returned records is undefined.

Important You can use the MoveLast method to fully populate a dynaset- or
snapshot-type Recordset to provide the current number of records in the
Recordset. However, if you use MoveLast in this way, you can slow down your
application's performance. You should only use MoveLast to get a record
count if it is absolutely necessary to obtain an accurate record count on a
newly opened Recordset. If you use the dbRunAsync constant with MoveLast,
the method call is asynchronous. You can use the StillExecuting property to
determine when the Recordset is fully populated, and you can use the Cancel
method to terminate execution of the asynchronous MoveLast method call.

You can't use the MoveFirst, MoveLast, and MovePrevious methods on a
forward-only-type Recordset object.

To move the position of the current record in a Recordset object a specific
number of records forward or backward, use the Move method.


--
Don Guillett
SalesAid Software

"andrew blakeley" wrote in message
...
This command (MoveFirst, MoveLast etc) doesnt appear to be available for
use
although it appears in the help index. I'm using VB for Excel 2000. Is
that right or is it me ?

Thanks for your help, in advance.

MoveFirst and MoveLast are methods of DAO and ADO.

If you want to use these methods you need to set a reference to one of these
libraries from the VBE:

Tools | References

--
Michael Hopwood (Phobos)


"andrew blakeley" wrote in message
...
This command (MoveFirst, MoveLast etc) doesnt appear to be available for
use
although it appears in the help index. I'm using VB for Excel 2000. Is
that right or is it me ?

Thanks for your help, in advance.

Thanks chaps.



"Michael Hopwood" wrote in message
...
MoveFirst and MoveLast are methods of DAO and ADO.

If you want to use these methods you need to set a reference to one of
these
libraries from the VBE:

Tools | References

--
Michael Hopwood (Phobos)


"andrew blakeley" wrote in message
...
This command (MoveFirst, MoveLast etc) doesnt appear to be available for
use
although it appears in the help index. I'm using VB for Excel 2000. Is
that right or is it me ?

Thanks for your help, in advance.

ah, Easier said than done it appears !

Which one is it , because i've now tried a few which look obvious but cant
seem to get there.





"andrew blakeley" wrote in message
...
Thanks chaps.



"Michael Hopwood" wrote in message
...
MoveFirst and MoveLast are methods of DAO and ADO.

If you want to use these methods you need to set a reference to one of
these
libraries from the VBE:

Tools | References

--
Michael Hopwood (Phobos)


"andrew blakeley" wrote in message
...
This command (MoveFirst, MoveLast etc) doesnt appear to be available
for
use
although it appears in the help index. I'm using VB for Excel 2000.
Is
that right or is it me ?

Thanks for your help, in advance.