+ Reply to Thread
Results 1 to 4 of 4

run-time error '3021': Either BOF or EOF is true, or the current record has been deleted.

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    run-time error '3021': Either BOF or EOF is true, or the current record has been deleted.

    i am trying to update my excel sheet using this code but i am getting this error Please help me out

    Please Login or Register  to view this content.
    exxample:

    SMD_ID Level (1/2/3) Itemnum Original Mfg Name Original Mfg Part # Original_Description

    1 level1 dsfgsd dfgs dsfgsfg adfgdsagaf

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: run-time error '3021': Either BOF or EOF is true, or the current record has been dele

    Where do you get the error?
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: run-time error '3021': Either BOF or EOF is true, or the current record has been dele

    Please Login or Register  to view this content.
    here in this line

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: run-time error '3021': Either BOF or EOF is true, or the current record has been dele

    That would seem to imply your Find failed, in which case you need to add a new record.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 06-03-2014, 12:29 AM
  2. Runtime error 3021 Either BOF or EOF is true or the current record has been deleted.
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-19-2011, 01:52 PM
  3. How to record current time, without vba
    By susato in forum Excel General
    Replies: 2
    Last Post: 11-02-2010, 02:42 PM
  4. Error 3021: Either EoF or BoF is True.
    By NBVC in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 04-26-2010, 12:42 PM
  5. Blocking Error 3021 No current record
    By dbl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2005, 09:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1