[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Correct the code from a book

Posted on 2000-02-11
3
Medium Priority
?
128 Views
Last Modified: 2010-05-02
following is the code I copied from a book. I think it is not correct!
If you think so, tell me how to correct it.

    With Adodc1.Recordset
        .Delete
        If Not .EOF Then
            .MoveNext
        Else
            .MoveLast
        End If
    End With
0
Comment
Question by:learn
  • 2
3 Comments
 
LVL 9

Expert Comment

by:Ruchi
ID: 2512927
Hope this works.

With Adodc1.Recordset
  .Delete
  .MoveNext
If .EOF then
  .MovePrevious
End If
End With
0
 
LVL 9

Accepted Solution

by:
Ruchi earned 160 total points
ID: 2512936
   With Adodc1.Recordset
        .Delete
        .MoveNext
        If .EOF Then .MoveLast
    End With  

0
 

Author Comment

by:learn
ID: 2514246
Yes, it works.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question