Results 1 to 2 of 2
  1. #1
    vicc is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2013
    Posts
    1

    Delete Record Rows in Access Continuos Form By Command Button

    Hello to alll, I'm a novice in access programming : I created an Order Table and its Continuos form, an append query and a Collection table to append the current entered orders and a delete query to delete all records in the order table. I used 2 command buttons to run append and delete query it works well in deleting the records in the order table but in the continuous form the rows is not deleted only the records and its slow. What I tried is in the first record at the left corner with the triangle sign in the continuos form, I click and drag all the way down till the last to new record so its highlighted and press the delete button and all records deleted with its rows and the form is again ready to enter new set of orders. my question is how can I do that in an access command button not using the append or delete query. Thanks and Kindly Help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,625
    Why are you deleting order records? Don't you need to keep the data? Why are you using append? Are you using bound form for data entry/edit?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-19-2012, 04:30 PM
  2. Replies: 2
    Last Post: 05-11-2012, 11:52 AM
  3. add toolbar command button to access form?
    By markjkubicki in forum Forms
    Replies: 1
    Last Post: 01-26-2012, 07:11 PM
  4. Error handling for delete record command
    By jobrien4 in forum Access
    Replies: 2
    Last Post: 09-16-2011, 11:00 AM
  5. Command button help - delete record
    By Zukster in forum Forms
    Replies: 0
    Last Post: 08-27-2009, 08:47 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums