Results 1 to 4 of 4
  1. 02-16-2014, 11:10 PM #1
    drunkenneo
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199

    Code to delete the blank rows

    I have seached all but coudn't find,


    Click image for larger version.  Name: Clipboard01.jpg  Views: 17  Size: 7.0 KB  ID: 15430


    I want to code as my cellposition is currently at 9th row and i want to deleted all blank rows till i find filled row in this case 16.

    Please Help
    Reply With Quote Reply With Quote
  2. 02-17-2014, 01:24 AM #2
    Bob Fitz's Avatar
    Bob Fitz
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,544
    Perhaps you just need to create a Delete query and use Is Null as the criteria.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick
    Reply With Quote Reply With Quote
  3. 02-17-2014, 08:30 AM #3
    ipisors
    ipisors is offline Access Developer
    Windows XP Access 2007
    Join Date
    Sep 2013
    Posts
    119
    Did you mean to post this in an Access or Excel forum? Your terminology and screenshot looks like Excel, not Access.
    Reply With Quote Reply With Quote
  4. 02-17-2014, 09:26 PM #4
    drunkenneo
    drunkenneo is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    199
    Its a code for the VBA, any how i solved the matter.

    I searched for blank and deleted the row, entire.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to remove blank rows when I import from excel
    By timpepu in forum Import/Export Data
    Replies: 3
    Last Post: 09-14-2015, 04:04 PM
  2. delete record if 2 fields are blank
    By rlsublime in forum Access
    Replies: 1
    Last Post: 06-20-2012, 01:58 PM
  3. code to delete rows based of empty cells
    By jcbrackett in forum Programming
    Replies: 3
    Last Post: 03-05-2012, 02:27 PM
  4. Delete Rows with Same ID and Due Date??
    By taimysho0 in forum Programming
    Replies: 2
    Last Post: 03-01-2012, 12:14 PM
  5. Hiding rows when blank in a report.
    By ser01 in forum Reports
    Replies: 0
    Last Post: 02-27-2010, 10:29 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums